I am new to VB scripting and i am required to use VB to loop through the whole column in excel to label each row.
Need to get some help on this.
I have the following 2 tables:
Untitled.jpg
The condition is that i need to look and compare each row of the 2nd table (the X and Y value) with the X and Y values in the first table.
I will name the X and Y in table 1 as X1 and Y1 and X2 and Y2 for table 2.
The idea of it is to compare and assign the lower limit of the name to the rows in table 2.
Anybody got hints on how this can be done?
Bookmarks