Moving a row if a specific cell contains a number

**LionTamer** · 05-30-2011, 12:33 AM

Hi All,

First time poster so apologies if I'm not in the right area. My question is:

I have set up a workbook where I can import data into Sheet2 and I have created a macro to sort and tidy the data up to a certain degree. (took me ages to get that far). Now I want to extract an entire row from Sheet2 and place it in Sheet3 based on the condition that a number appears in Column A. Can this be done with a 'If cell.Value =' statement if the value I need is a number and not text?

So basically, I want every row which has a number in Column A moved to Sheet3. Any suggestions would be greatly appreciated.

Thanks in advance.

**mabs239** · 05-30-2011, 01:28 AM

You could also use 'lookup' or 'match'/'index' formulas too.
Of course if condition can be used in macros but I am not sure about the exact syntax at the moment. Use excel help.

**mohd9876** · 05-30-2011, 02:47 AM

you can use this function

Please Login or Register  to view this content.

**LionTamer** · 05-30-2011, 04:03 AM

Okay, I'm fumbling my way through this...

I have tried the following code to check if Column A contains a number, and if so, move the data from the first three columns to the next worksheet:

Please Login or Register  to view this content.

It seems to work perfectly on some rows, but not others. Does it have something to do with not returning to the next cell correctly? (the data in the Sheet often extends beyond column C, however it's only the first three columns I need to extract, so I don't need to delete cells or to shift up)

I've cobbled this code together from a few threads, and obviously have buggered it up...

Thanks in advance.