I have a set of excel docs 1& 2
1) In Excel 1 i have a fixed column called dimensionId that contains list of dimensionid's with in between empty cells.
Here, For each dimesionId, i need to check corresponding columns of L,M,N ,O(senior, mid, junior, student) & check If they contain letter Y (Open excel 2) and if empty ignore,check next.
I need to loop through the entire column of dimensionId one by one, please help me proceed with the logic.
2) If letter Y exists, open excel 2 and check if same dimesionId exists in column A.
New to autoit excel automation, Help me with logic to execute this.
Global $oExcel = _Excel_Open()
Global $oWorkbook = _Excel_BookOpen($oExcel, "D:\yta\Trial concept dimensions list.xlsx")
Local $read1 = _Excel_RangeRead ($oWorkbook,Default,"C3")
Attached exce 1 doc.