| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing linked worksheet and range of cells
Hello
I have a spreadsheet (master spreadsheet) which counts the number of times individual countries appear in one column on a linked spreadsheet. The linked spreadsheet and range of cells always changes. How can I update my master spreadsheet to count the number of times a country appears in the new range of cells in the new linked spreadsheet? I figured out how to update the link to a new spreadsheet but not how to change the range of cells. -- Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with changing formula linked to another worksheet | Excel Worksheet Functions | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| monitoring a changing range of cells | Excel Discussion (Misc queries) | |||
| monitoring a changing range of cells | Excel Worksheet Functions | |||
| GoTo the cells in another worksheet that are linked | Excel Worksheet Functions | |||
Threaded Mode
