Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Cut and Paste macro based on criteria then delete empty rows



Hi All,
First time poster and VBA bewbie. Any help would be great!!
I'm using ecxel 2000
Here's my problem:

I have a worksheet (Sheet1) from which I need to cut paste any row (in
the Range A3:AD300) where column "O" has a certain value in it into
Sheet2. I'd like the pasting to begin in the first blank row of
Sheet2. Then I'd like the blank rows of Sheet1 to be deleted. Is this
possible?


Many thanks



<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.