Hi,
I have 2 addresses on the same line such as
ADDRESS_1 ADDRESS_2
------------ ------------------
Street_1 Street_2
City_1, State_1 City_2, State_2
When I press the tab key from street_1 I want it to go to city_1, state_1 then street_2, city_2, state_2. Is there a way to control it using either vba or excel functions???
Thank you very much in advance
I have 2 addresses on the same line such as
ADDRESS_1 ADDRESS_2
------------ ------------------
Street_1 Street_2
City_1, State_1 City_2, State_2
When I press the tab key from street_1 I want it to go to city_1, state_1 then street_2, city_2, state_2. Is there a way to control it using either vba or excel functions???
Thank you very much in advance