For each Row & Column

[Mr.R0bot (Mr Robot)]

Employees do their schedule with a Excelfile on Teams.

Column A is employees, row 1 is the month and row 2 is the day. I would like to go trough all rows and columns and when it finds a value of ‘W’ in a column it also gets row 1 & row 2 at that column. So at C3, it assigns strMonth=8 & strDay=22 and like Q4 assigns strMonth=9 & strDay=5.

Have come this far, it loops trough columns in rows that has numerical in column A.

[supermanPunch (Arpan)]

@Mr.R0bot

So at C3, it assigns strMonth=8 & strDay=22 and like Q4 assigns strMonth=9 & strDay=5.

Hi @Mr.R0bot ,

Could you let us know what is the Expected Output Representation ? Is it to be updated in a Excel sheet ? A Sample Expected output would help us to suggest faster with better approached.

[Mr.R0bot (Mr Robot)]

Im going to use it in another application, for now I just need to get data for the strDay and strMonth strings from row 1&2.