S
shaunvfx
It has been said to me that linking multiple cells isn't possibl
without the use of VB.
Here is my situation. I am creating a schedule for designers by th
week. I have many different people to schedule for and they all wor
in different territories. To make things more complicated eac
designer services 2 territories so I have many overlapping cells if
were to break down the schedule into sheets based on territory.
The solution I can see is making a master sheet which would referenc
all of the designers and their schedule for the week, and have 2-
other sheets that reference the master sheet for the schedule. On to
of that I would like to be able to change the schedule from the maste
sheet and see it update on all of the territory sheets as well a
schedule from the territory sheet and see it update on the maste
sheet.
I work for a well known company that is nation wide, but we ar
franchise based and thus are stuck trying to find our own solutions fo
basic problems.
I am interested in possibly hiring someone to create the skeleton o
the schedule which then could be further maintained by me. My hol
back is my experience with VB which is next to none but not without
clue.
You can contact me at (e-mail address removed) for more information, or an
further posts and replies would be appreciated
without the use of VB.
Here is my situation. I am creating a schedule for designers by th
week. I have many different people to schedule for and they all wor
in different territories. To make things more complicated eac
designer services 2 territories so I have many overlapping cells if
were to break down the schedule into sheets based on territory.
The solution I can see is making a master sheet which would referenc
all of the designers and their schedule for the week, and have 2-
other sheets that reference the master sheet for the schedule. On to
of that I would like to be able to change the schedule from the maste
sheet and see it update on all of the territory sheets as well a
schedule from the territory sheet and see it update on the maste
sheet.
I work for a well known company that is nation wide, but we ar
franchise based and thus are stuck trying to find our own solutions fo
basic problems.
I am interested in possibly hiring someone to create the skeleton o
the schedule which then could be further maintained by me. My hol
back is my experience with VB which is next to none but not without
clue.
You can contact me at (e-mail address removed) for more information, or an
further posts and replies would be appreciated