How do I paste data from one excel file to another

Hi All,

I have a specific range of data in one excel and I want to paste it to another.Data is in the form of like Range : A1:D16

how do I achieve this please help.

read data with read range and store it in datatable then give datatable to write range for the sheet you waana to enter data

1 Like

I tried that , actually I also want to paste formulas if it preset n the cells of input excel sheet

copy paste range of excel can be used

1 Like