Hi everyone,
Having a bit of a nightmare - any help would be much appreciated. I'm still learning VBA, and have hit a bit of a brick wall
I've got 2 columns of data in column A and G for example. (Columns B-F are filled with other data)
Column A is full of sequential dates & times and G is full of corresponding data.
I need to be able to search the date column for date/times that are between start and end dates (specified in VBA), select them and the corresponding data in the same rows in column G, and then plot them on a chart.
I'm sure this is easy for someone who knows what they're doing, but I'm running into problems all over the place.
Thanks for any help. Answers on a postcard....
BFG
Having a bit of a nightmare - any help would be much appreciated. I'm still learning VBA, and have hit a bit of a brick wall
I've got 2 columns of data in column A and G for example. (Columns B-F are filled with other data)
Column A is full of sequential dates & times and G is full of corresponding data.
I need to be able to search the date column for date/times that are between start and end dates (specified in VBA), select them and the corresponding data in the same rows in column G, and then plot them on a chart.
I'm sure this is easy for someone who knows what they're doing, but I'm running into problems all over the place.
Thanks for any help. Answers on a postcard....
BFG