-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
help please
- Thread starter juanf619
- Start date
Re: help pleasr
no comprendo.
Formulas do not take actions like clearing and saving values elsewhere. Formulas can make a cell appear as if it is blank (example: =A1="") but that doesn't actually clear (make the cell without contents--it still has a formula). Formulas can also read the value of other cells, making it appear the value is being kept somewhere else, but in reality it is only resident in a single cell.
Visual Basic (VBA) as found in Excel can do that but you will need considerably more detailed specifications before you can start to do that.
no comprendo.
Formulas do not take actions like clearing and saving values elsewhere. Formulas can make a cell appear as if it is blank (example: =A1="") but that doesn't actually clear (make the cell without contents--it still has a formula). Formulas can also read the value of other cells, making it appear the value is being kept somewhere else, but in reality it is only resident in a single cell.
Visual Basic (VBA) as found in Excel can do that but you will need considerably more detailed specifications before you can start to do that.
Last edited:
Upvote
0
Smitty
Legend
- Joined
- May 15, 2003
- Messages
- 29,536
Re: help pleasr
Welcome to the Board!
You can start by recording a macro saving the workbook, then clearing out any cells you want emptied.
As for auto-incrementing the invoice #, you can use something like this:
Range("A1").Value = Range("A1").Value + 1
You can then add that to your other code.
Hope that helps,
Welcome to the Board!
You can start by recording a macro saving the workbook, then clearing out any cells you want emptied.
As for auto-incrementing the invoice #, you can use something like this:
Range("A1").Value = Range("A1").Value + 1
You can then add that to your other code.
Hope that helps,
Upvote
0
