Copy only cells that contain values from a range cells that contain formulas to next row

Ok,

I have a sheet - Banking info
Column A is a list complied of if statement with a true index/match formula and a false "".
I want to copy the cells with values that are not "" to a column on another sheet - Export Table

However, with the code I am using below, it copies the 7500 cells each time, so the next time the I need to copy the new entries the macro is listing those at row 7504 and then the next time its at row 15000 ect. Even if there are 1000's of cells in sheet Export table column AV that are empty

Im not sure if that is making sense, so lets say the list in the column A range contains 10 entries and the rest of the range is empty, I just want it to copy those 10 values, not the whole 7500.

Please Login or Register  to view this content.

Incidentally, I have tried taking out the paste formats line, and it still copies all 7500 cells and the next time I run the code Excel sees the first available row at 7504 even though there are many empty above it.

Any guidance would be very much appreciated.

Grant

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I have added them for you - this time

My VBA is weak, but it seems to me that you need to change this part?

Please Login or Register  to view this content.

On a side note, there may be a formula-way to do this instead?


If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.