Help needed...

[JRS]

I'm trying to get a macro to operate on a select amount of data, to do this I need to find a way of getting excel to select every row, where the first letter of the code in column C starts with the letter N.

Anyone know how I can do this?
Is it possible?

 

[GlennUK]

What are you trying to do with your macro on this subset of data in column C? By the way, a subject of "Help needed..." is not to posting guidelines, quote

Tip #2:
Include a meaningful title that is specific to your question.
Good: "Excel VBA Type Mismatch Error"
Not so good: "Help needed!"

as is listed here:
http://www.mrexcel.com/forum/showthread.php?t=515787

 

[xlstheronstyle]

Hi JRS,

Well you can do this without macro or maybe record these steps one time to create a macro from this...


In the column next to code put formula "=left(C1,1)" without quotes, so in case it would be cell D1, assuming first code is in cell C1

Now copy this for this entire column.

Now filter this with "N"

After Filter Press ALT+; to select visible cells Press CTRL C and Paste it to new Place CTRL V and you get your work done.

I hope this will solve your query

Regards
xlstheronstyle

 

[JRS]

GlennUK

Apologies for the subject heading.... I'm a newbie around here.

I want to select the all the rows that have a first letter of N in column C, so I can then cut those rows out of the worksheet and paste them in a new worksheet.

Ideally it would remove those rows from the original worksheet to leave an unbroken list of all the data which does not have a first letter of N in column C.

Do you know how I can do this?
Thanks
JRS

 

[GlennUK]

I'd do a Data Filter, Advanced Filter to a different location. Maybe do it twice to different locations, once with a criteria of N* and again with criteria of <>N*. Then you end up with 2 lists, one starting with N and the remainder.