Hi Noel, i mean the number of empty cells, as these are parts without an
order number which would be in column "N"

Summary Sheet:

"B" "C"
Bonnet Hood metal-Laepple 4161
Bumper (Front)-Venture 5111
Bumper (Rear)-Venture 5112
Centre Console-D&B CCL
Front End Module-Faurecia FRT
IMC-SAS IMC
Rear Axle Assembly-LMSA ACH

"LC SHEET":

A B C D F G
H N
4047116 3241 LC 4 SUCTION LINE 01 ACH
4047117 3241 LC 4 SUCTION LINE E9X AFS 01 ACH
4051502 3332 LC V DRIVE FLANGE HUB HIGH 01 ACH 2890210

Hope this helps.



--
Les


"Joel" wrote:

what exactlly do you mean by "Number of blank cells in column N". Do you
mean the number of spaces in the cell? wouldn't the number of blank cells in
column N always be a constant?

"Les" wrote:

Hi all, i have the following scenario that i need to automate,

1. 2 sheets in one workbook(Report.xls), "Summary" & "LC PARTS"
2. Sheet "Summary" Column "C" has either 4 numbers or a 3 letter code,
starting from row 20 down.
3. Sheet "LC PARTS" has the Code in column "H".
4. Sheet "LC PARTS" has the Number in column "B".
5. Sheet "LC PARTS" has a number in column "N".

What i want to do is loop down column "C" in sheet "summary" & find the
first code/number and then look for the same value in sheet "LC Parts" column
"H"(code) and column "B"(Number) if it has found a number and then count the
number of blank cells in colummn "N". This total must then be place in the
same row on sheet "Summary" in column "J". It must loop down to the last
code/number on the sheet "Summary" as more can be added over time.

Thank you very much in advance for any help.

Les