Hi -

My VBA knowledge is very limited. I pretty much depend on
the macro recorder to do my dirty work and I know that
it's very inefficient. Here's what I want to do -

I have a template sheet that gets filled in with data,
both numbers and text. I want to copy certain bits of this
data and paste it into a different workbook which I use as
a summary.

The data I want to copy/paste is scattered throughout the
template and is for the most part in non-contigious blocks.
I can handle the copy operation but the problem comes when
I need to define the destination. I want the data to be
pasted in the next MT row of the summary sheet in a
different workbook. If it wasn't for the last row bit I
could just use a formula cell to cell link like =Template!
A10.

Say for example I want to copy from the template sheet
cells - A10,A11,E22,F22,G22,H22,K60,L60,M60 and have that
pasted into the summary workbook on the next MT row, which
might be row 12, in the range A12:I12.

I also would like a msg box that pops up and confirms that
the copy/paste was successful.

I can handle creating a button and assigning the macro to
it.

Any help will be greatly appreciated.

Patch