I have a process where I readrange from an excel file and then copy the data on sheet1 and create another sheet which is sheet2 and then copy data from sheet1 to sheet2. I used read range , write range and write cell but the template is destroyed and affected when using write cell. How the data is presented is sheet1 it should be the same with sheet2 after copying …Any idea with this one ? Thanks.
How the data presented in sheet1 it should be the same when copied to sheet2 including template , fonts , color etc. including the data.Book1.xlsx (9.0 KB)
DoubleClick.xaml (4.9 KB)