LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joy
 
Posts: n/a
Default How to create a constant total column in Excel?

as long as the totals in the total column remained formula driven (look
at the function cell "fx=" in your toolbar to see that it reads
=SUM(....:....) and not the same number as the cell you're in), you can
select the entire sheet (upper left square next to A and above 1) and
hit F9. This should re-calculate the entire worksheet.
You can also write a macro that clears all the cells into which you
enter numbers, and put it on a userform that pops up when you open the
workbook. You'd have one button to clear previous entries and another
to continue the current job. The way you'd do that is to select the
range of cells into which you enter data (for example G5:H60) and then
go to your toolbar, insert, name, define, and give it a name like
Estimate. Then the macro attached to the button to clear those cells
would read

Sub (whatever you name this button) ()
Sheets("sheet1").activate
This activates the sheet
Range("Estimate").clearcontents This
selects the range that you previously named and deletes all existing
data
Unload me
This unloads the user form and lets you into the workbook
End sub

And the macro attached to the button to continue with the previous
estimate would read simply:

Sub (yet another name for this button) ()
Unload me
End sub

If all your worksheets have cells that are linked one to the other, the
totals should refresh each time you hit save or re-open the workbook.
Or use that F9 key.

Joy

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
Pivot table for reporting sales performance Ram Excel Discussion (Misc queries) 2 February 6th 06 10:06 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
In excel - how to total column if am not sure of the last cell PFHMoney New Users to Excel 4 May 27th 05 01:27 PM
How do I reference every "n" cell in a column in Excel? Alma Excel Worksheet Functions 2 March 22nd 05 06:19 PM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"