Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Altering data that was called with LOOKUP
Hi, I have a list of data approx 9000 lines long (32 columns), and have a seperate sheet that allows a user to input a code. This then retrieves their data item using vlookup(). I would like to let the user then amend the contents of one of the fields, thus updating the original data list. Is this possible? thanks -- Lynxbci3 ------------------------------------------------------------------------ Lynxbci3's Profile: http://www.excelforum.com/member.php...o&userid=10377 View this thread: http://www.excelforum.com/showthread...hreadid=487545 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Altering data that was called with LOOKUP
It could be possible, but you may find it easier to just use:
Data|Form from the data list worksheet. Data|Form supports 32 fields. If you need more, you may want to look at John Walkenbach's enhanced dataform: http://j-walk.com/ss/dataform/index.htm may be sufficient And if you want to create your own, then Debra Dalgleish has a get started with userforms: http://contextures.com/xlUserForm01.html Lynxbci3 wrote: Hi, I have a list of data approx 9000 lines long (32 columns), and have a seperate sheet that allows a user to input a code. This then retrieves their data item using vlookup(). I would like to let the user then amend the contents of one of the fields, thus updating the original data list. Is this possible? thanks -- Lynxbci3 ------------------------------------------------------------------------ Lynxbci3's Profile: http://www.excelforum.com/member.php...o&userid=10377 View this thread: http://www.excelforum.com/showthread...hreadid=487545 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup data from multiple sheets | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Lookup Access data in Excel | Excel Worksheet Functions |