G
Guest
I have formulas in Q5 TO AB20 with a sum formula running from Q21 TO AB21,
someone inserts a new row at the end of the selection of data so the data
range is Q5 TO AB21, however the sum formula doesn't include the new row. I
wanted a macro to select the data from Q5 TO AB21 and auto fill with the
formulas. Next day someone adds another row and the data range is now Q5 TO
AB22. And so on.
Any ideas?
Cheers
Simon
someone inserts a new row at the end of the selection of data so the data
range is Q5 TO AB21, however the sum formula doesn't include the new row. I
wanted a macro to select the data from Q5 TO AB21 and auto fill with the
formulas. Next day someone adds another row and the data range is now Q5 TO
AB22. And so on.
Any ideas?
Cheers
Simon