Splitting Files Excel 2003

[Aviator]

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.

 

[jimbo45]

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

 

[Kaktussoft]

Please post all relevant files.

 

[Aviator]

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.