How to merge excel files into 1 excel file which excel has formulas ?
File sample 1 (the file I will merge) . As you can see when on column i when you click the 0 it shows the formula
When I merge that into 1 excel file the formula should not be remove and should still be the same like what you can see above.
Files to merge:
100_2020 Budget.xlsx (14.4 KB) 150_2020 Budget.xlsx (14.1 KB)
Output : output should be 1 excel file with still having the formula when you click the 0 or the formula as example above. Thanks