I am in the shipping industry and often have shipments from not so popular places. I am looking for a way that excel will identify the status as "active", recognize the origin city/state and create 3-5 rows with other predetermined city/states that I have placed on another spreadsheet. On the below I have taken a regular pick location (Jacksonville) and have created 5 new rows under; copied the cities form the other spreadsheet that correspond to that location; then i will continue to copy all the other data down. This needs to be done for each shipment's Origin and Destination city.
--HAVE THIS--
STATUS SHIP DELIV STIME DTIME SHIP CITY ST CONS CITY C ST MILES TYPE WEIGHT EQ
ACTIVE 7/28/2011 7/29/2011 1300 900 JACKSONVILLE FL MERIDIAN MS 447 TL 44000 VR
ACTIVE 7/28/2011 8/2/2011 700 630 JOLON CA LIMESTONE ME 3247 PIE 32400 FD
ACTIVE 7/28/2011 8/1/2011 1500 600 FORT COLLINS CO BISBEE AZ 847 TL 43000 R
ON HOLD 7/28/2011 7/29/2011 1700 700 JACKSONVILLE FL CHARLESTON SC 207 TL 44000 VR
BOOKED 7/27/2011 8/1/2011 0800 700 PARAMOUNT CA LEE'S SUMMIT MO 1576 PAL 24000 VR
NEED TO MAKE 3-5 ROWS CHANGING THE CITY/STATE FOR ORIGINS & DESTINATIONS..HERE IS EXAMPLE OF THE TOP ACTIVE LOAD (Jacksonville FL to Meridian MS)
ACTIVE 7/28/2011 7/29/2011 1300 900 JACKSONVILLE FL MERIDIAN MS 447 TL 44000 VR
ACTIVE 7/28/2011 7/29/2011 1300 900 ORLANDO FL MERIDIAN MS 447 TL 44000 VR
ACTIVE 7/28/2011 7/29/2011 1300 900 SAVANNAH GA MERIDIAN MS 447 TL 44000 VR
ACTIVE 7/28/2011 7/29/2011 1300 900 VALDOSTA GA MERIDIAN MS 447 TL 44000 VR
ACTIVE 7/28/2011 7/29/2011 1300 900 RIDGELAND SC MERIDIAN MS 447 TL 44000 VR
ACTIVE 7/28/2011 7/29/2011 1300 900 DAYTONA FL MERIDIAN MS 447 TL 44000 VR
ACTIVE 7/28/2011 7/29/2011 1300 900 JACKSONVILLE FL JACKSON MS 447 TL 44000 VR
ACTIVE 7/28/2011 7/29/2011 1300 900 JACKSONVILLE FL TUSCALOOSA AL 447 TL 44000 VR
ACTIVE 7/28/2011 7/29/2011 1300 900 JACKSONVILLE FL MOBILE AL 447 TL 44000 VR
ACTIVE 7/28/2011 7/29/2011 1300 900 JACKSONVILLE FL MEMPHIS TN 447 TL 44000 VR
ACTIVE 7/28/2011 7/29/2011 1300 900 JACKSONVILLE FL BIRMINGHAM AL 447 TL 44000 VR
Looking for a way to automate the need to (1)create multiple new rows; (2)copy paste the new creative locations for @ Origin & Destination; (3) and then copy down all the other above shipment information.
The cities change daily and I have a small database workbook I am using to keep each city/state combination, the actual location we work with is the top row.
FORT COLLINS CO CARTERSVILLE GA JACKSONVILLE FL MERIDIAN MS HOLLIS CENTER ME SALT LAKE CITY UT
DENVER CO HUNTSVILLE AL ORLANDO FL JACKSON MS BANGO ME OGDEN UT
SIDNEY NE ATLANTA GA SAVANNAH GA TUSCALOOSA AL HOPKINTON NH ROCK SPRINGS WY
COLBY KS ANDERSON SC VALDOSTA GA MOBILE AL MONTPELIER VT TWIN FALLS ID
PUEBLO CO CHATTANOOGA TN RIDGELAND SC MEMPHIS TN BOSTON MA
CHEYENNE WY BIRMINGHAM AL DAYTONA FL BIRMINGHAM AL POLAND SPRING ME
Any ideas let me know.
Bookmarks