Find names and copy to sheet2

**Vetequk** · 02-02-2010, 01:09 AM

I am trying to write some code that will look up a value in a range of cells and copy the names in column A to another sheet.

I have attached a sample sheet which I hope explains what i am trying to achieve more clearly.

thanks

Vetequk

**protonLeah** · 02-02-2010, 02:17 AM

...which I hope explains what i am trying to achieve more clearly. ...

Unfortunately, not so. You should have provided before and after examples showing which value was looked up and which name was returned.

As it is, though, the data range has many repeating values. For instance the value "11" is associated with
name5, name6 & name9, etc.

**IgorSharov** · 02-02-2010, 02:34 AM

Look at this

**contaminated** · 02-02-2010, 02:41 AM

----------------------------------

**Vetequk** · 02-02-2010, 03:56 AM

OK
if the number 11 was typed into the message box, the code would look for the number 11 within the range and when it find it goto column A where the name is located copy the name to cell A2 on sheet 2 then go onto the next 11 and copy that name to A3 and so on until the end.

I have attached a with the desired results on sheet 2 if 11 was typed in.

thanks

vetequk

**Vetequk** · 02-02-2010, 04:26 AM

Igor Shadow

I had a look at the file and that's just what I was looking for.

Thanks Vetequk

**IgorSharov** · 02-02-2010, 06:52 AM

I was glad to help

Find names and copy to sheet2

LinkBack

Thread Tools

Rate This Thread

Display

Find names and copy to sheet2

Re: Find names and copy to sheet2

Re: Find names and copy to sheet2

Re: Find names and copy to sheet2

Re: Find names and copy to sheet2

Re: Find names and copy to sheet2

Re: Find names and copy to sheet2

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions