Hi all,
I am currently creating a workbook that will email all department of my ship everyday about upcoming vessel movements (we are at anchor for a prolonged period so everything comes and leaves via a boat of some sort.)
I have got half way there by creating the forms and tabs and copying some bits from templates.
The last part I am really struggling with though. I would like the SalesRpt sheet to auto populate all data from today's date and tomorrow''s (this sheet is where the pdf is created.)
I seem only to be able to get info for one instance of today's date but where there are two or more expected events I can't figure out how to show this. A kind of schedule may work but I can;t do it. Ideally I would like it to show "Upcoming Movements for Today" and "Upcoming Movements for Tomorrow". It should then only show movements for the day but show all of them.