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. |
All times are GMT +1. The time now is 04:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com