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!

You really need to tell us a litte more detail.

"Laird" wrote:

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..
--
Thanks for your help


"Mike" wrote:

You really need to tell us a litte more detail.

"Laird" wrote:

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!