Data extraction

[shytott]

Hi
In col A, starting at A100 to A475, I have every day in a calendar year. Each row contains numeric data (in cols B,D and E) which I want to extract on a monthly basis between a set of From and To dates (which are located in B2 and B3 respectively). The extracted data is to end up in a ‘reporting area’ which can be printed. Those days with zero values are to be skipped.

I can sort of get halfway with nested If statements but Im still falling short of where I need to be. Is there a way with VBA?

Cheers

 

[PHV]

What have you tried so far ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

Hi,

Have you thought about using one of Excel's many data analysis features.

First figgure out how to do it on the sheet, then macro record it.

Skip,

_[red][/red]