hi,
do you wish this pasted in all workbook in the directory?
on which sheet?
since these workbooks are copies i assume that you want it pasted in the
same place. correct?

Regards
FSt1

"davez" wrote:


Hi all, I have a good search around but have been unable to find what I
am after, that being -

I wish to copy a range - V1 to BK30 - from a single worksheet in what
is my master workbook -"new_rtgs"- to any number of other workbooks
which are copies made daily of the master workbook & which contain up
to 30 worksheets.

Basicaly this range contains formulas which analyse data I import to
Colums A thru U. All the workbooks I need to copy to are housed in the
same directory & are named by date - eg aug_01, aug_02 etc.

Thanks in advance for any help provided.


--
davez
------------------------------------------------------------------------
davez's Profile: http://www.excelforum.com/member.php...o&userid=16685
View this thread: http://www.excelforum.com/showthread...hreadid=399344