I am trying to build a forecasting workbook where each tab will be for one month. I plan on having a table on each tab to represent the progress of the job with %of work complete and % of work remaining among other information. Because I will be using this workbook in multiple jobs (all with different task names) I would like to only enter the task names into the first table on sheet one and have those names auto populate into each of the other tables.
I can accomplish this with a simple =(cell) in the other tables. The problem is I cant figure out how to get the other tables to automatically add a row. Any ideas? I am not very good with VBA but I have a feeling that is what I am going to have to do.
Hi Shawn,
I don't recommend separating your data into a tab for each month. Excel functions and PivotTables are designed to work with data in one table in a tabular format, not spread over several and as a result you will run into hassles down the track when you want to summarise or analyse the data spread over individual sheets.
You're far better off creating one table and using that for the forecast. If you want to analyse it on a monthly basis, then you can easily summarise the data using the built in tools available in Excel.
I recommend you read these posts on data layout:
I hope that points in the right direction.
Mynda
