Linking Data Validation

J

Jamie

I want to link cells that contain data validation. For example, I have two
worksheets (say worksheet #1 and worksheet #2) and in worksheet #1 I have a
column labeled "payment terms". The cells in that column each contain the
same data validation of say 4 payment terms to choose from. In worksheet #2 I
have a duplicate "payment terms" column and want to link the cells to the
corresponding cells in worksheet #1. When I try to simple "=" the cell in
worksheet #1 I get a circular reference error. How can I get the cells in
worksheet #2 to equal the corresponding cells in worksheet #1? Thanks, JS
 
A

Adnan

Copy the contents of the cell from worksheet # 1, and paste it to the
destination (cell in worksheet # 2) by choosing Edit>Paste Special>Paste Link.
 
J

Jamie

Any automatic update option versus manual? I want to have it update
automatically if I make any changes on worksheet #1 with cutting and pasting.
Plus, want to save time. Thanks, JS
 
A

Adnan

As far as I understand, my previous tip is just what you need. Try that if
you haven’t tried it yet.
You won’t paste the actual value (data), you’d paste the link only
(formula). Changes on worksheet # 1 will also reflect on worksheet # 2.
 
Top