NewDaddy
11-07-2006, 07:43 AM
Hi All
Once again I am in need of your help.
I could probably put this together (eventually) but I don?t have the time hence my coming to you.
I need to create a summary/totals sheet showing the ?Grand Total? of budget changes for all worksheets in a workbook. The sheets where based on a pivot table and subsequently have been 'fanned out' and made inactive/pasted valued.
What I would like returned onto the summary/total sheet is, as an example, as follows;
Division Amount
Sheet1 (name) 0.00
Sheet2 (name) 0.00
Etc
Etc
"Grand Total" will be found in Column A
The total change (amounts column) is in Column E
Column A - Reason for Movement
Column B - Revenue Budget Code Used
Column C - Orginal Budget
Column D - Revised/New Budget
Column E - Difference between Original & Revised Budgets (ie change)
I think I have made enough sence, sorry for the rush but yet something else to deal with.
Cheers
Jay
Once again I am in need of your help.
I could probably put this together (eventually) but I don?t have the time hence my coming to you.
I need to create a summary/totals sheet showing the ?Grand Total? of budget changes for all worksheets in a workbook. The sheets where based on a pivot table and subsequently have been 'fanned out' and made inactive/pasted valued.
What I would like returned onto the summary/total sheet is, as an example, as follows;
Division Amount
Sheet1 (name) 0.00
Sheet2 (name) 0.00
Etc
Etc
"Grand Total" will be found in Column A
The total change (amounts column) is in Column E
Column A - Reason for Movement
Column B - Revenue Budget Code Used
Column C - Orginal Budget
Column D - Revised/New Budget
Column E - Difference between Original & Revised Budgets (ie change)
I think I have made enough sence, sorry for the rush but yet something else to deal with.
Cheers
Jay