![]() ![]() Open while Loop and set a condition if counter counter variable which starts with value = 1, => Get_Version_Item_Column ' Set Counter value = 1 to start the loop from the first row after the header in table 1 Sheet 1 Get Inserted value from the cell located inside the Sheet2 Select Sheet 2 to get the value inserted in the Cell B1 Get Column Number from table 1 Sheet1 where header name = The below variable used as a counter to go throw a loop for all the rowsĬreate a Function that will do the below in Order:.The below variable used to get the total number of used rows in the table.The below variable will hold the value of each row under the column to be used when comparing the values or each row.The below variable will hold the Item Progress Column number in the table.The below variable will hold the value of each row under the column to be used when comparing the values of each row.The below variable will hold the Item Version Column number in the table.The below variable will hold the inserted value need to be updated.Below is my solution for the above question. I would like to thank you all for your advice, after searching for the key code to know how to return the number of rows filled in a specific table, I found the solution and now I am able to do my logic.
0 Comments
Leave a Reply. |