Hey,

I may need to revise the quote which would mean some of the information
would then be required so i'd rather leave it on the same sheet

"oli merge" wrote:

Hi,

Have you tried sending the data you dont want to another sheet instead of
the bottom of the same sheet?

"Jim" wrote:

Hi all,

I'm after a bit of help:

I have a worksheet which is a quotation with the prices, inclusions etc
coming from different sheets in the workbook. I have a sort macro which
sends all the unwanted bits down to the bottom of the sheet.
I want to be able to copy from cell A1 down to the end of the useful list
which is marked by the word "end" but after sorting could be on any row.

I then want to open a word template and paste the data.

Any help would be appreciated.