Let's say that I have two workbooks: File X and File Y. (both .csv files) I am looking to create a Macro that copies from a certain cell in File X to a specific cell in File Y. This would be done based off a query.
Example: Compares all values listed in Column A of File X to all values listed in Column A of File Y. If value matches in column A in both files (let’s say: IF ID = 5), it then retrieves information from Column J of File X for that row and pastes it in the corresponding row of File Y Column J.
Is this possible? And if so, how could one do this?