New Posts  All Forums:Forum Nav:

Excel Question

post #1 of 4
Thread Starter 
Hey, first of all I am building an excel spreadsheet to record the entry of data of incoming laptops for the company I work with. I have been working in excel for the last two days off and on with no progress so far.

Let's say the Product Code for a laptop (Dell XPS 15) is 340935022 is there anyway when I scan the barcode into excel it automatically switch it from saying 340935022 to Dell XPS 15?

Thanks in advance!smile.gif
Primary PC
(17 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core i5-4690K ASRock Z97 Extreme6 NVIDIA EVGA GeForce GTX 1070 Founders Edition G.Skill 8 x 2GB (16GB) 1600MHz Dual Channel  
Hard DriveHard DriveCoolingOS
Plextor 256GB SSD  Western Digital 640gb 7200rpm 32mb Cache Corsair H50  Windows 7 64bit Professional 
MonitorMonitorKeyboardPower
LG 22" IPS LED  Samsung SyncMaster PX2370 22" LED Razer BlackWidow SilverStone 750 Modular 
CaseMouseAudio
CoolerMaster Cosmos Razer DeathAdder Onboard 
  hide details  
Reply
Primary PC
(17 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core i5-4690K ASRock Z97 Extreme6 NVIDIA EVGA GeForce GTX 1070 Founders Edition G.Skill 8 x 2GB (16GB) 1600MHz Dual Channel  
Hard DriveHard DriveCoolingOS
Plextor 256GB SSD  Western Digital 640gb 7200rpm 32mb Cache Corsair H50  Windows 7 64bit Professional 
MonitorMonitorKeyboardPower
LG 22" IPS LED  Samsung SyncMaster PX2370 22" LED Razer BlackWidow SilverStone 750 Modular 
CaseMouseAudio
CoolerMaster Cosmos Razer DeathAdder Onboard 
  hide details  
Reply
post #2 of 4
I think you can set this type of thing in autocorrect.

Check the tools options, you may be able to set "DELL XPS 15" to replace the arbitrary unit number or whatever you are scanning in automatically.
    
CPUMotherboardGraphicsRAM
Phenom II X3 720 @ 3.5 (1.39v) Gigabyte GA-MA790XT-UD4P ASUS 5850 @ 880/1180 (1.118v) 4gb 1333mhz G.Skill DDR3 
Hard DriveHard DriveHard DriveHard Drive
64gb Crucial M4 SSD 3x 250gb WD2500JD - RAID0 1tb WD1001FALS 1tb WD10EARS 
Optical DriveCoolingOSMonitor
Pioneer DLDVD/CDRW Arctic Freezer Pro 64 Win 7 64bit Ultimate E2305 LG 23" LED 
KeyboardPowerCaseMouse
Filco Majestouch II Ninja Tenkeyless Fortron BlueStorm II 500w CM 690II Advanced Razer DeathAdder 
Mouse PadAudioAudio
generic Echo Miamidi PCI M-Audio BX5a Studio Monitors 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Phenom II X3 720 @ 3.5 (1.39v) Gigabyte GA-MA790XT-UD4P ASUS 5850 @ 880/1180 (1.118v) 4gb 1333mhz G.Skill DDR3 
Hard DriveHard DriveHard DriveHard Drive
64gb Crucial M4 SSD 3x 250gb WD2500JD - RAID0 1tb WD1001FALS 1tb WD10EARS 
Optical DriveCoolingOSMonitor
Pioneer DLDVD/CDRW Arctic Freezer Pro 64 Win 7 64bit Ultimate E2305 LG 23" LED 
KeyboardPowerCaseMouse
Filco Majestouch II Ninja Tenkeyless Fortron BlueStorm II 500w CM 690II Advanced Razer DeathAdder 
Mouse PadAudioAudio
generic Echo Miamidi PCI M-Audio BX5a Studio Monitors 
  hide details  
Reply
post #3 of 4
Thread Starter 
Thanks a lot man, a simple fix to a hard thing for me!
Primary PC
(17 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core i5-4690K ASRock Z97 Extreme6 NVIDIA EVGA GeForce GTX 1070 Founders Edition G.Skill 8 x 2GB (16GB) 1600MHz Dual Channel  
Hard DriveHard DriveCoolingOS
Plextor 256GB SSD  Western Digital 640gb 7200rpm 32mb Cache Corsair H50  Windows 7 64bit Professional 
MonitorMonitorKeyboardPower
LG 22" IPS LED  Samsung SyncMaster PX2370 22" LED Razer BlackWidow SilverStone 750 Modular 
CaseMouseAudio
CoolerMaster Cosmos Razer DeathAdder Onboard 
  hide details  
Reply
Primary PC
(17 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core i5-4690K ASRock Z97 Extreme6 NVIDIA EVGA GeForce GTX 1070 Founders Edition G.Skill 8 x 2GB (16GB) 1600MHz Dual Channel  
Hard DriveHard DriveCoolingOS
Plextor 256GB SSD  Western Digital 640gb 7200rpm 32mb Cache Corsair H50  Windows 7 64bit Professional 
MonitorMonitorKeyboardPower
LG 22" IPS LED  Samsung SyncMaster PX2370 22" LED Razer BlackWidow SilverStone 750 Modular 
CaseMouseAudio
CoolerMaster Cosmos Razer DeathAdder Onboard 
  hide details  
Reply
post #4 of 4
Glad it worked.

I just recently started using Excel, and while it has way more power than I ever thought, I find it stupidly difficult to work with.
    
CPUMotherboardGraphicsRAM
Phenom II X3 720 @ 3.5 (1.39v) Gigabyte GA-MA790XT-UD4P ASUS 5850 @ 880/1180 (1.118v) 4gb 1333mhz G.Skill DDR3 
Hard DriveHard DriveHard DriveHard Drive
64gb Crucial M4 SSD 3x 250gb WD2500JD - RAID0 1tb WD1001FALS 1tb WD10EARS 
Optical DriveCoolingOSMonitor
Pioneer DLDVD/CDRW Arctic Freezer Pro 64 Win 7 64bit Ultimate E2305 LG 23" LED 
KeyboardPowerCaseMouse
Filco Majestouch II Ninja Tenkeyless Fortron BlueStorm II 500w CM 690II Advanced Razer DeathAdder 
Mouse PadAudioAudio
generic Echo Miamidi PCI M-Audio BX5a Studio Monitors 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Phenom II X3 720 @ 3.5 (1.39v) Gigabyte GA-MA790XT-UD4P ASUS 5850 @ 880/1180 (1.118v) 4gb 1333mhz G.Skill DDR3 
Hard DriveHard DriveHard DriveHard Drive
64gb Crucial M4 SSD 3x 250gb WD2500JD - RAID0 1tb WD1001FALS 1tb WD10EARS 
Optical DriveCoolingOSMonitor
Pioneer DLDVD/CDRW Arctic Freezer Pro 64 Win 7 64bit Ultimate E2305 LG 23" LED 
KeyboardPowerCaseMouse
Filco Majestouch II Ninja Tenkeyless Fortron BlueStorm II 500w CM 690II Advanced Razer DeathAdder 
Mouse PadAudioAudio
generic Echo Miamidi PCI M-Audio BX5a Studio Monitors 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software