Read specific sheet from workbook

Question

How to read specific sheet based on the cell value in the sheet.

Workbook contains multiple sheets named as sheet1, sheet2, sheet3, sheet4, sheet5. One sheet contains value as 'Official Cheques'  should  read the data into designer,(but no other sheets should be read)  and actual data will start from row 19. Attached the sample workbook for reference. Sheet 1 in the attached file should be read.

Note: Official cheques will be in any sheet, not in sheet1 every time.

Please provide any solution

test input file.xlsx

usmanbashir · Accepted Answer

@Neelima1 - Please see attached workflow. I created a batch macro that iterates through each file/sheet and searches for 'Official Cheques' within the sheet, and outputs that fullpath with sheet name. It'll then read the specific sheet and start on line 19 as you specified. Hope this helps!