Good afternoon, I hope the title reflects my query well enough.
I have found similar questions, most of which search through a range and when they find a match copy that row to a sheet with the same name.
My query seems simpler but I cannot seem to find code that I understand well enough to adjust to my needs.
attached is an example workbook, a snippet of my actual workbook.
on the "Summary page", I would like C5 through to F5 copied to the next row, of the sheet which is named at J2.
J2 on the main workbook is a VLOOKUP which populates it with a staff members name, in the example I have just written one in text. The name at J2 will always match the name of a sheet in the workbook.
You can probably see on the sheet "Bland Catherine" where I would like the range copied, but it will be copied to the next available row from C5 onwards. I do not wish for data to be overwritten, so to copy to the next available row.
Thank you in advance
Copy to Sheet test.xlsx
Bookmarks