| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup & Template
I have a template with several vlookups in it. When use the template
and save a document from it I would like the vlookups to become normal text is there a simple way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup & Template
You can convert the result of any formula to hard data by copying and then
Paste Special and selecting Values. Hope this helps. -- Elisabeth "KurtB" wrote: I have a template with several vlookups in it. When use the template and save a document from it I would like the vlookups to become normal text is there a simple way to do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup & Template
....and if you wanted to take that a step further, you could possibly automate
it by recording a macro that would select the entire sheet, and then copy/paste special the values. If you name the macro "Auto_Close" (no quotes) it will run automatically when you close the file. "Elisabeth" wrote: You can convert the result of any formula to hard data by copying and then Paste Special and selecting Values. Hope this helps. -- Elisabeth "KurtB" wrote: I have a template with several vlookups in it. When use the template and save a document from it I would like the vlookups to become normal text is there a simple way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup a Vlookup | Excel Worksheet Functions | |||
| =IF problem | Excel Discussion (Misc queries) | |||
| Need One Excel Template to copy to TWO Databases | Excel Discussion (Misc queries) | |||
| how do I change an excel template into a "workbook" | Excel Discussion (Misc queries) | |||
| vlookup template -> table_array | Excel Worksheet Functions | |||
Hybrid Mode
