- Joined
- Aug 27, 2011
- Messages
- 2
- Reaction score
- 0
Hi Guy's
I#m very new to excel programming and I need to create an Excel macro for a small application. I have a drop down list created in Excel and I need to assign a macro for the selected drop down list.
Sheet1: Drop-down list with three Items,
Item1
Item2
Item3
Sheet2:
Col1Row1 (data), Col2Row1 (Item1 --> Actually same Item name as drop down list)
Col1Row2 (data), Col2Row2 (Item2--> Actually same Item name as drop down list)
Col1Row3 (data), Col2Row3 (Item3--> Actually same Item name as drop down list)
In Sheet1 I need to create a macro that,
When I select the Item1 from the drop down list and if it matches with the name in cell Col2Row1 then I need to copy the cell Col1Row1 data into Sheet1.
Simillarly when I select the Item2 from the drop down list and if it matches with the name in cell Col2Row2 then I need to copy the cell Col1Row2 data into Sheet1.
Please help me out!!
Thank You.
-Arun
I#m very new to excel programming and I need to create an Excel macro for a small application. I have a drop down list created in Excel and I need to assign a macro for the selected drop down list.
Sheet1: Drop-down list with three Items,
Item1
Item2
Item3
Sheet2:
Col1Row1 (data), Col2Row1 (Item1 --> Actually same Item name as drop down list)
Col1Row2 (data), Col2Row2 (Item2--> Actually same Item name as drop down list)
Col1Row3 (data), Col2Row3 (Item3--> Actually same Item name as drop down list)
In Sheet1 I need to create a macro that,
When I select the Item1 from the drop down list and if it matches with the name in cell Col2Row1 then I need to copy the cell Col1Row1 data into Sheet1.
Simillarly when I select the Item2 from the drop down list and if it matches with the name in cell Col2Row2 then I need to copy the cell Col1Row2 data into Sheet1.
Please help me out!!
Thank You.
-Arun