i'm new to this computing stuff i wonder if someone can help,
i have an excel sheet about 1000rows in use at present.
i am trying to make a copy paste macro. to expain further- i want to copy c1 through to g1 and paste those cells to m1 throught to r1, then the next time i want to move down 7 rows and copy that range across .
i recorded a macro to do this but when i move down to for example c8 and run the macro it copies and pastes the original c1-g1 ito m1-r1.
i have had a go at reading the help but and trying a few things to no avail.
it,s just normal numbers i want to copy and paste not formula or anything complicated.
Bookmarks