I have to get the data from more than one excel in the file. (For example, in all excels, I must first get C2, D3, F5 on page1, then G12 on page2). then I want to print all the data in the form of new Excel A1, B1, C1, D1 in order. Then I have to create a pivot table from this data.
Akary.xlsx+Alt.xlsx+AYAK.xlsx = Newworksheet.xlsx
First all 3 files(Akary, Alt & AYAK), you will receive output in datatable,
Use append range activity to write above files data into one file(Newworksheet)
hi, help me please
deneme2.xaml (17.5 KB)
getting data from more than one excel. what I want to do in the project is actually reading 3 columns (C2,D3,F5) from page 1 and reading a column on page 2 (G12) and printing a new excel.