HELP!! Linked Cells

S

shaunvfx

Hi everyone I have spent several hours trying to figure out a way to
link cells together. Here is basically what I am trying to achieve.

I have a master sheet with many categories. I have filtered sheets
that I basically want to use to reference data from the master as well
as update information to the master.

So basically if I had cell A1 on the master sheet and cell E5 on
another, I want the two cells to be treated as one, If I change
something in A1 I want it to change on E5 and if I change it on E5 I
want it changed on A1, does anyone understand what I am trying to
achieve!?

This is my biggest holdback on my current project, any help will be
greatly appreciated.

-Shaun
 
D

Duke Carey

Links are ONE WAY. You can have E5 reflect changes in A1. *OR* you can have
A1 reflect changes in E5. But you can't do both, at least not with formulas.

You can do that with VBA code that is triggered when a change is made to the
worksheet. If that's the route you want to follow, post back with some
greater detail and people will try to help
 
S

shaunvfx

Basically I am setting up a scheduling system using excel. I hav
thought about using access but the main function of this system is fo
it to be visually communicative.

I am scheduling for for designers in different territories... I want t
be able to schedule these designers by territory and by the maste
sheet, the problem is, is that all the designers have 2 territorie
they service and they are all different.

My idea was to set up a master sheet with all the designers informatio
so that I can look at the data that way, and I also wanted to set u
sheets per territory that would also display the same schedule for th
designer just in a less visually complex way.

So say I have 5 territories and 20 designers. I want 6 sheets,
master and one for each territory.

I want to be able to enter information in any of the fields pe
designer whether that designer services 1-3 territories.... s
basically I want to be able to schedule someone in 3 or more differen
cells on different sheets but have them all linked together.

Is this possible and can someone give me some advice as to how I woul
do this?

-Shau
 
Top