Hey there, thanks in advance to anybody who can help.
I'm attempting to create an interface in which users can pull data from a larger table and view it more easily.
This is working happily with the use of VLOOKUP and ActiveX ComboBoxes.
What I can't seem to accomplish is pulling data from the larger table with said VLOOKUP's and then modifying it.
I wish to allow users to modify the data in the smaller table and then have the data return, modified to the larger table, edited.
Is there possibly way to do this?
I'm attempting to create an interface in which users can pull data from a larger table and view it more easily.
This is working happily with the use of VLOOKUP and ActiveX ComboBoxes.
What I can't seem to accomplish is pulling data from the larger table with said VLOOKUP's and then modifying it.
I wish to allow users to modify the data in the smaller table and then have the data return, modified to the larger table, edited.
Is there possibly way to do this?