Hello


I'm trying to write code that will find a cell based on fixed values (can be coded in the macro) and then copy the values of that cell and the 3 cells below to another column say C. In the end it will need to loop and consequently extract multiple sets of cells to copy to the new columns


I can find and copy the first cell but i'm not able to copy the 4 cells together using offset.
Main question then is how do I find and copy a range of 4 cells?

Unfortunately i don't have the code here with me, so i can paste what i got/tried sofar. Will do that tomorrow or later this day. But hopefully someone can hint me in right direction.


Thanks Very Much

Science Boy