linking two cells from two different worksheets

  • Thread starter Thread starter Fury
  • Start date Start date
F

Fury

This may sound like a basic question, but I can't figure out how to mak
it so when you enter information into cell A1 on worksheet 1, i
populates into cell A1 in worksheet 2(when it is blank), AND that cel
A1 in worksheet 2 (when data is filled in) will populate into cell A
of worksheet 1(when it is blank). Is this a circular reference issue?
New lines are constantly being added to this file from two differen
sources, so the range will automatically have to change as well.... I'
sure that this is possible, and can be set up for the entire column i
each respective sheet.

Any help would be greatly appreciated.


Jos
 
Hi Jose
this is a circular reference. You either have to decide which of both
sheets is your master sheet or you may use VBA (process the
worksheet_change event) to accomplish this 'mirror functionality'.

I would recommend to create a master entry sheet and reference this
master sheet
 
Back
Top