Cutting and pasting multiple lines in Excel

[Guest Martin Ellis]

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\)]

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]

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]

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]

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]

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.

>>

>>

>>