muellerlohse
04-19-2021, 02:47 PM
Hi all,
it's my fist thread, so my apologize in case something is not fully correct.
I am struggling withmy excel worksheet and hope that somebody can assist me to find a solution.
Basically I am workingin a file with consecutively repeating entry sections to make somecalculations.
As sometimes I will need to shift all sections down in order to enter data inbetween, I would like to create a makro that will copy only the cells with myentries (and the remaining fixed entries will be locked and not changed) and shiftall of them 13 rows down to paste them again in the same pattern as before.Just 13 rows more down. Maybe the attached screenshot will help to visualize.
For example leg 2 mustbe replaced with new input – so the data from leg 2,3,4,…. Must be shifted downto get the input field clear in leg 2. Therefore I want the valued from C17-C18,C30-C31, C43-44, E23, E25, E 36, E37, E49, E50, G15, G17…. Shifted down for 13rows. I didn’t find a suitable solution for me to do this with an offset whichwould be the best option as I will need the function finally for each of thelegs to be able to generate a gap wherever I will need it.
Hoping for yourassistance.
Dennis
it's my fist thread, so my apologize in case something is not fully correct.
I am struggling withmy excel worksheet and hope that somebody can assist me to find a solution.
Basically I am workingin a file with consecutively repeating entry sections to make somecalculations.
As sometimes I will need to shift all sections down in order to enter data inbetween, I would like to create a makro that will copy only the cells with myentries (and the remaining fixed entries will be locked and not changed) and shiftall of them 13 rows down to paste them again in the same pattern as before.Just 13 rows more down. Maybe the attached screenshot will help to visualize.
For example leg 2 mustbe replaced with new input – so the data from leg 2,3,4,…. Must be shifted downto get the input field clear in leg 2. Therefore I want the valued from C17-C18,C30-C31, C43-44, E23, E25, E 36, E37, E49, E50, G15, G17…. Shifted down for 13rows. I didn’t find a suitable solution for me to do this with an offset whichwould be the best option as I will need the function finally for each of thelegs to be able to generate a gap wherever I will need it.
Hoping for yourassistance.
Dennis