Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfer data from multiple worksheets | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
create one pivot from mulitple data sources | Excel Discussion (Misc queries) | |||
merging different worksheets in a workbook to one sheet | Excel Worksheet Functions | |||
data entry on multiple worksheets | Excel Discussion (Misc queries) |