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
Aviator

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
jimbo45

Linux CENTOS 7 / various Windows OS'es and servers
 
 

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
Kaktussoft

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
Aviator

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
Thread Forum
MSO10 Starter won't read Excel 2003 files
Computer 1: Windows 7 sp1 & Office 2010 Starter After Patch Tuesday 9/10/2013, Excel 2010 is no longer able to read Excel 2003 files. In fact, all Excel 2003 files have changed from the standard Excel Icon to a non-standard orange Icon. Attempts to open these files will bring up the Install...
Microsoft Office
Issues with Excel 2003 files
Dear Experts, please can you help? When I create Excel documents using Excel 2003 on my Windows 7 system it saves them as 'OOBE.' documents. If I try to open them from 'My Computer' it says it cannot open them (the Open With option does not suggest Excel). However if I open Excel first then go...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Problem with Excel 2003 files with Windows 7
New computer has windows 7 op system. When I transfer Excel files from my laptop (using XP Home) I get an error message saying 'There was a problem sending the command to the program' Any idesa what the solution is? The files were generated on Excel 2003.
Hardware & Devices
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
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 12:24.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App