View Single Post
  #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