| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| can vlookup search multiple data tables | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
