Greetings all,
I have a question similar to the other thread with this title (here), but my sheet is a bit more convoluted.
The below workbook is what I'm working with. I need the information entered in Sheet1 to populate in the tabs for each store (numbered at the bottom). Ideally, I'd like the Check Number, Payment Date, and Amount Posted for each store to fill in the respective sheets, tied to the Week Ending (W/E) date, and then print two copies of Sheet2 when the "Print" button is clicked. So far, all I have working is printing the two Sheet2's (macro Print2 in the sheet).
2013 PAYMENT TRACKING.xls
The data I'll enter is the amounts on the master sheet and then the number sold on each individual store.
I'm stumped as how to make this any less intricate and I’m hoping I can find some help here. Also, I need to do this for several workbooks that won't necessarily have all of the products listed (i.e. Chain 1 has five separate stores tracked on one workbook, Chain 2 has 10 stores, etc.), so if I could be told how to add/remove bits of the code/macro to incorporate different products I'd really, really appreciate it!
Thanks for your time!!
Bookmarks