I know how to do the following:

Sheet A: A large table full of data
Sheet B: A form, say a job application. You fill in a name that can be found on Sheet A and it pulls all the data from Sheet A that corresponds to that name to fill in the rest of the form.

What I'd like to learn, or know if it is possible is the following:

Once the name has been entered on Sheet B and the form has been filled out with the data from Sheet A is it possible to then edit the values on the form and have it save those edits back to the data on Sheet A? In other words return a reference to the cell on Sheet A that is editable rather than just the data that is in the cell on Sheet A.





[Edited on March 29, 2014 at 11:50 PM. Reason : -]

3/29/2014 11:47:45 PM

I mean you could do it with a simple macro. Set sheet B up with all the vlookup formulas. Then add a macro that runs whenever the name is entered that copies the entire sheet and pastes the values.

You could do it cleaner and nicer but that would be a simple fix.

3/29/2014 11:53:38 PM

Use Access for this instead of Excel

3/30/2014 2:58:45 PM

I may do that. No real pressure, just an excuse to learn more about excel. I may use it as an excuse to learn a bit of vba.

3/30/2014 3:57:27 PM