Forum Discussion
Macros for hiding rows based on date
It seems it should be simple but I have spent a few days on this so am reaching out. I am just learning Macros and am blown away by what it does, but this one situation is driving me crazy. I have ...
If you don't mind me asking, why have the second worksheet that just links to the first worksheet? It creates a very large file that is slow to open (50MB file versus 17KB). Also, if someone inserts a row on your data worksheet, it will be missing from your summary (the newly inserted row will not be linked to your summary worksheet unless you recopy your formulas).
Why not just filter the table on the data entry tab (column k). If you click the drop arrow and select "date filters," there are a lot of standard options (year, month, week) and custom options (before, after, between - with a date picker calendar) available.
I'm having a hard time seeing how the macro is going to save much time over just using the filter - especially as the file grows.
Why not just filter the table on the data entry tab (column k). If you click the drop arrow and select "date filters," there are a lot of standard options (year, month, week) and custom options (before, after, between - with a date picker calendar) available.
I'm having a hard time seeing how the macro is going to save much time over just using the filter - especially as the file grows.