Any Way to Automate Creation of Multiple Tables with Stock Data
 

I have a list of stock data (for about 7 years) where Col. A is the Date,
Col. B is the closing cost and Col. C and D are the price listed again only
on days when grants were given. I need to create seperate printable "tables"
where the days grants were given (col C or D) are proceeded and followed by
30 days of row data. There are about 40 instances of days when grants were
given so I guess I need to make 40 tables.

This data will then be used to make 40 charts that show the cost of stock
the day of the grant and 30 days before and after the grant.

I have limited macro/vb skills so any help would be greatly appreciated.
Thanks!

Any Way to Automate Creation of Multiple Tables with Stock Data
 

I have provided an example sheet @ http://HelpExcel.com/examples

It is called grants.xls
--
http://HelpExcel.com




"DQuint" wrote:

I have a list of stock data (for about 7 years) where Col. A is the Date,
Col. B is the closing cost and Col. C and D are the price listed again only
on days when grants were given. I need to create seperate printable "tables"
where the days grants were given (col C or D) are proceeded and followed by
30 days of row data. There are about 40 instances of days when grants were
given so I guess I need to make 40 tables.

This data will then be used to make 40 charts that show the cost of stock
the day of the grant and 30 days before and after the grant.

I have limited macro/vb skills so any help would be greatly appreciated.
Thanks!