Is there any way to build a template sheet and any csv data importted into
the worksheet is then merged into that template? Just fishing!


"Dave Peterson" wrote:

That's not what I meant. You just got suggestions to have a grand total line at
the bottom of all your data.

There's nothing built into excel that does what you want (subtotals per page).



Scott wrote:

Dave,

I guess what I'm not understanding is how to display the Totals for each
page. Ultimately, what I would like to do is display the autosum at the
bottom of each page for each column. (i.e. =SUM(A2:A54)) and A:55 being the
page totals. This continuing on for the continual pages =SUM(A56:A107) and
A:108 being the next page totals.

Maybe the VB code you referenced will handle this, I'm just not well versed
with VB code and applying it to an existing spreadsheet.

Scott

"Dave Peterson" wrote:

You could find the next available row (I used column A):

dim NextRow as long
with activesheet
nextrow = .cells(.rows.count,"A").end(xlup).row + 1

.cells(nextrow,"B").resize(1,5).formulaR1C1 _
= "=sum(r1c:r[-1]c)"
end with

Another option would be to insert a new row 1 and use that to hold your
formulas.

Then you wouldn't have to care where the data stops.

You could use a formula like:
=sum(B2:B65536)



Scott wrote:

I have some csv data the I pull into Excel to format and etc. The data rows
are always different (from month to month). One time I will have 400 rows,
the next time I might have 58. Is there a way to force Excel to Autosum
defined columns on each page without having to Insert a row at the bottom of
each page?

--

Dave Peterson


--

Dave Peterson