Fahsid1230
Active Member
- Joined
- Dec 26, 2006
- Messages
- 282
Good Morning Folks,
here I have 41 tabs in excel. And at the begining I have tab (beside 41 tabs) in which I able to create a dropdown box for the following locations.
Here is the list:
Southern Division
Alexandria
Monroe
Slidell
New Orleans
Shreveport/Minden
McComb/Natchez
Meridian
Birmingham
Tullahoma
Columbia
Northern Division
Springfield
Branson
Monett
Mtn Grove
West Plains
Columbia
Jefferson City
Joplin
Pittsburg
Galesburg
Peoria
Bluefield
IOWA
Cedar Rapids
Arizona Division
Casa Grande
Payson
Sedona
White Mountain
Regency Division
Baytown
League City
Houston
Start-Ups
Flagstaff
Baton Rouge
Yuma
Quad Cities
Osage Beach
Now what I'm trying to work on is when I select the location from the drop down box, two thing should happen simultaneously:
1) Delete the rest of the locations
2) Automatically copy paste special value for the selected location.
Any take on this will be highly appreciated.
thx
here I have 41 tabs in excel. And at the begining I have tab (beside 41 tabs) in which I able to create a dropdown box for the following locations.
Here is the list:
Southern Division
Alexandria
Monroe
Slidell
New Orleans
Shreveport/Minden
McComb/Natchez
Meridian
Birmingham
Tullahoma
Columbia
Northern Division
Springfield
Branson
Monett
Mtn Grove
West Plains
Columbia
Jefferson City
Joplin
Pittsburg
Galesburg
Peoria
Bluefield
IOWA
Cedar Rapids
Arizona Division
Casa Grande
Payson
Sedona
White Mountain
Regency Division
Baytown
League City
Houston
Start-Ups
Flagstaff
Baton Rouge
Yuma
Quad Cities
Osage Beach
Now what I'm trying to work on is when I select the location from the drop down box, two thing should happen simultaneously:
1) Delete the rest of the locations
2) Automatically copy paste special value for the selected location.
Any take on this will be highly appreciated.
thx