Good question, Thomas. If you have RPA tooling and skills handy, you can certainly use that approach. A skilled VB developer could also do this with macros and lookups. Parameters for a fit-for-purpose between both would include the frequency of the procedure and the stability of the structure of the files to compare. Some authentication/security considerations as well. More importantly in favor of RPA, if additional automation could bring business value beyond the creation of another file (for instance, by adding the data straight into another system).
------------------------------
Jean Pommier
Distinguished Engineer, IBM Business Automation
------------------------------
Original Message:
Sent: Thu March 02, 2023 09:17 AM
From: Thomas Weston
Subject: Moving data from one Excel file to another
Hi I am trying to automate working with 2 excel files where if an order number doesn't exist in the main file then take it from the new file and add the data in.
And loop through the file until every row has been checked.
Is it better to do this work in a Macro then use RPA to run the Macro?
------------------------------
Thomas Weston
------------------------------