Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.



Windows 7: Splitting Files Excel 2003

26 Nov 2012   #1

Win7 Pro x64 SP1
 
 
Splitting Files Excel 2003

Last week I downloaded a Custom POI .csv file for my Garmin Nuvi. It is a combined file that contains all Walmart, Samsclubs in the US. The file also included two .bmp icons, one for Walmart and one for the Samsclub. I renamed the Walmart .bmp icon to the exact file name of the Walmart.csv file so it is displayed on my map screen. Tried renaming the Samsclub icon with the same filename as the Walmart one but got an error.
One user suggested that I split the main spreadsheet into two seperate files with all of the SamsClubs locations to a new worksheet in order to see the SamsClub icon.
Since I am a novice user of Excel, how do I get all of the SamsClub entries on the main worksheet to a new worksheet? Any assistance would be appreciated. Thanks.

My System SpecsSystem Spec
.

26 Nov 2012   #2

W7 X-64 RTM,SUSE 11.1, XP PRO SP3 as a VM, VMware ESXi
 
 

Open new worksheet IN THE SAME WINDOW

now display side by side (Choose arrange all)

then hold CTRL and left mouse in the worksheet you want to copy - and drag and drop to the workbook open in the 2nd window.
(Names of worksheets are in the tabs at the bottom of each EXCEL workbook).

(Metro users -on W8 Bet you can't do this easily !!).

Cheers
jimbo
My System SpecsSystem Spec
26 Nov 2012   #3

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Please post all relevant files.
My System SpecsSystem Spec
.


26 Nov 2012   #4

Win7 Pro x64 SP1
 
 

jimbo45, Thanks for replying. Did as you suggested but when I dragged the first SamClub to the new worksheet A1, nothing happened, just a blank cell. If I right click the file and click Copy go to the new worksheet and click Paste, the entry shows up. There must be 400+ Samsclub locations on the original file and if I do the copy&paste method it would take forever to create a new file. I guess I will stick with the original .csv file and when I go to a SamsClub just be content at seeing the Walmart icon instead. Thanks anyway for your help.
My System SpecsSystem Spec
Reply

 Splitting Files Excel 2003





Thread Tools



Similar help and support threads for2: Splitting Files Excel 2003
Thread Forum
Issues with Excel 2003 files Microsoft Office
Formatting Excel 2010, Excel 2003 Microsoft Office
Excel 2003 quits Microsoft Office
Excel 2003 Macro Help? Microsoft Office
Problem with Excel 2003 files with Windows 7 Hardware & Devices
Can't open 2003 Excel Files in Excel 2007? Microsoft Office
Excel 2003 - Multiple Excel Open Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 07:31 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33