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