• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 900
  • Last Modified:

Sum in Excel Footer for current page Column Values

I have 50000 rows of data and col D, E, F contains some numeric values what I want is to print the page and show current page D, E, F total in the page footer and continue.. please help.
0
suvmitra
Asked:
suvmitra
2 Solutions
 
Kalpesh ChhatralaSoftware ConsultantCommented:
0
 
xtermieCommented:
Dont really know if you can actually do that, or find a workaround for it...quite challenging though!
Think someone has answered this here:
http://www.accountingweb.co.uk/item/100157
They state:
I would suggest you try to amend the vba code below to produce the relevant figures. Just watch out for the cell and range of references. Best of luck!

Sub headerfromcell()
With ActiveSheet.PageSetup
.LeftHeader = Range("prn").Value
End With
End Sub
====
Sub cellfromheader()
x = ActiveWorkbook.Worksheets.Count
For i = 1 To x Step 1
Sheets(i).Range("C20").Value = Sheets("Sheet1").PageSetup.LeftHeader
Next
End Sub
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now