Need macro copy info and save as new file [Closed]

Report
Posts
1
Registration date
Thursday August 2, 2018
Status
Member
Last seen
August 2, 2018
-
Hello everybody!
I have 2 workbooks: Timesheet (T), FTE report (F)
All would be starting on second row, as I have a header row on the F spreadsheet:
I am trying to copy column "B" (name) from F to the cell "B1" on T. Column "W" on F to cell "B2" on T.
Column "D" (F) in cell "B3" (T), column "T & S" Concat with a "-" in the middle from F to the cell "B4" on T. Column "X" from F to cell "B5" on T and Column "Y" from F to "B6" on T.
This should be fairly easy but now to the harder part:
Some of the values in column "B" on F will be repeats, which will have different values in column "G" and column "I".
I want excel to use the value of column "G" from F to be entered into "B10" on T, and if it's less than 100 to continue to copy the next row until the value in B (name) changes.
(If the value in G is less than 100, which stands for %, then there will be more rows with the same value on it to get to 100. While this is not complicated enough I also would like for excel to take the corresponding value (same row) to be copied from "I" on F to T to "A10" until B on F changes names. Once this is all complete and the name changes I want excel to save the workbook as a new file as the name that is in cell "B1."
After that I want the whole process to repeat, until the first cell in column B on F which is empty.
Anybody who has any ideas I would greatly appreciate it!!!

Example of FTE report: (na = not applicable)

A/ B/ C/ D/ E/ F/ G/ H/ I/ J-R/ S/ T/ U/ V/ W/ X /Y
na/name1/na/X/na/na/50/na/123/na/A/1234/na/na/##1/differentname1/timekeeper1
na/name1/na/X/na/na/30/na/324/na/A/1234/na/na/##1/differentname1/timekeeper1
na/name1/na/X/na/na/10/na/987/na/A/1234/na/na/##1/differentname1/timekeeper1
na/name2/na/Y/na/na/50/na/123/na/B/9874/na/na/##2/differentname2/timekeeper3
na/name2/na/Y/na/na/50/na/987/na/B/9874/na/na/##2/differentname2/timekeeper3
na/name3/na/X/na/na/100/na/456/na/C/4564/na/na/##3/differentname1/timekeeper2
na/name4/na/Z/na/na/100/na/654/na/D/6654/na/na/##4/differentname3/timekeeper1

Example of Timesheet
Column A / Column B
1 Employee name / info from F column "B"
2 Employee ID / info from F column "W"
3 Hours per week / info from F column "D"
4 Organization # & name (this is the concat row with a dash in the middle)/info from F column T-S
5 Supervisor / info from F column "X"
6 Timekeeper / info from F column "Y"
several rows down:
10 info from F column "I" / info from F column "G"

continue behavior for row 11 - 17, if the name in column B on F is the same
when name changes save as a new workbook with file name as the same as in "B1" on T.
Repeat until column "B" on F runs out of names.

Last note: it will have to be a long macro, as there are approx 10K lines in the FTE report.

I hope I am explaining this well enough, please ask if you have any questions.

Thank you!

R.