Copying filtered data when there are no cells to show

[canadian_chickie]

Hi Everyone,

I am creating a report in Excel by combining two reports downloaded from our system. The one (secondary) report is additional information that is being filtered and copied over to the "main" spreadsheet. This secondary report is filtered to show only accounts that are "Overbilled", "Documents Required" or "Overbilled/Documents Required". This part of my macro is all working fine. My problem arises when this filter results in a "blank" (no results to show) spreadsheet. Depending on which branch I'm working on, there are times when there are no issues, so there are no lines of data for the macro to copy. When there is no data left in the table, the macro is copying the headers and pasting them into the workbook, which I don't want. Is there any way to change the macro so it doesn't do this? Can you tell the macro to copy data when there is data but skip steps when there isn't or something like that? I've attached that part of my macro for reference:

Please Login or Register  to view this content.

Thanks!
canadian_chickie

[Pete_UK]

Try it like this:

Please Login or Register  to view this content.

Hope this helps.

Pete

EDIT: I've coloured the two added lines red, for clarity

[canadian_chickie]

Works like a charm! Thank you so much!