Is there a way to copy lists (range I guess) to specific cells in multiple worksheets all within the same workbook. I have data in 4 columns that needs to be copied into it's specific sheet.
A2:A110 - to cell B1
B2:B110 - to cell A3
C2:C110 - to cell B3
D2:D110 - to cell C3
E2:E110 - to cell D3
each sheet coincides with name in Column B
test workbook attached, "Template", "Staff Listing" to create named sheets
"Ahlgren, Joseph" has completed cells from "Staff Listing", showing data to copy/paste to other sheets
Any help appreciated.
Bookmarks