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