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