LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jjjam
 
Posts: n/a
Default Merging data from mulitple worksheets

Imagine one Excel spreadsheet with 20 worksheets within; each worksheet
assigned to a team member; and each worksheet containing the monthly
accomplishments of that team member.

What I need to do is merge the text of each worksheet into a "summary"
worksheet, showing Joe's accomplishments, then Judy's, etc. etc.

I'm looking for any ideas how best to do this. Any help is GREATLY
appreciated.

Each worksheet is identical in format.
Row A B C
1 Date Accomplishment Hrs Worked
2
3
4 Date Meetings Attended Hrs Spent
5
6
7 Date Training Hrs
8
9


 
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
Transfer data from multiple worksheets jimbob Excel Discussion (Misc queries) 4 January 29th 06 02:38 AM
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 07:05 PM
create one pivot from mulitple data sources news.hp.com Excel Discussion (Misc queries) 2 March 29th 05 07:28 PM
merging different worksheets in a workbook to one sheet a.pontes Excel Worksheet Functions 1 March 1st 05 06:02 AM
data entry on multiple worksheets diosdias Excel Discussion (Misc queries) 1 December 7th 04 05:33 PM


All times are GMT +1. The time now is 07:46 PM.

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

About Us

"It's about Microsoft Excel"