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

Copy the contents of the cell from worksheet # 1, and paste it to the
destination (cell in worksheet # 2) by choosing EditPaste SpecialPaste Link.

--
Please post all your inquiries on this community so we can all benefit -
Thank you!


"Jamie" wrote:

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

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

"Adnan" wrote:

Copy the contents of the cell from worksheet # 1, and paste it to the
destination (cell in worksheet # 2) by choosing EditPaste SpecialPaste Link.

--
Please post all your inquiries on this community so we can all benefit -
Thank you!


"Jamie" wrote:

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

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

--
Please post all your inquiries on this community so we can all benefit -
Thank you!


"Jamie" wrote:

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

"Adnan" wrote:

Copy the contents of the cell from worksheet # 1, and paste it to the
destination (cell in worksheet # 2) by choosing EditPaste SpecialPaste Link.

--
Please post all your inquiries on this community so we can all benefit -
Thank you!


"Jamie" wrote:

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