Good day all, i am going to try and explain the best i can.
I have a quote on a workbook with 8 sheets which are all named. The
sheet i have to look at to get part numbers looks like this:


"C" "D" "E" "F" "G"
FT E90 FT E90 FT E90 FT E90
6938209 6938210 6938243 6938211
"Two empty rows"

6928614 x x
6930622 x
6930636 x
6930623 x
6930624
6928620 x

I have to start in column "D" at the number, normally row10 but can vary
by 1 or two lines... i than have to look down the column to the first x
and get the number in column "C" in the same row and look it up in
another sheet called "Modules", which looks like this:

"A" "B" "C" "D"

Nr. Modulbezeichnung Sach-Nr. Price
"There is two empty rows here"

1 MD BASIS E87 FT 6928614 34.25
2 MD SPIEGEL LOW OHNE LIN FT 6928615 1.32
3 MD SPIEGEL HIGH MIT LIN FT E87 6928617 5.23
4 MD SPIEGEL L/H M/O LIN FT E87 6930635 1.23
5 MD SPIEGELHEIZUNG FT 6928618
6 MD VORFELDBELEUCHTUNG FT 6928619
7 MD COMFORT ACCESS FT 6928621
8 MD SCHLOSSSCHALTER FT 6938251
9 "Empty Line"

I have to find the same number in column "C" and get the price in column
"D" store it as a variable and do the same with the next x until i get
to the last number, then add the varaibles and put the total in the cell
at the bottom of the column "D" in the first sheet. I then need to move
to the next column and repeat the process until i reach the last number
in row 10. I need some advice and code if possible please.

thanks in advance.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***