ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Gather info from two workbooks to make a third workbook.. (https://www.excelbanter.com/excel-programming/391806-gather-info-two-workbooks-make-third-workbook.html)

Mahnian

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