| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Macro to copy latest data from one Workbook to another
Guys, Heres the intro... What Im THINKING of doing is creating a workbook that will only hav graphs so those people in the management who dont feel comfortable wit figures can grasp the basic info just by looking at the graphs... What I donot want to do is update the graph workbook everyday as i takes its data from quite a few other workbooks. What Im thinking of i that I would have a macro that would copy the latest date's figures fro each sheet in the workbooks and paste them in the graph workbook. So any ideas how should I go about doing this... I cant think of an command that would let me do this, looping would start from first dat (in the data files) but that would ruin my spreadsheet as my grap report doesnt take into account all the last couple of years dates... Please advise. cheer -- Kayot ----------------------------------------------------------------------- Kayote's Profile: http://www.excelforum.com/member.php...fo&userid=3331 View this thread: http://www.excelforum.com/showthread.php?threadid=55156 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy most recent data from one workbook to another with a Macro | Excel Discussion (Misc queries) | |||
| Create a macro to copy data from one workbook to another | Excel Discussion (Misc queries) | |||
| $%Macro to Copy from one workbook to other when matching data | Excel Discussion (Misc queries) | |||
| Macro Help. Copy data from 1 workbook to another on next available | Excel Discussion (Misc queries) | |||
| Macro to copy data into another workbook | Excel Discussion (Misc queries) | |||
![Kayote[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
