J
Jimbola
Hi there,
I want to create a change event macro that when a change
is made to the first 2 cells in a row, a formula is copied
from the very first row into the next 5 cells of the row
where the change was made.
Hope the layout below makes sense, f1 - f5 represent
formulas.
a b c d e f g
1 Name Rate f1 f2 f3 f4 f5
..
..
..
30 john 12.50 (copy formulas f1 - f5 down here on
change)
Any help would be grately appreciated.
Regards
J
I want to create a change event macro that when a change
is made to the first 2 cells in a row, a formula is copied
from the very first row into the next 5 cells of the row
where the change was made.
Hope the layout below makes sense, f1 - f5 represent
formulas.
a b c d e f g
1 Name Rate f1 f2 f3 f4 f5
..
..
..
30 john 12.50 (copy formulas f1 - f5 down here on
change)
Any help would be grately appreciated.
Regards
J