Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multi spreasdheets
I have created a spreadsheet which shows the profit and loss of the company.I
have then created division revenue spreadsheets ,so for every division or profit centre there is a sheet that has a table of revenue showing month by month actuals against budget.So the sheet will have the type of revenue along vertical and income by month along horizontal. Then i create a line graph for each sheet.The problem i have is that each month i have go into each spreadsheet individually to copy and paste the formualas into the following month and then go into each chart to extend the line graph by the month results ie actual results. Is there a quick way of do this without going into each sheet individually and then extend the data range to the next month.i have not explained this well but if i have a budget , every month i put actual monthly results against budget in the summary profit and loss and then do the same in each revenue spreadsheet and then chage the data source for the charts. i konw i can use group spreadsheet but it means that the lay out of each sheet needs to be the same for the group changes to work and some sheets are bigger than others so it does not always work |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
Complex Multi-condition, multi-workbook count | Excel Discussion (Misc queries) | |||
match in multi-column and multi-row array | Excel Discussion (Misc queries) | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) |