F
Frosty
I have a workbook with 12 sheets in it representing the Months of th
year. On each worksheet on Column A, there are 4 grocery store names
store numbers, 3 empty cells, then 4 more grocery store names followe
by 3 empty cells. This pattern continues down the column until you hav
about 12 grocery stores showing and 9 empty cells total. This is onl
columns, no rows were added yet.
The worksheet is starting with 4 grocery store names and numbers now
but will eventually have two more grocery store names and numbers adde
later on.
On the first worksheet labeled January on the first Column A, the firs
6 cells will be Store#1, Store#2, Store#13, Store#94, -Store#95
Store#106.- I want to link cells A1 through A6 to the next six cell
below (skipping one cell to separate the groups). So cells A8 throug
A13 will have whatever is typed into A1 thru A6. Simple copy & past
special & paste link. Right? And I want this to link to the othe
worksheets, so I simply go to the other worksheet's column A and ente
an equal sign to link worksheet one cells. So whatever store I type i
worksheet 1 labeled January, will be on all the worksheets.
Okay.
Now this pattern continues to June or the 6th worksheet. Now th
problem starts when I have to add a totally different store name an
number. In the June or 6th worksheet, cell A5 needs to change t
Store#2323. But if you recall, worksheet 1 already has the nam
Store#95. I also know that in August or the 8th worksheet, I will b
changing the name again to Store#5656.
How can I link all the worksheets so that when I change the store nam
& number mid-way, it will populate the rest of the worksheets fro
there on. For example, Store#95 changes to Store#2323 in June, but fo
the months of Jan-July, Store#95 populates. In June, Store#2323 is i
and populate the worksheets June-July. In August, Store#5656 will b
named for the remainder worksheets Aug-Dec.
A special thank you in advance for reading this far. This was the onl
way I could explain the type of linking problem I have. I'm open to an
solutions you may have.
I attached a sample of the spreedsheet "Changing_a_Link_Midway.xls" i
.zip format. The links I created were removed and the areas of chang
were marked.
Frost
+-------------------------------------------------------------------
|Filename: Changing_a_Link_Midway.zip
|Download: http://www.excelforum.com/attachment.php?postid=3739
+-------------------------------------------------------------------
year. On each worksheet on Column A, there are 4 grocery store names
store numbers, 3 empty cells, then 4 more grocery store names followe
by 3 empty cells. This pattern continues down the column until you hav
about 12 grocery stores showing and 9 empty cells total. This is onl
columns, no rows were added yet.
The worksheet is starting with 4 grocery store names and numbers now
but will eventually have two more grocery store names and numbers adde
later on.
On the first worksheet labeled January on the first Column A, the firs
6 cells will be Store#1, Store#2, Store#13, Store#94, -Store#95
Store#106.- I want to link cells A1 through A6 to the next six cell
below (skipping one cell to separate the groups). So cells A8 throug
A13 will have whatever is typed into A1 thru A6. Simple copy & past
special & paste link. Right? And I want this to link to the othe
worksheets, so I simply go to the other worksheet's column A and ente
an equal sign to link worksheet one cells. So whatever store I type i
worksheet 1 labeled January, will be on all the worksheets.
Okay.
Now this pattern continues to June or the 6th worksheet. Now th
problem starts when I have to add a totally different store name an
number. In the June or 6th worksheet, cell A5 needs to change t
Store#2323. But if you recall, worksheet 1 already has the nam
Store#95. I also know that in August or the 8th worksheet, I will b
changing the name again to Store#5656.
How can I link all the worksheets so that when I change the store nam
& number mid-way, it will populate the rest of the worksheets fro
there on. For example, Store#95 changes to Store#2323 in June, but fo
the months of Jan-July, Store#95 populates. In June, Store#2323 is i
and populate the worksheets June-July. In August, Store#5656 will b
named for the remainder worksheets Aug-Dec.
A special thank you in advance for reading this far. This was the onl
way I could explain the type of linking problem I have. I'm open to an
solutions you may have.
I attached a sample of the spreedsheet "Changing_a_Link_Midway.xls" i
.zip format. The links I created were removed and the areas of chang
were marked.
Frost
+-------------------------------------------------------------------
|Filename: Changing_a_Link_Midway.zip
|Download: http://www.excelforum.com/attachment.php?postid=3739
+-------------------------------------------------------------------