Hi all
What I'm trying to achieve is to loop through a list of cells, taking the value, for example "A", finding "A" in a separate list, offsetting to the right by 1, and using that cells value, again for example "test" to replace the original cell value from "A" to "test".
This is the code I'm currently using:
It's adapted from something I found online but it isn't replacing the active cell.Please Login or Register to view this content.
Any help is great
Thanks
Bookmarks