| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Range Reference Update in Vlookup
I have some data that I update every week. I use a macro to update
this data. The macro moves the old data down one row and copies the new data from various places and pastes it to the top row of my table. On some other sheets I have vlookups that reference this table. Each time that I run my macro to update my table the vlookup also updates and shifts my range down a row.... For example =VLOOKUP($A$4,$E$10:$E$500,1,False) becomes =VLOOKUP($A$4,$E$11:$E $501,1,False) How can I stop the VLOOKUP Range from updating each time I run my macro? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Range Reference Update in Vlookup
=VLOOKUP($A$4,$E:$E,1,False)
-- Regards, Tom Ogilvy "Matt.Russett" wrote: I have some data that I update every week. I use a macro to update this data. The macro moves the old data down one row and copies the new data from various places and pastes it to the top row of my table. On some other sheets I have vlookups that reference this table. Each time that I run my macro to update my table the vlookup also updates and shifts my range down a row.... For example =VLOOKUP($A$4,$E$10:$E$500,1,False) becomes =VLOOKUP($A$4,$E$11:$E $501,1,False) How can I stop the VLOOKUP Range from updating each time I run my macro? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| update vlookup formula sheet reference for multiple sheets | Excel Worksheet Functions | |||
| vlookup with range reference | Excel Discussion (Misc queries) | |||
| Disable Range Reference Update in Vlookup | Excel Programming | |||
| HowTo disable cell reference update | Charts and Charting in Excel | |||
| Update a range reference change | Excel Programming | |||
Linear Mode
