merging data
| Name | Total Logged on Time | Average Contact Handled Time | Unavail Time % of Login time | Calls Handled | Logged by Phone | Calls Handled / Logged |
| AAA | 06:51 | 00:04:52 | 4.0 | 36.0 | 24.0 | 66.67% |
The above information has been imported from two different data sources and appears in 31 worksheets on the same rows & columns within 1 workbook.
What I would like to do is click on the persons name (.e.g. AAA), and end up with a new worksheet pulling all the information for AAA on each worksheet, and then compile it onto separate rows in the new worksheet.
So hopefully look like the following:
| Stats for AAA | Total Logged on Time | Average Contact Handled Time | Unavail Time % of Login time | Calls Handled | Logged by Phone | Calls Handled / Logged |
| 01 (taken from sheet 01) | 06:51 | 00:04:52 | 4.0 | 36.0 | 24.0 | 66.67% |
| 02 (taken from sheet 02) | 06:54 | 00:04:59 | 2.0 | 39.0 | 33.0 | 84.62% |
| 03 (taken from sheet 03) | 06:52 | 00:04:59 | 14.0 | 23.0 | 21.0 | 91.30% |
| 04 (taken from sheet 04) | 06:55 | 00:02:42 | 6.0 | 43.0 | 27.0 | 62.79% |
If I clearly understand
Try this one
excelexperts.com/node/775
Merging Data
Thank you Cyril,
That's exactly what I wanted...
I've managed to work out most of it, but a bit confused as to how/where the calculation looks up the separate worksheets?
Rich
Column A
As you can see sheet names and values in column A are equal.
So if you add a sheet and call it "new" you need to type "new" in column A to get data from that sheet.
One more note
You need to keep same order in range "names" and in column "Name" in each sheet to get data for right person.
Thank you very much indeed
Thank you very much indeed everyone .... I now understand, and have experimented more and works fabulously (if that's a word).
Rich
You are welcome
I'm glad that it was useful.
Good luck!
Thanks
Thanks