Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search values in named formulas
I recieve worksheets that are exported from a user in the field and I
import the worksheet to a master workbook. The Master and Field workbook have the same named ranges and named formulas. The imported workbook's named formulas refer back to the field workbook. manualy correcting the named formulas is very time consuming and easy to screw up. Has anyone sucessfully created code to find and replace in names? Or have sugestions as to how to deal with this? Thanks Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search a named range | Excel Worksheet Functions | |||
Sum values in columns based on values in named range | Excel Worksheet Functions | |||
Named ranges and pasting formulas with named references | Excel Programming | |||
Search and replace using a named array on another worksheet | Excel Programming | |||
Changing Default Search in to Values Not Formulas in Excel | Excel Discussion (Misc queries) |