I have a column of dates (column d). New dates are added and deleted regularly.
I need to be able to increment all the dates in the column by a specific number of days, forward or backward, using a macro.
The macro needs to pop open a dialog window to prompt me for the number of days I wish to increment the dates in the column, and also whether to index forward or backward depending on which radio button is selected (forward or backward). Default would be forward.
How can I do this?
Any help would be greatly appreciated!
I need to be able to increment all the dates in the column by a specific number of days, forward or backward, using a macro.
The macro needs to pop open a dialog window to prompt me for the number of days I wish to increment the dates in the column, and also whether to index forward or backward depending on which radio button is selected (forward or backward). Default would be forward.
How can I do this?
Any help would be greatly appreciated!