Hi,
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.
Kind regards,
05125668