Find "Total" and move one cell to left and copy down information

[adgjqetuo]

I'm looking for someone to help me edit this code some. I need it to look in column "F" and find cells which say <####> and "Total" (IE a subtotal row). If it finds that, then offset one cell to the left and copy the cell that is directly above it.

Please Login or Register  to view this content.

Thanks!

[royUK]

The .Find method would be more efficient tha a loop.

Is <####> the actual text?

[adgjqetuo]

I wound up using a ByVal Target as Range code and it worked fine.

Thanks though!

[royUK]

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save