Splitting Files Excel 2003


  1. Posts : 48
    Win7 Pro x64 SP1
       #1

    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 Computer


  2. Posts : 5,941
    Linux CENTOS 7 / various Windows OS'es and servers
       #2

    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 Computer


  3. Posts : 10,796
    Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
       #3

    Please post all relevant files.
      My Computer


  4. Posts : 48
    Win7 Pro x64 SP1
    Thread Starter
       #4

    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 Computer


 

  Related Discussions
Our Sites
Site Links
About 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 18:26.
Find Us