excelslave
New Member
- Joined
- Nov 8, 2005
- Messages
- 7
I've searched for days and am burnt looking for a way (if possible) to
drag and drop from 1 list to another or some sort of transfer code. I am
totaly new to list / combo boxes so any guildness would be appreciated.
My goal. I have many sheets with data (mostly text) in columns, using a
form with a couple list boxes I'd like the user to be able to pick an
item(s) from list 1 and transfer it to list 2 removing it from the
origanal list or vice versa, item in list 2 transfered to list 1 and
have the sheets reflect the change.
Each colunm is in it's own list.
I would appreciate any help.. I attached sample of actual sheets
(except I copied data from the other sheet to put on 1 to show you)
Thank you in advance,
Pat
drag and drop from 1 list to another or some sort of transfer code. I am
totaly new to list / combo boxes so any guildness would be appreciated.
My goal. I have many sheets with data (mostly text) in columns, using a
form with a couple list boxes I'd like the user to be able to pick an
item(s) from list 1 and transfer it to list 2 removing it from the
origanal list or vice versa, item in list 2 transfered to list 1 and
have the sheets reflect the change.
Each colunm is in it's own list.
I would appreciate any help.. I attached sample of actual sheets
(except I copied data from the other sheet to put on 1 to show you)
Thank you in advance,
Pat
| DWSN AD.xls | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | 1685-VIBES | 1685-VIBE ELECTRONICS, MISC | 1630-MAKERS | 1630-MODEL / TYPE | 1630-USAGE | |||
| 2 | BIRDWAGEN MK4 HEMI 60 | ESG COMPUTER INTERFACE SYSTEM | BIG TEX | BOUNDER | QUAD / MULE HAULER | |||
| 3 | MERTZ M-26HD/623B | RADIOS | CHEV | C-1500 | BATT CHARGING | |||
| 4 | MERTZ BUGGIE M-26 HD/623B | VIB PRO UNIT & VIB PRO SIGNAL ACQ CARD | DODGE | CLUB VVAGON | BBQ / GRILL | |||
| 5 | MERTZ SAUDI M-26 HD/623B | 2-VIB PRO UNITS VER 3-1 SERIAL | DORSEY | COACHMAN | CAR / VEH HAUL | |||
| 6 | MERTZ VIBE M-18 HD/623A95 | ON 734-VIB LIFT ASSY | DWSN MADE | CROVVN VIC | FIELD OFF | |||
| 7 | MERTZ VIBE M-18/617 | VIB PRO UNIT -CONNECTOR PANEL ASSEMBLY-V16 | FONTAINE | E-350 | GENERATOR | |||
| 8 | MERTZ/SERCEL M-26 HD/623B | 583-ADV II CONT ELECT ACCELEROMETER | FORD | E-350 VAN | HAUL VIBES | |||
| 9 | 4-ADV II VIB CONV.5.1 & 8 ACCELEROMETERS | FREIGHTLINER | EAGER BEAVER | MAIN OFF | ||||
| 10 | MILLER BOBCAT WELDER | FRUEHAUF | EXPEDITION | MISC UTILITY | ||||
| 11 | 5-ADV II VIB CONTROL ELEC SYSTEM | GMC | EXPLORER | PARTS | ||||
| 12 | ADV II ACCELEROMETER | GREAT DANE | F-150 | VEH WASHER | ||||
| 13 | ADV III BIV UPGRADE | GRUMAN ATLAS | F-250 | RECORDER | ||||
| 14 | VIB INSTANTANEOUS PHASE UPGRADE | HONDA | F-350 | SAFETY DEPT | ||||
| 15 | V-7 VIB CONTROL UPGRADE | HUSKY | F-450 | SERVICE TRUCK | ||||
| 16 | TAX ON VIB CONTROL UPGRADE | INTERNATIONAL | F-500 | SHOP | ||||
| 17 | ADD ON-5 VIB UPGRADE-SEE#1063 | KAWASAKI | F-700 | SURVEYORS | ||||
| 18 | SALES TAX FAS#1105 | KEN WORTH | F-800 | TRANSCRIBER | ||||
| 19 | M-18 SHEARWAVE PKG | KUBOTA | F-800 | TRANSPORT CREW | ||||
| 20 | 20 VIB TIRES & WHEELS-PURCHASED FROM SHELL | LARK | F-800 | FIELD REPAIR / EQUIP | ||||
| 21 | SALES TAX ON VIBS | LUFKIN | F-900 | KODEAK / HELICOPTER | ||||
| 22 | FORCE METER/WITH POWER SUPPLY | PAYSTAR | FLATBED | JOURNEY MAN; / OFFICE | ||||
| 23 | 5 SWEEP MEMORY MODULES-VIBS 15 | PETERBIL T | FLATBED (W / RAILS) | JUG TRUCK | ||||
| 24 | WALKWAYS ON VIBRATORS V-12 | POLARIS | GOOSENECK | MANAGEMENT | ||||
| 25 | GPS INTERFACE CARD | STOUGHTON | LOWBOY (VIBE TRL) | FIELD USE / MISC | ||||
| 26 | 2 AXIAL PISTON PUMPS | STRICK | MULE | |||||
| 27 | SHEET 1 | SHEET 2 | ||||||
1685 Vibes-Parts>Desc | ||||||||
