Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

linking cells and copying

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking cells and copying cell relationship to new worksheet

Linking cells and copying cell relationship to new worksheet

ResolvedVersion 365

Linking cells and copying cell relationship to new worksheet

Hi there,
I know this was part of the training but it's something I'm struggling with. In one worksheet I need to link a list of items in one column to their values in another column, and then copy that relationship to a different worksheet where the list is in a totally different order. The end result being that the values for the items in the list are the same in worksheet 2 as in worksheet 1, even though the order is different.

Any help would be greatly appreciated.

RE: linking cells and copying cell relationship to new worksheet

Hi Dougal,

Thank you for the forum question.

You can use a Vlookup to lookup the values. The item will be the lookup value.

Please watch the video below.

https://www.youtube.com/watch?v=wsTXTufM_Lc& ;t=95s

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Excel tip:

Paste a web address into the hyperlink address field

If you copy a web address the only way to paste into the address field of the hyperlink box is to use CTRL + V. Right click paste does not work.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.