Mikeymike15
New Member
- Joined
- Jul 20, 2006
- Messages
- 33
Hi All,
Getting back into VBA and I'm definitely rusty.
Here is my situation and I hope someone can get me started
I have 2 Rows of Data. For each instance of an occurance in row B, I need the corresponding value in A to be placed in Row D.
6801 ATL
6802 BOS
6803 BOM
6804 CVG
6805 MNL
6806 NRT
6807 PDX
6808 ATL
6809 PDX
6810 BOS
6811 ATL
So for if I was selecting ATL,
Row D would look like this
D
6801
6808
6811
Anyone can help get me started. My mind is numb on trying to figure out the best way to handle the looping, dims, etc
Thanks,
Mike the rookie
Getting back into VBA and I'm definitely rusty.
Here is my situation and I hope someone can get me started
I have 2 Rows of Data. For each instance of an occurance in row B, I need the corresponding value in A to be placed in Row D.
6801 ATL
6802 BOS
6803 BOM
6804 CVG
6805 MNL
6806 NRT
6807 PDX
6808 ATL
6809 PDX
6810 BOS
6811 ATL
So for if I was selecting ATL,
Row D would look like this
D
6801
6808
6811
Anyone can help get me started. My mind is numb on trying to figure out the best way to handle the looping, dims, etc
Thanks,
Mike the rookie