input form
 

When I use the input form with excel there are times when
I need to reenter some of the information i.e. when I
enter name address city and state ,the city and state
will be the same. I would like to return to the input
form and tab to what I need to replace then tab over what
is the same. When I use previous the data is replaced on
my spread sheet. Any one have any ideas, I appreciate the
help.

input form
 

G

If you're talking about Data - Form, then you cannot set default values or
repeat values, as far as I know. You might try this one

http://j-walk.com/ss/dataform/index.htm

and see if it does what you want.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"G" wrote in message
...
When I use the input form with excel there are times when
I need to reenter some of the information i.e. when I
enter name address city and state ,the city and state
will be the same. I would like to return to the input
form and tab to what I need to replace then tab over what
is the same. When I use previous the data is replaced on
my spread sheet. Any one have any ideas, I appreciate the
help.