| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i automatically insert a file name into a formula from a ta
how do i automatically insert a file name into a formula from a table of file
names so as to obtain an automatic referal within a series of formulae |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i automatically insert a file name into a formula from a ta
say you already have a column of something like:
=A1 to change this to give a file reference use find/replace replace what = replace with =[Book2]Sheet1! -- Gary's Student gsnu200708 "AMabin" wrote: how do i automatically insert a file name into a formula from a table of file names so as to obtain an automatic referal within a series of formulae |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i automatically insert a file name into a formula from a ta
=[f31]Sheet2!C3
"AMabin" wrote: how do i automatically insert a file name into a formula from a table of file names so as to obtain an automatic referal within a series of formulae |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert formula automatically with new entry | Excel Worksheet Functions | |||
| Can XLS automatically insert file properties fields into a header | Excel Worksheet Functions | |||
| Can you automatically insert a file path in an Excel document? | Excel Discussion (Misc queries) | |||
| HOW TO CREATE A FORMULA TO AUTOMATICALLY INSERT THE DATE | Excel Discussion (Misc queries) | |||
| Automatically insert row and copy formula | Excel Worksheet Functions | |||
Linear Mode
