Excel 2007 - Updating Cells in one worksheet from another worksheet

Hello Everyone,

I need to update a cell in a excel workbook …..The workbook is made up of two worksheets…Worksheet 1 and worksheet 2. Worksheet 1 is the master worksheet that has all the columns and rows I use. Worksheet 2 has two cells – ID and Code. I want to update the codes on worksheet 1 with the codes from worksheet 2 using the id from both sheets has a one to one relationship. Is there a way to create an update query in excel? Can I use vba?
Thanks,

Bill

Microsoft Excel

Last Comment

bjennings

8/22/2022 - Mon

SeaSenor

7/5/2012

you can link the cells so they update automatically.

copy the cells you want in sheet 2 and paste special, paste link into the cells you want of sheet one.

bjennings

7/5/2012

ASKER

The updated cell is based on what the id number is from both worksheets...for example

Worksheeet 1 Worksheet 2

id Code id code
2233 T1P 2233 P01
9912 U14 8823 N12
8823 T1P 9912 T1P
9901 N12 9901 N12

I want to run a query and have worksheet 1 look like this

worksheet 1

2233 P01
9912 T1P
8823 N12
9901 N12

If I do the copy link I have to do it one at a time, so I am looking for a way to link up the two worksheets by using the ID numbers as a link.

THanks,

Bill

SeaSenor

7/5/2012

so the id numbers are not in the same order on each sheet?

if they were arranged in the same order, would they be able to stay arranged?

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

William Peck

ASKER CERTIFIED SOLUTION

Steve

7/6/2012

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options