Hi, can anyone assist me with the following.
I have 2 files:
\server1\data\cumulative.xls (file 1)

and

\reports\updates\report.xls (file 2)

The data in file 1 looks like this:
A5:X193 which will increase by extra rows when extra data is entered.
And row 5 is the header row.

I would like to automatically copy the data in columns C,D, E,K &,M o
worksheet "data" of \server1\data\cumulative.xls

INTO

B,C,D,E,F of worksheet "report" of \reports\updates\report.xls

The paste would start at row 484 of reports.xls each time as it woul
be a complete refresh of the current data.

Let me know if any of this doesnt make sense, and thanks for anyone
help !!
love, Amy x

--
AmyTaylo
-----------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...fo&userid=2097
View this thread: http://www.excelforum.com/showthread.php?threadid=38930