| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
Automatic update multiple files
Thank you! I'll try those trix as well as reposting in the programming thread.
Cheers~ Bill Manville wrote: You can possibly arrange for the charts to show the last 12 (or whatever) data points in the source, saving on the need to do the update at all; just entering the new month's data would result in the charts moving on a month. See, for example, funchrt1.zip on http://www.oaltd.co.uk/Excel/Default.htm --- Alternatively, record a macro while making the changes manually and then consider how you could generalise it so it will work correctly next month. If you need help with the generalising, post the relevant part of the macro in your message - the Excel.Programming group is probably the best one to choose. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...links/200807/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
| Update multiple files | Excel Discussion (Misc queries) | |||
| Automatic Update | Charts and Charting in Excel | |||
| Automatic update | Excel Discussion (Misc queries) | |||
| 2 files, mass update comments between files | Excel Worksheet Functions | |||
Threaded Mode
