multiple work sheet data to link in one worksheet

  • Thread starter Thread starter MANISH
  • Start date Start date
M

MANISH

Kindly help me out with this problem. i have a data of multiple clients.
e.g. complete data of a single client will found in single work sheet. the
name of the work sheet is equal to name of the clients. i have around 50
worksheets like this. i just need to combine the sales and operating profits
of all the clients in below given format for each of the month. kindly
suggest how to do it.

sept 09 oct 09 nov 09
client name sales GOP SALES GOP SALES GOP


MIS EXECUTIVE
RKHS
 
Hi Manish, I hope the following will help you.

1. I am working in EXCEL 2007.

2. I have set up one Workbook with 6 Worksheets in it. From left to right
these Worksheets are called:-

Summary_Sheet
Sheet2
Sheet3
Sheet4
Sheet5
Sheet6

3. In cell B 14 of Sheets 2 to 6 inclusive I have entered the number 100.
This represents your, "sales" total.

4. In the Summary_Sheet (the one furthest to the left) at cell at cell B 14
I have entered:-

=SUM(Sheet2:Sheet6!B14)

This returns a total of 500.

Is this what you want?

If it is please hit Yes.

Thanks.
 
--
MIS EXECUTIVE
RKHS


trip_to_tokyo said:
Hi Manish, I hope the following will help you.

1. I am working in EXCEL 2007.

2. I have set up one Workbook with 6 Worksheets in it. From left to right
these Worksheets are called:-

Summary_Sheet
Sheet2
Sheet3
Sheet4
Sheet5
Sheet6

3. In cell B 14 of Sheets 2 to 6 inclusive I have entered the number 100.
This represents your, "sales" total.

4. In the Summary_Sheet (the one furthest to the left) at cell at cell B 14
I have entered:-

=SUM(Sheet2:Sheet6!B14)

This returns a total of 500.

Is this what you want?

If it is please hit Yes.

Thanks.
Click to expand...

thanx for reply but this is not the case. i don't want summary of sales and
operating profits. i need customer wise sales and operating profit for all
clients seperately. kindly suggest.

rgds,
manish
 
Back
Top