| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I read & write in a Vlookup cell (same as editing an Acces
How can I read & write in a Vlookup cell (same as editing an MS Access record)?
First, I need to be able to update comments when I retrieve a Vlookup query. Secondly, when I get a record, I want to be able to update it and save my updates somewhere as history. Regards, Bakhsh_UOP |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I read & write in a Vlookup cell (same as editing an Acces
You really can't do what it is you are wanting. Formulas can only return
values, they can not update the values they are referencing. If I understand you correctly you want the formula to update the constants in the list of records you are looking up into. That would form a circular reference. -- HTH... Jim Thomlinson "Bakhsh_UOP" wrote: How can I read & write in a Vlookup cell (same as editing an MS Access record)? First, I need to be able to update comments when I retrieve a Vlookup query. Secondly, when I get a record, I want to be able to update it and save my updates somewhere as history. Regards, Bakhsh_UOP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| read only and write only | New Users to Excel | |||
| I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
| How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
| Who has read/write | Excel Programming | |||
| write to/read from add-ins | Excel Programming | |||
Hybrid Mode
