• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

formula in footer (VBA help)

C

celticwomen

New Member
Hello

I am trying to set up 2 different formulas in my footer of the work sheet. First formula is a sum total and the second in a average. any help would be appreciated. I have attached a file, I also want this formula to carry across to my multiple pages if possible.

As you can see in the work sheet that the formulas are at the bottom, but I do need to move them into the footer as I have to change the spacing and other items.

Thank you for your help
 

Attachments

Good day and welcome to the forum.

If you set up your data as a table then your totals at the bottom would always stay there no matter how you resized.

Also you are using the dreaded merge, can and will cause problems!!!
.
 
Hi ,

Can you define at least one print area , and then upload your workbook again ?

Secondly , how can we recognize the data range in each sheet tab ? Do we look at column J to have the last row with data , or will it be some other column ?

Narayan
 
Sorry for the late response, I volunteer at a cancer office and I'm not at the office all the time.

I am trying to set up and organize a set of files and having the formula in the footer is the best option. This will be in a large work sheet and I would like to make sure it caries to the next sheet.

I'm looking at a sum total and average for column J

I have attached another file

Thank you for your help
 

Attachments

I have had to remove some data from your header cells as you have used merged cells, a big no no.

Just create a table and you will have auto update as you enter data, see the upload.
 

Attachments

Avoid merging cells


Merged cells can help you arrange values in a meaningful way, but they come with problems -- numerous problems, big problems.


For instance, Excel won't apply column formats to a merged cell unless you select all the columns that comprise the merge.


In addition, not all cell formats, stick once you emerge a cell.


You can't sort a column with merged cells.


You can't even select a single-column range if there's a merged cell in it -- go ahead, try!, the whole column will become merged, not good.


You cannot put a filter on it. The problem is the filter is completely useless because the filter will groan with the "merged cells need to be identically sized." Warning, which in English means you have to make each group of merged cells the same size as the largest group. And you have to find them all!


Merging cells in columns and rows could lead to data loss, bad thing.


Formulas and Functions that refer to merged cells will not work, bad thing.


Don't hesitate to use merged cells if you really need them (you don’t), but they will limit what you can do to the cells and even the columns involved.


Center Across Selection is a far better alternative to merging.


To apply this format, select the cells you want to appear merged and then launch the Alignment group dialog, Ctrl + 1, and click the Alignment tab. Center Across Selection is in the Horizontal drop-down.


You will get the desired look you want but without the merged cell's problems.
 
Hello

Thank you for the help. What I was trying to do was to put the formulas in a footer not just at the bottom of the page. Can you help with that?
 
A footer is the bottom of a page (hence the name), why would any one put a formula in the footer? A footer holds page number and other document information.You have been given help and ideas but your comment on them is zero so we don't really know what you mean by footer/bottom (most if not all would assume they both mean the same).
 
Yes a footer is on the bottom of the page and when you have information it will be below the margins to allow more information on the page. I have seen other people say that it is possible to put a formula in a footer by using a VBA. I was hopping to get someone to help me with a VBA for the 2 formals that I require for my page. Does that make sense?
 
Did you look at the table I upload it show as you enter new data the formula results are moved down automaticly?
 
You must log in or register to reply here.
Back
Top