Excel 07. I have two excel spreadsheets. Sheet1 has a few cells on it that I would like to be populated with a few cells from sheet2. This I want sheet1 to replicate this about 400 times for all employees in the agency.
Here is the example.
Sheet 1
Person name number1 number 2 number 3 Cell cell cell cell
Sheet 2 Information sheet. Person name number1 Number2 number3 Jim 23 32 54 Sally 25 22 53
End result
Sheet 3 Person name number1 number2 number3 Jim 23 32 54
Sheet 4 Person name number1 number2 number3 sally 25 22 53
Any help will be appreciated thank you.
