Copy & Paste Macro

[Thomp]

Anyone,
I need to be able to copy all cells below a certain row that only have
values in them and then have them paste to the first empty row of
another worksheet

The only catch to this is that when it paste the data it needs to be a
value only paste and not the formulas that are presently in the cells

thanks in advance for any help on this

Bill

 

[Don Guillett]

See ans in your later post

 

[Thomp]

See ans in your later post

--
Don Guillett
Microsoft MVP Excel
SalesAid Software








- Show quoted text -

Don, This request was a little different in that I needed to copy
those cells that are both non-blank(data in them) and don't need the
first six rows copied as they have data in them but I don't want them
copied. I couldn't get your earlier code to work. I think I still
need help on this one.
thanks,
Bill

 

[Don Guillett]

I don't understand. If desired, send your workbook to my address below with
complete instructions.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

See ans in your later post

--
Don Guillett
Microsoft MVP Excel
SalesAid Software








- Show quoted text -

Don, This request was a little different in that I needed to copy
those cells that are both non-blank(data in them) and don't need the
first six rows copied as they have data in them but I don't want them
copied. I couldn't get your earlier code to work. I think I still
need help on this one.
thanks,
Bill