Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a constant total column in Excel?
I am at a cabinet building company and we are needing to incorporate an
on-going column of accumulative totals, and they stay constant even when other formulas that change the totals are changed or the other values pointing to the totals are changed. I guess you could call it a column of constant totals. This is so that we can always see the accumulative total of cabinet parts and we use other worksheets to change the totals to what they are and we'll have other output sheets showing cabinet parts needed for a set of cabinets. And when 1 job is done, we want to delete those entries and start another job, but the totals stay constant from the last job session. Help, Jim |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
In excel - how to total column if am not sure of the last cell | New Users to Excel | |||
How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions |