Don't think you can do what you want without code. Have you tried
Datafilterautofilter instead of moving?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"wccc.pctutor" wrote in message
...
Hi Mike H,

Well, I really didn't proofread my post.

The following line is part of the post above this line (Parsing, mid,
left, trim or right to find specific word in string), which I sent after
I came to my senses.

"I was hoping to get a hint or two on how to find a specific word, which
I'll
use to determine which worksheet to place the row in.
"

The exact transaction is the row which contains that specific word.

I can move a row or rows with using and I currently don't remember the
exact process, but highlighting the row, clicking that selection and
while holding pointer, hold down the Alt and move to each ws until you
find the right one and let go. I would like to do all of this with
code.

I know what I want to do, but I just don't know which is the best
route.

Any hints, ideas, but for the moment no coding. I would like to know
which, left, right, or mid, I should use to find a word in a string
(downloaded bank transaction). I can tell you that each month's online
bank statement will be almost an exact clone. I need to locate that
specific word first.

Thanks in advance.

Later,

wccc.pctutor

Mike H:
Hi,

What's an 'Exact transaction'?

Mike

"wccc.pctutor" 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