Hi all,
I am a little stuck on an excel VBA problem with copying and pasting data using a drop down list.
I have an excel workbook with a worksheet (“LoadData”) that has all the databased data.
On another worksheet (“LookUp”), I have a dropdown (data validation) in cell A1. This dropdown is a list of names. When you select a name from the dropdown list, it updates a certain range on the LoadData worksheet (“A2:AA2”) by pulling in data from the database sheet using formulas.
I am trying to create an excel macro that will loop through the dropdown list one at a time, copy the data range for each name and then paste the data range in the worksheet that corresponds to the name that is selected in the dropdown list (the worksheets are already named based on the list). I need it to paste the data (values only) on the next empty row on the specific worksheet.
Alternatively, i could have a macro for each name and copy/paste data that way, but was hoping for one click rather than one click for each name
Thanks in advance for your help.
I am a little stuck on an excel VBA problem with copying and pasting data using a drop down list.
I have an excel workbook with a worksheet (“LoadData”) that has all the databased data.
On another worksheet (“LookUp”), I have a dropdown (data validation) in cell A1. This dropdown is a list of names. When you select a name from the dropdown list, it updates a certain range on the LoadData worksheet (“A2:AA2”) by pulling in data from the database sheet using formulas.
I am trying to create an excel macro that will loop through the dropdown list one at a time, copy the data range for each name and then paste the data range in the worksheet that corresponds to the name that is selected in the dropdown list (the worksheets are already named based on the list). I need it to paste the data (values only) on the next empty row on the specific worksheet.
Alternatively, i could have a macro for each name and copy/paste data that way, but was hoping for one click rather than one click for each name
Thanks in advance for your help.