automatically updating data in separate worksheet

[vron1234]

Hi all,

Probably a very simple problem to solve…

There are two sheets in my workbook. Each sheet has two columns: ‘professional name’ and ‘edgemont name’, they are both referring to the same job. The ‘Edgemont name’ column is sorted differently for each sheet. Both names are unique.

When I enter the ‘edgemont name’ on the first worksheet, I would like it to automatically update on the second. The problem is that the ordering is different, so is there a way to update the ‘edgemont name’ while referencing the ‘professional name’ column?

Make sense?

THANKS so much, about to go crazy trying to figure it out!!!

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.