Hi,
I am a VBA novice in search of solution that is probably very simple. I have a Column H which has a bunch of dates. I am trying to create a VBA that will delete all rows with dates in Column H that are great than 45 days from today. If this issue is better suited for a formula of some sort, please advise.
Bonus:
Is there a macro that will insert a blank row between data subset and fill it yellow? For example: I have 100 records (row A1:A100 in the eastern market. Immediately below that is the data for the western market, which is an additional 250 record (row A101:A351). I want to leave everything as it is and simply insert a blank row to divide eastern from western. then shade it yellow . If this is too much, please this regard as it is not as important. I just thought it'd make my report cleaner.
Bookmarks