Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Method to increment value in data field?
It would be helpful while tabulating survey data, to be able to increment a
field value by one-- with the stroke of a "hot key" rather than having to erase the current value and raise it by one. Does such a method exist? |
#2
|
|||
|
|||
Karl
You have to use VB Copy this macro into a module. Press Alt + F11,Insert, Module and then paste the code Sub Incr() Dim c For Each c In Selection c.Value = c + 1 Next End Sub Press Alt+F8 select the macro and choose OPtions and you can assign a short cut key to run the macro Regards Peter "Karl H" wrote: It would be helpful while tabulating survey data, to be able to increment a field value by one-- with the stroke of a "hot key" rather than having to erase the current value and raise it by one. Does such a method exist? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Formulas in source data | Charts and Charting in Excel | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |