shmilo
06-22-2008, 01:42 AM
Hi,
I have two sheets.
One has a list of part names in column 1, and the second sheet is for customer used parts in column 1 and quantities in column 2.
I need to find the part number from the customer sheet in the part numbers sheet, and add this quantities to column 2 of the part numbers.
By doing a line by line search, the program time running is large (I have about 5000 parts).
I used the filter in order to see the line with the correct number using:
ValPrice = Cells(ShRow, 2)
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=ValCell
This shows me the row with the number I need.
My question is, if there is a way to get the actual cell or row number of the filtered cell. This way I will be able to change the value of the cell on his right.
If not, is there a fast way to do the search and match? (Fast program execution).
I have two sheets.
One has a list of part names in column 1, and the second sheet is for customer used parts in column 1 and quantities in column 2.
I need to find the part number from the customer sheet in the part numbers sheet, and add this quantities to column 2 of the part numbers.
By doing a line by line search, the program time running is large (I have about 5000 parts).
I used the filter in order to see the line with the correct number using:
ValPrice = Cells(ShRow, 2)
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=ValCell
This shows me the row with the number I need.
My question is, if there is a way to get the actual cell or row number of the filtered cell. This way I will be able to change the value of the cell on his right.
If not, is there a fast way to do the search and match? (Fast program execution).