Making Cells Match Across Sheets

cscld

New Member
Joined
Jan 3, 2013
Messages
9
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
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Tyron

Active Member
Joined
Dec 5, 2012
Messages
258
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,916
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top