Hi
I have a data validation list in cell B1. Once a value is selected by the user, they will enter a value in cells I5 and J5. I would like a macro that will save the entered values in I5 and J5 information in another worksheet (same workbook) based on the value in B1.
For example, say the validation list in cell B1 on worksheet "Sheet 1" includes US state names. There are is a cell for the state capital in cell I5 and the state bird in cell J5. "Sheet 2" contains the list of all the state names in column A and has a column for state capitals in column B and a column for state birds in column C. The user will selecting a state in the validation list in Sheet 1 and then enter the state capital and bird. The macro would copy the entered values into columns B and C in the corresponding state row of Sheet 2 and then save the workbook.
Many thanks for your help!
-Paul
I have a data validation list in cell B1. Once a value is selected by the user, they will enter a value in cells I5 and J5. I would like a macro that will save the entered values in I5 and J5 information in another worksheet (same workbook) based on the value in B1.
For example, say the validation list in cell B1 on worksheet "Sheet 1" includes US state names. There are is a cell for the state capital in cell I5 and the state bird in cell J5. "Sheet 2" contains the list of all the state names in column A and has a column for state capitals in column B and a column for state birds in column C. The user will selecting a state in the validation list in Sheet 1 and then enter the state capital and bird. The macro would copy the entered values into columns B and C in the corresponding state row of Sheet 2 and then save the workbook.
Many thanks for your help!
-Paul
