Hi David,
I think they are systematic, to the extent that the range copied on each
sheet is the same, and the range copied to is always the same row, just a
different data (column). The source workbooks are weekly files, where I am
copying the total values off each worksheet and pasting them to a
consolidated worksheet where each of the 30 pages is the totals for the same
30 pages in the source workbook, except the workbook I'm pasting into has a
date column that must be matched to the date in the source workbook. Does
that help?

"davidm" wrote:


David,

Since both your data source (copy) ranges and destination (paste)
ranges are not systematic ie do not conform to a discernible pattern,
you cannot apply looping to any effect. I would suggest that you
restructure your data such that the source data maps into the
destination ranges in a certain kind of fashion (but this may not
always be possible).


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=495973