i have an advanced filter, but so far there's no relevant data so after the advanced filter, only the header row shows up and the total row (ie the row after all the data) is blank. (currently the total row as of today is 24,000 but it can change daily depending on the day's data....again, the advanced filter doesn't show anything because the data as of today isn't relevant according to the advanced filter criteria)
however, ONLY WHEN THERE IS relevant data, I would need to CLEAR sheet1 and then paste the data onto sheet1.
i don't want to clear sheet if there's no relevant data because i have some dummy data on sheet1 to show the analyst how to analyze and monitor the spreadsheet.
so, essentially...i want the code to do something like this:
-open the source workbook with data
-advanced filter
-if there's no relevant data and only the header shows, skip the rest of the macro and say "no positions"
-if there IS relevant data after the filter, clear sheet1 and then copy and paste the data onto sheet1
however, ONLY WHEN THERE IS relevant data, I would need to CLEAR sheet1 and then paste the data onto sheet1.
i don't want to clear sheet if there's no relevant data because i have some dummy data on sheet1 to show the analyst how to analyze and monitor the spreadsheet.
so, essentially...i want the code to do something like this:
-open the source workbook with data
-advanced filter
-if there's no relevant data and only the header shows, skip the rest of the macro and say "no positions"
-if there IS relevant data after the filter, clear sheet1 and then copy and paste the data onto sheet1
Last edited:
