Gil
10-08-2009, 10:37 PM
I have a requirement to be able to copy & paste to a new sheet data in 7 columns by 3 rows ignoring the blank rows in between if possible. The number of jobs is variable from 1 to 100 or more. I have attached a sample workbook, the data between the red lines is what I would like copied. I have tried filtering the blanks but never with a satisfactory result.The Original sheet would be left in tact but would allow me to further edit and add data to the new sheet with a macro or other means that I already use.
I think I might be confusing myself with what I want to do so any help or direction will be appreciated.
1984
I think I might be confusing myself with what I want to do so any help or direction will be appreciated.
1984