Lonestryder
New Member
- Joined
- Oct 4, 2006
- Messages
- 3
Hi all.
Excel 97 - Windows XP
I've created a table that allows validation list entry in a few cells, while others, based on the user selection, pull relevant data from a table (via vlookup).
Once the initial data is entered/displayed, is there a macro available (button, ect.) that, once pressed, will save the data cells to row elsewhere in the worksheet/book? This will allow me to make multiple entries without having to write down the data pulled from the vlookup.
For example:
user entry cell A1 = Job Title
a number of vlookup formulae pulls from a table that populates data into these cells based on user selection (e.g. avg salary). I would like to save this data somewhere, via macro button, thus allowing the user to enter something else into cell A1, and so on.
Thanks!
Excel 97 - Windows XP
I've created a table that allows validation list entry in a few cells, while others, based on the user selection, pull relevant data from a table (via vlookup).
Once the initial data is entered/displayed, is there a macro available (button, ect.) that, once pressed, will save the data cells to row elsewhere in the worksheet/book? This will allow me to make multiple entries without having to write down the data pulled from the vlookup.
For example:
user entry cell A1 = Job Title
a number of vlookup formulae pulls from a table that populates data into these cells based on user selection (e.g. avg salary). I would like to save this data somewhere, via macro button, thus allowing the user to enter something else into cell A1, and so on.
Thanks!