Hello all, long time lurker first time poster... This website and others have been really helpful to me in the past and I'm looking for a little more help now.
I am looking for vba code that will allow me to copy cells in columns A and B that correspond to empty cells in columns C, D, and E.
Columns A and B are many many rows of continuous data that is contstantly being added to. Columns C, D, and E are also being added to, but there are always blanks relative to columns A and B. Let me 'splain:
<TBODY>
</TBODY>
So what I want to do is copy the rows in Columns A and B that are blank in Columns C, D and E. Or you could even limit it to just Column C being blank, because D and E will also be blank in those situations.
This is one part of my evil plan to... ahem, I mean part of a far larger macro that will aid me in... stuff. Thanks for any help! Oh and I am working in Excel 2010 with a Windows 7 PC.
I am looking for vba code that will allow me to copy cells in columns A and B that correspond to empty cells in columns C, D, and E.
Columns A and B are many many rows of continuous data that is contstantly being added to. Columns C, D, and E are also being added to, but there are always blanks relative to columns A and B. Let me 'splain:
A | B | C | D | E |
data1 | data2 | data3 | data4 | data5 |
data1 | data2 | data3 | data4 | data5 |
data1 | data2 | data3 | data4 | data5 |
data1 | data2 | |||
data1 | data2 | |||
data1 | data2 | |||
data1 | data2 | data3 | data4 | data5 |
data1 | data2 | data3 | data4 | data5 |
data1 | data2 | data3 | data4 | data5 |
<TBODY>
</TBODY>
So what I want to do is copy the rows in Columns A and B that are blank in Columns C, D and E. Or you could even limit it to just Column C being blank, because D and E will also be blank in those situations.
This is one part of my evil plan to... ahem, I mean part of a far larger macro that will aid me in... stuff. Thanks for any help! Oh and I am working in Excel 2010 with a Windows 7 PC.