Gather info from two workbooks to make a third workbook..
If anyone can help, it would be greatly appreciated.
I have two spread sheets. One of them holds employee information and
statistics. The format is listed below:
Workbook1.sheet1 (these cells run B9:L9, then B10:L10 etc..)
Firstname,Lastname 87817 22 16:12 112:16 14:44 104:12 0 0:00 587:53 0:00
I have another sheet, the format is listed below:
Workbook2.sheet1 (these cells run from A4:J4, then A5:J5 etc..)
Firstname Lastname Supname
I have to create a new sheet based off of information gathered from both
workbooks. I need everything from workbook one, with the addition of the
Supname from Workbook2. The final data for workbook3 will look like this:
Supname Firstname,Lastname 87817 22 16:12 112:16 14:44 104:12 0 0:00 587:53 0:00
Then I need to take that information in workbook3 and have a new tab create
for each supname, and listed on each tab the employees for that particular
supname.
|