I have a range F5:H79.
At present I copy this range and paste it at cell I5
and subsequently L5 etc.
What I would like to do is automate this ie copy $F$5:$H$79 and then paste where my cell is highlighted.I5,L5,O5 etc
Ideally I would like to paste without having to select the cell (ie everytime i press the button it pastes to the next available cell5 if you see what i mean?)
I tried to record a Macro by just Copying and Pasting to the same cells but made a right mess of it!!
Appriciate some help.
Bookmarks