Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Who can do a date search and subsequent graphing?!

Status
Not open for further replies.

BFG2

Technical User
Feb 4, 2003
23
GB
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
 
Cancel that - think I've sorted it.

Thanks to anyone that took the time to read my post though
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top