HI I will continue with a new thread. The other or old is half done. So this subject line is more relevant. I need this last code to make all work
In sheet1 cell G7. I have a value.
I need to find that exact value(text) in Sheet "SavedRefunds" In column B.
If important you add to only search in cells with color index .
When i have found the exact value(text) I need this cell and the next 18 cells after that
to be copied to Sheet "Refund" Range A1:A19
Please have a look at the modified testsheet.
thanks
Abjac
Bookmarks