Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Linking
I need to link the 'total' cell from one worksheet to a cell on another. I
can do this by 'paste link', but when I insert rows in the source worksheet, the link no longer works. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Linking
Use a formula of the form =Sheet1!A1
Starting in the cell where the formula is required, type = Click the tab of the other sheet, then click the cell in that sheet Press enter If the sheet name has spaces, the resulting formula with have the name in single quotes. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dempsey24" wrote in message ... I need to link the 'total' cell from one worksheet to a cell on another. I can do this by 'paste link', but when I insert rows in the source worksheet, the link no longer works. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking cells by name only to another worksheet.... | Excel Worksheet Functions | |||
Linking a worksheet from a different excel file | Excel Discussion (Misc queries) | |||
Excel 2003 - Linking Formulas, Worksheet to Worksheet | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
how do i use sumif when linking worksheet | Excel Discussion (Misc queries) |