Copy data from one worksheet to new one based on unique ID

**Voryn** · 07-23-2009, 11:48 AM

I need to know if its possible and how to do this.

I enter whats called a d# in a work sheet. I then want excel to search for any D# that matches and copy the adjacent column (name) to the d# i just entered if it matches. so:

worksheet 1 has multiple d#'s and names (column a and b)
on worksheet #3 i enter the d# . is there anyway to copy the name from worksheet 1 to worksheet 3 without me searching manually?

**jrussell** · 07-23-2009, 12:11 PM

If the d# is unique on worksheet 1, you can do a vlookup.

**Voryn** · 07-23-2009, 12:24 PM

is it possible to just check every sheet?
maybe if its in there duplicate times.. just thought of that.

and can someone give me a jumping off point of a macro or how to .. i haven't used excel like this in many years.

**StephenR** · 07-23-2009, 12:33 PM

Please attach a workbook with a small sample of your data and desired results.

**Voryn** · 07-28-2009, 12:27 PM

here's an example

also a correction

its unique to that name
i want to copy from worksheet 1 to worksheet 2 both columns b and c IF colum a in ws 1 matches column a in new worksheet