Macro to create a chart from a dynamic range. Help!

[eddy]

I have a sheet (MainSheet) with rows of data.
The columns I am intersested in
are C (Which contains the date in the format 28/08/2002)
F (Which contains four options say either RED,GREEN,BLUE or YELLOW)
G (Which contains the number of items sold on that day)


I have another sheet (Stats). Within this sheet I would like to have a macro
which would select data from A6 down to the last row entry in G
Then be able to select data between two dates( C column) e.g 01/08/2002 - 01/09/2002
Then shown a graph containing numbers (G Col) of RED,GREEN, BLUE and YELLOW (F Col)
sold during the defined period.

I dont want to use Pivot Tables. Just enter a search from date and a serch to date

Any ideas appreciated.

eD
This message was edited by eddy on 2002-10-03 13:07

 

[Andrew Poulsom]

There are rather a lot of questions here.

I suggest you start by turning on the macro recorder, selecting your range and plotting the chart. That should get you started with the syntax.

You could use Dropdowns on a UserForm for your date selection. Set the RowSource to the dates on your worksheet.

Search this Board for "last cell" for help in finding the last used cell in a column.

 

[eddy]

Thanks Andrew but it's not that simple. I need quite a lot of code which is not recordable!
The search and data colation between the "inputtable" dates is the difficult bit.
eD