I have a list of worksheets within my Excel file, they are on "sheet 1"
within the range: A1 to A300.

What I want to do, for each worksheet tab in the range, is copy cells:
A1999 to x2687 from a sheet called "report" into range: A1999 to
x2687.
The thing is that the file grinds to a halt if I do it manually, is it
possible to set it so that it runs for each sheet and is copied over as
values before going onto the next sheet ?

Any way you can think to make it less resource intensive would be great
!
Thanks
Amy xxx


--
AmyTaylor
------------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
View this thread: http://www.excelforum.com/showthread...hreadid=535476