Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
linking cells
The answer to this ? may be easy, but I'm having difficulties. I have 26
sheets in on wkbk. When I change one particular cell (a title w/ date) on the 1st sheet I would like the same cell on the following 25 sheets change to exactly what the cell on the 1st sheet was changed to. Anyone help me? |
#2
|
|||
|
|||
linking cells
groupchangeungroup
group by ctrl key +selecting the sheets desired or right click and use select all sheets -- Don Guillett SalesAid Software "ATaylor" wrote in message ... The answer to this ? may be easy, but I'm having difficulties. I have 26 sheets in on wkbk. When I change one particular cell (a title w/ date) on the 1st sheet I would like the same cell on the following 25 sheets change to exactly what the cell on the 1st sheet was changed to. Anyone help me? |
#3
|
|||
|
|||
linking cells
If your sheets are named Sheet1 through Sheet26 and Sheet1 is the source of
all updates, you would enter a formula on Sheet2 through Sheet26 that reads =Sheet1!A1 (if A1 if the cell you're linking). You can do this easily by selecting all but the first sheet (click on the tab for Sheet2, then shift-click on the tab for Sheet26, then click in A1 and enter the formula). --Bruce "ATaylor" wrote: The answer to this ? may be easy, but I'm having difficulties. I have 26 sheets in on wkbk. When I change one particular cell (a title w/ date) on the 1st sheet I would like the same cell on the following 25 sheets change to exactly what the cell on the 1st sheet was changed to. Anyone help me? |
#4
|
|||
|
|||
linking cells
My sheets are actually named A through Z, so I'm assuming I just type in A,
B, C, etc. instead of Sheet 1, 2.. ?? "bpeltzer" wrote: If your sheets are named Sheet1 through Sheet26 and Sheet1 is the source of all updates, you would enter a formula on Sheet2 through Sheet26 that reads =Sheet1!A1 (if A1 if the cell you're linking). You can do this easily by selecting all but the first sheet (click on the tab for Sheet2, then shift-click on the tab for Sheet26, then click in A1 and enter the formula). --Bruce "ATaylor" wrote: The answer to this ? may be easy, but I'm having difficulties. I have 26 sheets in on wkbk. When I change one particular cell (a title w/ date) on the 1st sheet I would like the same cell on the following 25 sheets change to exactly what the cell on the 1st sheet was changed to. Anyone help me? |
#5
|
|||
|
|||
linking cells
If all sheets are to refer to a particular cell on the first sheet(A) then
just group sheets B through Z by selecting tab B then hold SHIFT key and select tab Z. You do not need to type A, B, C, D etc if all sheets refer to just A. Select a cell on active sheet(B) and type in =A!A1 or whatever particular cell you wish. This formula will be entered on B through Z and the contents will update whenever the cell on A is altered. If something else desired please post back. Gord Dibben Excel MVP On Mon, 31 Oct 2005 11:59:40 -0800, "ATaylor" wrote: My sheets are actually named A through Z, so I'm assuming I just type in A, B, C, etc. instead of Sheet 1, 2.. ?? "bpeltzer" wrote: If your sheets are named Sheet1 through Sheet26 and Sheet1 is the source of all updates, you would enter a formula on Sheet2 through Sheet26 that reads =Sheet1!A1 (if A1 if the cell you're linking). You can do this easily by selecting all but the first sheet (click on the tab for Sheet2, then shift-click on the tab for Sheet26, then click in A1 and enter the formula). --Bruce "ATaylor" wrote: The answer to this ? may be easy, but I'm having difficulties. I have 26 sheets in on wkbk. When I change one particular cell (a title w/ date) on the 1st sheet I would like the same cell on the following 25 sheets change to exactly what the cell on the 1st sheet was changed to. Anyone help me? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking cells
I am working with a similar situation. I have a source document that gets
updated with information about gifts/donations made to the organization. There is an independent worksheet document that I attach to the original check for deposit that has only some of the information on the source document. (i.e donor name/address, amount of donation, etc.) I would like to have the worksheet automatically populated when I enter information in the source document. Taking into consideration that each time I update the source document the information is put on another row. How can I link these documents to accomplish this. "bpeltzer" wrote: If your sheets are named Sheet1 through Sheet26 and Sheet1 is the source of all updates, you would enter a formula on Sheet2 through Sheet26 that reads =Sheet1!A1 (if A1 if the cell you're linking). You can do this easily by selecting all but the first sheet (click on the tab for Sheet2, then shift-click on the tab for Sheet26, then click in A1 and enter the formula). --Bruce "ATaylor" wrote: The answer to this ? may be easy, but I'm having difficulties. I have 26 sheets in on wkbk. When I change one particular cell (a title w/ date) on the 1st sheet I would like the same cell on the following 25 sheets change to exactly what the cell on the 1st sheet was changed to. Anyone help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use functions when cells are merged | Excel Worksheet Functions | |||
Linking cells | Excel Worksheet Functions | |||
linking cells and assort decending | Excel Discussion (Misc queries) | |||
Excel - linking cells | Excel Worksheet Functions | |||
Linking Non-Contiguous cells | Excel Discussion (Misc queries) |