Needing help Exporting data from one workbook to another.
Example:
1. Using values posted in Column A in Worksheet1 (of Workbook A); [A2: Last Row],
2. Search, filter and find the matching values in Column A in Worksheet1 (of Workbook B); [A2:Last Row].
3. from filtered results, copy range of data from row of matching value. Copy values of Range E:12 through EE and paste in 'Workbook A' cells EE:12 through EE:12.
4. If there are multiple result items from the Filter based from Column A in Worksheet1 (of Workbook A); [A2: Last Row] then create new rows directly below initial value listed in Worksheet1 (of Workbook A); [A2: Last Row].
Please let me know if you need more clarity.
Thanks!
Bookmarks