vlookup in vba using different sheets

Hi gang,

I am looking for a way to do a vlookup so just the value of the vlookup is left over in the cell.... and not the formula

i am also looking that the vlookup will take the value in the column in the column G in the sheet (named sheet#) and put that value in next to the right part number the sheet (an infinite number of them)

as you can notice sheet60 column G (vlookup) goes under A sheet61 column G (vlookup) went under B and so on

I want to use the vlookup since the part numbers are not always in the order 1,2,3,4,5 and some part numbers could be added and insterted like a part number 3.5 would go between part 3 and part 4...

i hope that i was clear

the way i would expect on doing it would be using 2 loops one looping though the pages and the other looping though the cells .. but i could be wrong

thanks again for the help in advance!!! here is the example file that goes with this problem

roomie 02-10-2013.xlsx

Please Login or Register  to view this content.

so i noticed that what i am asking for is not very clear so i made an example code of what i wanted but for a finite number of sheets and for a finite number of parts .. in this example their will always be no more then 2872 parts and no more then 4 sheets

the number of sheets can be greater then 4 and the number of parts can be greater then 2872 in my generic problemes
they can also be less then 4 and less then 2872..

The sheets of interest are always named Sheet with a number after them and the lowest number should go in the j column and the next sheet should be on the next column

i hope this is a little more clear please help me out i could use it ..

Please Login or Register  to view this content.

i forgot the before last line of code

can somone help please!?!?!