J
JBoyer
I know what I marco is, but I am not at all familiar with using them. Here is
my dilemma. I have a worksheet that needs to be updated by adding new cells
above a row of totals and below the last set of formulas. Use this for an
example. Lets say a1=f1*8, a2=f2*8, a3=f3*8, a4=f4*8; and b1=g1*8, b2=g2*8,
b3=g3*8, b4=g4*8. Underneath them in a5 and b5 would be a sum function for
example. What a want to do is insert two rows above a5 and b5, so the sum
function will now be in a7 and b7. Then copy cells a1:b2 and paste them in
a5:b6. If i would use the marco again it would insert two more rows and copy
cells a1:b2 and paste them in a7:b8 and have the sum function be pushed down
to a9 and b9. Not sure if this is even possible, or if a marco will work for
it, but any help is appreciated!
my dilemma. I have a worksheet that needs to be updated by adding new cells
above a row of totals and below the last set of formulas. Use this for an
example. Lets say a1=f1*8, a2=f2*8, a3=f3*8, a4=f4*8; and b1=g1*8, b2=g2*8,
b3=g3*8, b4=g4*8. Underneath them in a5 and b5 would be a sum function for
example. What a want to do is insert two rows above a5 and b5, so the sum
function will now be in a7 and b7. Then copy cells a1:b2 and paste them in
a5:b6. If i would use the marco again it would insert two more rows and copy
cells a1:b2 and paste them in a7:b8 and have the sum function be pushed down
to a9 and b9. Not sure if this is even possible, or if a marco will work for
it, but any help is appreciated!