I am working on updating an Excel spreadsheet for my supervisor and I want to find a way to get a named range from another sheet depending on the day of the week (each named range has the name of a weekday) but I haven't found a way to do this.

So I need the staff list to be duplicated under the weekday heading based on the heading. Any help appreciated, I don't have a huge deal of experience with Excel or VBA.

CodePudding user response：

I'm not quite sure if I understood what you are looking for! If your Excel version has Dynamic Array Formulas then you can try this: