Excel Profit & Loss

  • Thread starter Thread starter Laird
  • Start date Start date
L

Laird

I have about 30 profit and losses for different departments of a
company. Each P&L shows data for many years. I would like to have
one summary spreadsheet which has only the sales and EBITDA
information for each P&L worksheet but I don't want to have to link
each cell individually since, for example, each Sales amount for 2002
is in cell C23 of each worksheet. Is there a way to do this more
efficiently?

Thank you!
 
Link the first P&L to you summary sheet have cells anchored using "$"
The copy that line of code to where you want the 2nd P&L to show- then used
Find / replace to change the sheet name to the 2nd p&l and so on..
 
Back
Top