I'm currently relatively new to the VBA arena and am trying to solve a time consuming task via the help of VBA in Excel.
I have attached an very basic example of the excel data and layout I'm working with. This is what I need the code to do:
1. Search for the string in Sheet 1 (cell A2) and find it in Sheet 2.
2. Copy the entire column of the found column.
3. Paste the formulas/data in the column next to the found column.
Do you think there is anyone how could potentially help me with this problem?
Thanks in advance for the help.