Gingertrees
08-31-2010, 05:50 PM
On Sheet1, users can enter client names (column A) and what date the client last came in to sign paperwork (column B).
The "paperwork" is on other sheets in the workbook (let's use just Sheet2 for the example).
Excel then places in column C, what date the client must next sign paperwork on (column B + 182). Columns A and B are unlocked, column C is locked (to do the calculation).
I would like the user to have the option to update the Sheet1, column B (and thereby, column C) dates whenever they print out the paperwork on Sheet2. Since this is already a complex processor-intensive workbook and we have slow computers, I'd like to do this in a command button as opposed to a Workbook_Change.
It seems like this could be done with a Replace function, but I know not the syntax. Help?
The "paperwork" is on other sheets in the workbook (let's use just Sheet2 for the example).
Excel then places in column C, what date the client must next sign paperwork on (column B + 182). Columns A and B are unlocked, column C is locked (to do the calculation).
I would like the user to have the option to update the Sheet1, column B (and thereby, column C) dates whenever they print out the paperwork on Sheet2. Since this is already a complex processor-intensive workbook and we have slow computers, I'd like to do this in a command button as opposed to a Workbook_Change.
It seems like this could be done with a Replace function, but I know not the syntax. Help?