Man of Action
New Member
- Joined
- Apr 11, 2002
- Messages
- 15
Well here is my problem. I want to copy a value from a worksheet and paste it into find on a different worksheet. I want to find the value on the second worksheet, copy the three cells next to it and change to the first worksheet and paste them into it.
Everything seems to work fine except when I past my value into the find. I want to be able to loop it but when I run it twice it finds the original value all the time instead of the new copied one?!?!?
If anyone can see what is wrong here please let me know it would be greatly appreciated.
Everything seems to work fine except when I past my value into the find. I want to be able to loop it but when I run it twice it finds the original value all the time instead of the new copied one?!?!?
If anyone can see what is wrong here please let me know it would be greatly appreciated.