LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 25
Default multiple work sheet data to link in one worksheet


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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link one worksheet in a workbook to another worksheet in same work bjswise Excel Discussion (Misc queries) 1 February 6th 10 12:09 AM
need a function that will work using multiple work books and sheet capt c Excel Worksheet Functions 1 March 30th 09 10:20 PM
link to another worksheet in the same work jae Excel Discussion (Misc queries) 5 December 28th 08 09:03 PM
how to link data from one source sheet to multiple sheets Ashish Deshmukh Excel Worksheet Functions 2 June 15th 07 04:08 PM
How to link a url to the work sheet Igneshwara reddy[_2_] Setting up and Configuration of Excel 0 March 12th 07 05:40 PM


All times are GMT +1. The time now is 06:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"