I am relatively new to VBA programming but not VB. For my current
project I need to copy a cell to an array and paste it into a
spreadsheet only if a certain criteria is met, such as the number 3 in
column 9. Which corresponds to a drop down box. I would then need to
paste that cell into the first
pre-determined non occupied cell on a different worksheet. I would
like to do this using an array since it makes the most sense. I am
thinking one array for the copied cells and a second array that has
cell references on the second sheet. My hang up is the first array.
How do I only copy certains cells into an array if a certain criteria
must be met.

Thanks in advance,
John