(Excel)

1. so I have 1 formula file
2. This formula file, has been logically organized to process 2 types of data files
3. I want the process to be done automatically
4. So I just need to enter 2 data files into the app
5. and the output is 2 types of data files, already processed and filled in
6. So I can use the application for the same type of data but different values

could it happen? what kind of application is suitable? sorry if my English is bad :)

CodePudding user response：

You have two options:

1. You can use VBA and in the Macro specify each Workbook you need to update
2. The better option is to use PowerQuery and M Language: you can use the formulas and the connections to make sure that both Workbooks are updated.

For further information about Power Query: https://support.microsoft.com/en-us/office/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a

https://www.howtoexcel.org/the-complete-guide-to-power-query/