I use Excell:2011 for a Mac and want to copy and link data from one worksheet (master production schedule for the year) to "sub-worksheets" (individual projects by month). I've used Advanced Filter, and while it will copy data, it doesn't link the information back to the master worksheet so that I can make changes on the master and have them reflected on the "sub-worksheets."
Can you help point me in the right direction?
Before all you experts get excited about dynamic tables, macro's and such, I'm not all that familiar with Excel (hence, my need for assistance!). Please keep your explanations simple. I'm not too proud to admit I don't know very much about Excel.
Thanks!
Can you help point me in the right direction?
Before all you experts get excited about dynamic tables, macro's and such, I'm not all that familiar with Excel (hence, my need for assistance!). Please keep your explanations simple. I'm not too proud to admit I don't know very much about Excel.
Thanks!