I will start by stating i am a novice to VBA so apologies if some of my questions are stupid.
I have created a spreadsheet that will eventually have 52 sheets. one for each week of year. Within each sheet there are 7 tables to populate with daily orders. Each days orders are broken down by broken and location to be sent. (See attached spreadsheet)
I have created an input form on Week 5 which has a dropdown option at top for the week no. and the day of that week. What I would like to know is
1) whether it is possible to code the input form so that once i choose the week and the day it knows that the inputs are to go in Week 5 sheet (if i chose week no. 5) and the rows to populate are those within the specified day chosen i.e. Wednesday. If this is possible can you please suggest coding as i think this is way above my pay grade.
2) What i would also like is the data to be recalled to the input form if i reselect the week and day in the future. For example if i am inputting week 6 monday but accidentally select Week 5 monday the already entered data would appear on the input form so i would be alerted that i have probably selected the wrong date and wouldnt overwrite it - obviously i may be editing an order which again would be useful to have existing order be recalled.
3) I also keep getting a memory ful warning come up and im not sure if it is to do with the code i have already written. I doubt it but any tips on that would also be appreciated.
If I have not explained anything clearly enough please just ask and i will elaborate.
Many thanks
Bookmarks