I have an annual roster that I am working on, it has a master sheet that allows users to add extra people at the click of a macro button (and also adds them to the corresponding named range)
What I would like is for that macro to also add them to each month (Jan, Feb, Mar etc) which are all on separate sheets.
My work so far is attatched
Bookmarks