You really need to provide considerably more detail. The most basic
syntax would be something like

Worksheets("Sheet1").Range("C1").EntireRow _
Destination:=Worksheets("Sheet2").Range("C1")

But I think you have more in mind than just this.


Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
The San Diego Project Group, LLC
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)


On tue, 23 sep 2008 15:17:10 -0400, "wccc.pctutor" <nospam@invalid
wrote:

I was hoping to find a way, using Vba for Excel, to move exact
transactions to a specific worksheet. Is there a way?

Thanks in advance.

Later,

Bob