i have data in 2 data tables with formulas in it and i want to combine 2 sheets data in Sheet 3
Financial Sample.xlsx (90.9 KB)
Hi @T_Y_Raju
Could you be more specific.
i want sheet 1 and sheet2 data to copied in Sheet3
Okay @T_Y_Raju
→ Use the Read range workbook activity to read the Sheet1 and store in a datatable called dt1.
→ Then use the write range workbook activity to write the dt1 to the Sheet3 in same excel.
→ Use another Read range workbook activity to read the Sheet2 and store in a datatable called dt2.
→ Then use the Append range workbook activity to append the dt2 to the Sheet3 in same excel.
Hope it helps!!
let me try and check thank you
If you find the solution for your query, You have to mark my post as solution to close the loop… @T_Y_Raju
Kindly close all the threads which are not closed.
Happy Automation!!
Hie @T_Y_Raju hope this is your query write
First excel sheet
Second Excel Sheet
Final Output Excel sheet3
Here Sequence
Mark it solution if it helps you find your answer …
cheers happy automation