Hi,
I am new to VBA and some help creating a macro would be great! Attached is data that models my problem. Ideally, I would like the macro to recognize the value in the drop down menu in sheet2 cell B2 and pull in the corresponding data associated with that value from sheet1. Ideally, the macro would copy and paste the data in sheet1 to sheet2 to match the column headings for that particular value in sheet2 cell B2. So for example:
Sheet 1: Data set
Sheet 2: "ABC, Inc." is selected in the drop down menu in cell B2:HTML Code:
After the macro fires, the result on sheet2 is:HTML Code:
If I need to be more specific or provide any additional information please let me know. I am indeed new to VBA.HTML Code:
Below is the code that is currently in Sheet2. I know it is wrong, but maybe you guys could help me tweek it to make it work properly according to what I laid out above:
Thanks very much!HTML Code:
Bookmarks