| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update reference in multiple formulas
Hi,
Ive set up a few tables to with formulas to extract data from a large spread sheet which is produced every month. Im using Vlookup but every month the table_array part of the formula will need to be changed. Is there a way to update the table_array part for all the formulas all at once? Many thanks Luke |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Update reference in multiple formulas
Hi
You could use a named range to stand for the table_array. It could as well be dynamic if you want. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Luke" wrote: Hi, Ive set up a few tables to with formulas to extract data from a large spread sheet which is produced every month. Im using Vlookup but every month the table_array part of the formula will need to be changed. Is there a way to update the table_array part for all the formulas all at once? Many thanks Luke |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Update reference in multiple formulas
try with Indirect formula & column formula
e.q. in your destinational sheet u can use the formula : =INDIRECT("[book.name]"&COLUMN()&"!A1") then drag it toward the right HTH -- Regards, Sebation.G "Luke" ... Hi, Ive set up a few tables to with formulas to extract data from a large spread sheet which is produced every month. Im using Vlookup but every month the table_array part of the formula will need to be changed. Is there a way to update the table_array part for all the formulas all at once? Many thanks Luke |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Update reference in multiple formulas
Hi Luke,
Define a name for the range (InsertNameDefine) and use that in your formulas. You'll only have to update the definition. -- Kind regards, Niek Otten Microsoft MVP - Excel "Luke" wrote in message ... | Hi, | I've set up a few tables to with formulas to extract data from a large | spread sheet which is produced every month. I'm using Vlookup but every | month the "table_array" part of the formula will need to be changed. Is | there a way to update the "table_array" part for all the formulas all at once? | Many thanks | Luke | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet Reference Doesn't Update After Sort | Excel Worksheet Functions | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| transferring formulas with absolute reference to multiple tabs | Excel Discussion (Misc queries) | |||
| Update cell reference within a formula | Excel Discussion (Misc queries) | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
Linear Mode
