multiple work sheet data to link in one worksheet

[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

 

[trip_to_tokyo]

For, "sales" and "operating profits" are they in the same cell in each
Worksheet?

 

[MANISH]

--
YES ALL THE RELATED DATA IS IN SAME CELL FOR ALL THE WORK SHEETS

MIS EXECUTIVE
RKHS

 

[MANISH]

--
MIS EXECUTIVE
RKHS

For, "sales" and "operating profits" are they in the same cell in each
Worksheet?

YES

 

[trip_to_tokyo]

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.

 

[MANISH]

--
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.

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

 

[Ashish Mathur]

Hi,

If you wish, you may send the file to me at ask(at)ashishmathur(dot)com.
Please send a small sample file only

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com