Hi Ladies and Gentlemen, I humbly request assistance from an Excel 2003 expert.
I do enjoy a programming challenge and would love to be able to answer this one on my own but sadly, I cannot.
have a workbook called 'May'.
It contains 31 worksheets entitled '1st', '2nd', '3rd etc - up to '29th', '30th' and '31st' and these correspond with the
dates in that month.
The same row of each worksheet contains the names of employees. (About 18).
The user will manually complete the names in the appropriate row and columns of the '1st' worksheet.
I'm trying to
find a macro/function/formula to copy that row of employees names to all the subsequent days (sheets), and ideally this would
be activated by a user with a macro assigned button. (I can take care of the easy part - designing the button and assigning
The macro will initially be used on the 1st of the month to copy the names all the way through to the
31st. This is ideal if there is to be no change in the employees, but a user will need the facility to amend the list on any
day throughout the month up right through to the end of the month.
(e.g. on the 14th of the month a member of staff leaves and needs to be removed from the list from the day after they left
until the 31st. So.. The user amends the row of names to reflect the now absent staff member and uses the macro to
re-populate the subsequent worksheets.
Then, on the 16th they are replaced and the new member of staff has to be added from 16th all the way through to the
My aim is to make the process as easy as possible for the user and to avoid as much repetition as possible.
macro will need firstly to establish the remaining number of sheets from the date the amendment is made and then populate the
appropriate rows of those sheets with the selected employees names.
I really hope I've made sense in my
explanation and I'm very grateful to you for reading and considering.
So many thanks to you, Gordon.