How to merge excel files into 1 excel file which excel has formulas

Jelrey · October 27, 2020, 5:21pm

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.

Output : output should be 1 excel file with still having the formula when you click the 0 or the formula as example above. Thanks

Jelrey · October 27, 2020, 5:26pm

Thanks for any help.

prasath17 · October 27, 2020, 5:30pm

@Jelrey … Try with Copy Range…Where you can choose what kind of copy you want…Please refer the screen shot below…