I have a worksheet that lists data in a table to be added to a "Jobs Log". The table consists of 13 rows all populated from formulas.
The code as shown will copy the data but if some rows are blank and only contain empty formula values, they also get copied. When I add more data it looks for the next available row and that may be many rows below the last visible set of data.
I am looking for a way to copy only the data that is visible and not include blank formulas. I also need to add 6 lines of code to copy formulas from the preceding rows. Those Columns are "K","M","AH","AI","AM", and "AX" (11-13-34-35-49 & 50 respectively). I am not sure how to add the necessary code for these changes.
ThanksPlease Login or Register to view this content.
Jim O
Bookmarks