MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying Row to new range


Posted by lenze on February 11, 2002 9:16 AM

I need a way to check through a range of 5 rows, checking the value in column A to be >0. If so, copy that row to the first blank row in another range on another sheet. Repeating for each row

Thanks


Posted by daniel cremin on February 11, 2002 9:21 AM

why not try a for...next statement set it to search for >0 and get it to copy it and then paste it on the next sheet.Not entirely sure how you could customise it for each row, but perhaps you could have a range of 5 rows and say look for the first row with an empty cell in the a column and paste it.