Hi,
So I have 3 columns of data (Column A, B, C). Column C has some blank cells in it. I would like to be able to find all the blank cells in Column C, then copy the rows (Column A, B, C) which contain the blank cells, paste them into another sheet within the same workbook, then delete them from the original sheet.
using the macro recorder I was able to do this:
Sub Macro4()
'
' Macro4 Macro
'
'
Columns("C:C").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete
End Sub
Obviously, this finds the cells which are blank & allows me to delete those rows containing the blank cells in the SAME worksheet. I still have not figured out the way to copy them to another sheet before deleting them.
Is the current macro a good starting point to expand on, or should I try a totally different approach?
Thanks in advance,
Rob
Bookmarks