Generating coversheets using inputboxes
Hi All
I'm trying to write a VBA macro that will generate coversheets for each day of trading reciepts for my stores, for the month selected.
I want each coversheet to display the store number, name, and then the date. Ideally, I want the user to just select a month and year, and the macro will go ahead and generate 28-31 pages with each days date.
So far, I have two seperate inputboxes for the store number, and store name, and these are stored as varables.
I'm having trouble getting to the next step, which is having the user specify a month and year, and having all the collected data inputted onto the document.
It's been a few years since using VBA, and I'm having trouble moving forward. Any help would be greatly appreciated. Please see attached for what I'm aiming for.
|