Guest Martin Ellis Posted September 13, 2007 Posted September 13, 2007 Apologies if this is in the wrong area. I've downloaded some .csv files which contain speed camera details for my Garmin Zumo. There are separate files for Average, Mobile and Gatso cameras, among others. The Gatso file (for example) lists all know Gatsos, and identifies them with the speed in the last cell on each line (i.e 30 - 40 - 50) but the lines are not all in groups of each speed, there may be three 30s, then two 40s, then six more 30s etc. I want to be able to select all of the lines for one speed and save them into another new file, thus ending up with a 30 file, a 40 file, a 50 file... etc. Excel (2003 XP) baulks at letting me select mulitple lines for a cut or copy operation, and cutting and pasting each line individually is out of the question as there are over 5000 in each of the four original files. Can it be done?
Guest Pegasus \(MVP\) Posted September 13, 2007 Posted September 13, 2007 Re: Cutting and pasting multiple lines in Excel "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... > Apologies if this is in the wrong area. > I'm afraid you are. An Excel newsgroup would be the right place to post your question.
Guest Martin Ellis Posted September 13, 2007 Posted September 13, 2007 Re: Cutting and pasting multiple lines in Excel Fair comment. I couldn't see one in the list of available news groups on the XP page. Any ideas? "Pegasus (MVP)" wrote: > > "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message > news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... > > Apologies if this is in the wrong area. > > > > I'm afraid you are. An Excel newsgroup would be the right > place to post your question. > > >
Guest Stephen Posted September 13, 2007 Posted September 13, 2007 Re: Cutting and pasting multiple lines in Excel You should use microsoft.public.excel or microsoft.public.excel.misc Which "XP page" are you talking about? Excel will run under different versions of Windows, so "XP" is irrelevant to your needs. Stephen "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message news:5100ADC1-798D-4EDB-83F9-030E93878D20@microsoft.com... > Fair comment. I couldn't see one in the list of available news groups on > the > XP page. Any ideas? > > "Pegasus (MVP)" wrote: > >> >> "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message >> news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... >> > Apologies if this is in the wrong area. >> > >> >> I'm afraid you are. An Excel newsgroup would be the right >> place to post your question. >> >> >>
Guest HeyBub Posted September 13, 2007 Posted September 13, 2007 Re: Cutting and pasting multiple lines in Excel Martin Ellis wrote: > Fair comment. I couldn't see one in the list of available news groups > on the XP page. Any ideas? There are 31 "excel" related newsgroups on the microsoft news server.
Guest Unknown Posted September 13, 2007 Posted September 13, 2007 Re: Cutting and pasting multiple lines in Excel Look under Microsoft.public.excel.XXXXXX "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message news:5100ADC1-798D-4EDB-83F9-030E93878D20@microsoft.com... > Fair comment. I couldn't see one in the list of available news groups on > the > XP page. Any ideas? > > "Pegasus (MVP)" wrote: > >> >> "Martin Ellis" <MartinEllis@discussions.microsoft.com> wrote in message >> news:2126E2B5-7962-41E2-9EFD-78D3710BED2B@microsoft.com... >> > Apologies if this is in the wrong area. >> > >> >> I'm afraid you are. An Excel newsgroup would be the right >> place to post your question. >> >> >>
Recommended Posts