Hello,
I'm trying to do something simple but I am not managing to. Please help if you can.
The following code tries to the copy 3 cells (template1!M3:O3) to a the next available row in a second sheet (ref!). The rows where the 3 cells should be pasted vary depending on the content of cell template1!O3 (As an example there are 5 options of text in cell O3: AA, BB, CC, DD, EE, DD).
For some reason my code keeps pasting the 3 copied cells in row "W", diregarding the IF stetements or the content of cell O3.
Does anyone see what's wrong? Code below:
Thanks!
Goeff.
Bookmarks