Hi all,
Help on this task would be so much appreciated.
I am creating a staff planner. I need to copy a range of cells from one worksheet, to another, based on a user input.
Scenario - on "front" worksheet, manager will identify how many staff will be available and input number into C3. This will then copy corresponding range of cells from "template" worksheet and paste into the "Monday" worksheet, from B4
Depending on the heading of the column in "template" (along row 2), will have to match the staff available value on the "front" page.
For simplicity i'm keeping with 3 staff just now, but this could be as much as 30 if this can be worked out.
I've attached a copy of scenario to show what I want to work with.
Thanks for taking the time to read this![]()
Bookmarks