Hello
looking for some support and not even sure if it is possible
Am looking for a way to use macro to ask the user to enter 2 dates and it will print the sheets between these dates sounds simple but am guessing not as easy to do
background
Am using A single workbook with each sheet named as a date one for each week of the year lalways stars on a Sunday and in format of dd-mmm-yy (5-Sep-21)
User must be able to continue to add sheets as weeks move though the year
ideally want to print 2 sheets to one page however I think I could work this out with some research
Any help or ideas how how to achieve the above would me amazing spend most of the day looking for help
thanks
Chris
looking for some support and not even sure if it is possible
Am looking for a way to use macro to ask the user to enter 2 dates and it will print the sheets between these dates sounds simple but am guessing not as easy to do
background
Am using A single workbook with each sheet named as a date one for each week of the year lalways stars on a Sunday and in format of dd-mmm-yy (5-Sep-21)
User must be able to continue to add sheets as weeks move though the year
ideally want to print 2 sheets to one page however I think I could work this out with some research
Any help or ideas how how to achieve the above would me amazing spend most of the day looking for help
thanks
Chris