bspaulding45
New Member
- Joined
- Jan 13, 2015
- Messages
- 14
Hello,
I was wondering if I could get some help. I seem confused on how to create a VBA code for a specific function I am working on. I am a beginner, so I apologize. I have searched here and Google, but it seems to be confusing me more and more as I search.
Anyways, here is what I am trying to achieve. I have two worksheets. WS1 is opened first and when I run the macro, it will open a specified WS2 in a folder. When WS2 is open, I need to compare Column A from WS1 to Column D in WS2. If there are any matches, I need to copy the cell value in Column D from WS1 to a new worksheet. I have tried using a 'for each cell in' method and cannot seem to get it to work. Can someone guide me down the right path, please? Any and all help will be greatly appreciated. Thank you.
I was wondering if I could get some help. I seem confused on how to create a VBA code for a specific function I am working on. I am a beginner, so I apologize. I have searched here and Google, but it seems to be confusing me more and more as I search.
Anyways, here is what I am trying to achieve. I have two worksheets. WS1 is opened first and when I run the macro, it will open a specified WS2 in a folder. When WS2 is open, I need to compare Column A from WS1 to Column D in WS2. If there are any matches, I need to copy the cell value in Column D from WS1 to a new worksheet. I have tried using a 'for each cell in' method and cannot seem to get it to work. Can someone guide me down the right path, please? Any and all help will be greatly appreciated. Thank you.