Edit to current macro help

Hi all,

This macro copies data from 4 sheets into one sheet. It searches and then copies up to the last row containing data in each sheet.

This part works well, my problem is that in certain columns up to row 30 there are formulas which means that even if there is no meaningful data in the row it copies it because of the formula. Is there a way of stopping the copy and paste from rows where this no data in A5:A30 of a particular sheet, to move on to the next sheet and check there and so on.

I will attempt to upload an example of the file once I stop receiving database errors from the forum.

However here is the macro:

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here