close

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

as long as the totals in the total column remained formula driven (look
at the function cell quot;fx=quot; 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(quot;sheet1quot;).activate
This activates the sheet
Range(quot;Estimatequot;).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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()