Excel Scenario ( mutiple sheet)

I have a single workbook with several excel sheets available on each page, numbered 1, 2, 3, 4, 5, and 6. Three column names: rating, value, and month retrieve all three columns from Sheet 1; only retrieve column (value) Sheets 2, 3, 4, 5, and 6 are the only ones updated. 7. The month column has the same value on every sheet, however the value column differs on every sheet.

month, value, value, value, value, value, needed output (sheet 7).


Do you need to extract data from each sheet ?

Then use for each sheet in excel and inside loop use read rangw with currentsheet as the range …it would read whole into datatable


Extra data into data table ok but write specific column column 1, column 2

@Ninad_Falke it will be great if you give us an example !!!

Hi @Ninad_Falke

May be an sample excel file with dummy dats an expected output will help in giving me solution. Try sharing input and expected output file.


sample excel.xlsx (11.1 KB)

Data will be mentioned on input sheets 1, 2, 3,4 and 5, and output sheet 6 will be needed.

Hi @Ninad_Falke

Check out the below zip file. Hope this meets your requirement.

BlankProcess30.zip (70.8 KB)


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.