Hello Experts!
Basically:
I am a VBA novice and have hit a roadblock. I need to create a macro to search through a column for records within a range of values. Then I need to copy the relevant rows and populate them in a new worksheet.
Specifically:
I need the macro (executed by clicking the orange rectangle in DataEntry) to search in the worksheet named QuarantineData for records that have both:The corresponding rows of relevant data need to be copied and entered into a new worksheet. Ultimately, I would like to create a new worksheet each time this macro is run, named whatever today's date is. I know that there is a limit to the number of worksheets allowed but I can manage that later.
- dates between today and two weeks ago (in column I)
- null values (in column T)
Worst case: it's not possible to name a sheet after today's date, then I need to be able to delete all the old data and copy over the new records into the same worksheet each time the macro is run.
I'm hoping some, if not all, of this is possible. If you need any further explanation or clarification, I'll be glad to explain. Any assistance you can offer would be greatly appreciated. Thank you for your time!
Bookmarks