I work for a company that puts on trade and consumer shows.
I would like to set up a spreadsheet to cteate a calendar for all the shows.
There are certain tasks that need to be done for every show 1 year out,
6 months out, 3 months out, 4 weeks, 2 weeks, 10 days, etc etc
I am thinking of having the first sheet in the workbook listing all the
shows with their dates.
Based on the date of the show, I would like Calc to list tasks that need
to be done.
1 year out... task 1
6 months out.....task 2
4 months out...task 3
3 months out..task 4
1 month out...task 5
1 week out...task 6
etc etc
I will create a list of the tasks, I just want Calc to calculate the
dates each task needs to be completed based on the date of the show.
I am not sure if I want a separate sheet for each event or one sheet for
all events & tasks because we are often working on multiple events at
the same time.
I hope I have been clear enough for people to understand.
Thanks!!
...Lisa
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
