Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding a formula
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). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My formula cell has stopped adding the preceding cells. | Excel Worksheet Functions | |||
Excel formula to calculate % gain when adding cash equity to accou | Excel Worksheet Functions | |||
Adding something to a complicated formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions |