Mrtnjcksn
12-04-2013, 10:56 AM
Evening all
i've been a lurker here for a while and up til now have always found the answers to my fumbling questions in this forum or the mrexcel one.
Ive hit a stumbling block and am in need of a guide, I normally scratch by with macros recorded and lightly edited in VBA but am tapped out and need a bit of a hand.
I have a sheet with columns "A" to "GP" inclusive, colleagues fill this in and on occasion need to add pretty much the same data a second time in the next row down.
So to take this into account, I need a macro or bit of VBA wizardry to copy the range "A" to "AM" and "GB" to "GP" into the row below the one that has just filled in at the click of a button...
i have managed to get this to work with copying a complete row but need it to just cut and paste the two ranges.
I'm hoping that someone might be able to assist. : pray2:
Cheers in advance
i've been a lurker here for a while and up til now have always found the answers to my fumbling questions in this forum or the mrexcel one.
Ive hit a stumbling block and am in need of a guide, I normally scratch by with macros recorded and lightly edited in VBA but am tapped out and need a bit of a hand.
I have a sheet with columns "A" to "GP" inclusive, colleagues fill this in and on occasion need to add pretty much the same data a second time in the next row down.
So to take this into account, I need a macro or bit of VBA wizardry to copy the range "A" to "AM" and "GB" to "GP" into the row below the one that has just filled in at the click of a button...
i have managed to get this to work with copying a complete row but need it to just cut and paste the two ranges.
I'm hoping that someone might be able to assist. : pray2:
Cheers in advance