divingdingo
11-20-2007, 09:58 AM
hi guys, i'm back again!!
my problem this time is that occasionally my large arrays of wind data arrives with some dates missing corresponding data. i would like to identify these dates in a table on a seperate sheet, and i think i need to use Vlookup although i'm not positive about how i should!
my data comes in two columns;
date, windspeed.
occassionaly wind speed = 0 (this means there has been no recording taken)
i would like VBA to search through my windspeed column until it finds a 0, then copy the date on a serperate sheet("missing_dates") after that continue on to the next occasion when 0 is encountered and copy the date underneath the last entry.
thanks for any help received.
mark
my problem this time is that occasionally my large arrays of wind data arrives with some dates missing corresponding data. i would like to identify these dates in a table on a seperate sheet, and i think i need to use Vlookup although i'm not positive about how i should!
my data comes in two columns;
date, windspeed.
occassionaly wind speed = 0 (this means there has been no recording taken)
i would like VBA to search through my windspeed column until it finds a 0, then copy the date on a serperate sheet("missing_dates") after that continue on to the next occasion when 0 is encountered and copy the date underneath the last entry.
thanks for any help received.
mark