I have a macro set up that imports a query from access and adds page breaks
where I need them. (at the end of each group) I do not want them on seperate
spreadsheets. Is there a way to set up a macro that when I run it, it will
insert a blank line at the end of each group and then put a formula to add.
My problem is: the next time I import I may have more rows of information in
one group and maybe less in another. The macro I created will add a blank
row and formula to the same place each time (and this maybe in the middle of
that group). Is it possible to tell excel to find the page break and add a
blank row above it and then put a sum formula in the correct column (the
column is D and E.) (I wanted the formula in column D and E at the end of
each page).