Sum in Excel Footer for current page Column Values

Posted on 2011-05-10
Last Modified: 2012-05-11
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.
Question by:suvmitra
    LVL 16

    Assisted Solution

    by:Kalpesh Chhatrala
    LVL 16

    Accepted Solution

    Dont really know if you can actually do that, or find a workaround for it...quite challenging though!
    Think someone has answered this here:
    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
    End Sub

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
    In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
    This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now