Copy & Paste Macro

  • Thread starter Thread starter Thomp
  • Start date Start date
T

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
 
See ans in your later post

--
Don Guillett
Microsoft MVP Excel
SalesAid Software








- Show quoted text -
Click to expand...

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
 
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 -
Click to expand...

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
 
Back
Top