Excel cell from one sheet to another sheet
- by Eric
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.