I've been using Excel to manage tasks for a marketing team. Overall, it is doing what I need. But it is becoming unwieldy very quickly. I find that a lot of our tasks are very similar, with only due dates changing. They are set activities that need to be done by fixed people, at a fixed proximity to an event.
I have attached the excel spreadsheet for anyone is willing to help me with advice. But here is the basic cell structure:
The first two columns are the only information I fill in. (Event Type is chosen from a drop down). The rest of the information is generated through nested IF formula's.
Date Event Type Artwork Type Artwork Due Bulletin Entry Post 1 Date Post 1 Content 25-Dec-15 Fun/Occassional Standard 10-Dec-15 20-Dec-15 15-Dec-15 Short announcement of event
I have been told this could be much better achieved with Access. But I've never worked with Access and, quite frankly, have no idea where to start.
Does anyone know how to do this? I would appreciate the help!
Test.zip