Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Applying range names to existing formulas in separate worksheets
I have a complex workbook, developed by someone else, that has many tabs.
Many of these tabs pull data from one or two input worksheets. I am naming the tables of data on the input sheets automatically using the insert/name/create/(using row and column headers for names). I then used insert/name/apply to apply these new names. When I do this, formulas on the same tab pick up the new names, but formulas in other tabs do not. If I type in a new formula on those other tabs using the new range names, however, it works. So I know the names are being recognized in those tabs, but they are not replacing the cell references in formulas in those tabs. If I can find a way to make this work, it will save me a lot of grief. What am I doing wrong?? Thanks in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you set up range names, name formulas | Excel Worksheet Functions | |||
dynamic range name | Excel Discussion (Misc queries) | |||
range names | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions |