Making Cells Match Across Sheets

[cscld]

Hello,

I am looking for a way to make cells equate across sheets. For example if you enter a name on worksheet 1 and have it copy to worksheet 2 I wold like to be able to modify it on worksheet 2 and have it update on worksheet 1.

Thanks,
c

 

[Tyron]

Hey cscld,

Is it possible that you could guarantee that a particular sheet would be the master sheet? If so then you could use Vlookup/Hlookup across all sheets.

If not then you may have to use VBA to accomplish this task.

Anyone else out there have an idea on how to do this? It seems to me that it would be necessary for some VBA to check each sheet and then do a "find/replace" type scenario.

later

Ty