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

MIS EXECUTIVE
RKHS


"trip_to_tokyo" wrote:

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



"MANISH" wrote:


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