Expected duration: less than 1 week I have an old version of an excel timeline I made that included calculation so I could change project schedule dates. I could see the layout of the whole project but also had separate tabs that just showed which tasks were assigned to different roles. Please see screen shot. However because I kept adapting it from what it started into what it tuned into, every time i edited something I manually had to edit each tab.
Its now time to make a new one but I want to better automate it so Im not making the same change on each tab, but rather change the data on the master sheet and then either use graphs on each tabs that automatically change or set it with with slicers so I can click on what I want to see.
The new file will have master data but also helper cells to show who each task is assigned and which tabs I want it to show on.
Please advise if this is possible to be done, look nice, and is easy to use.
SEO & Social Media Specialist Needed Category: Facebook Marketing, Internet Marketing, Link Building, SEO, Social Media Marketing Budget: $30 - $250 USD