Pulling specific details from a spreadsheet

[R D S]

Hi,
I have a spreadsheet of orders taken, the details are in rows, col B is the
customer name and there is often repeat work, can i import all the rows into
another spreadsheet for a specified customer?

Thanks,
Rick

 

[Don Guillett]

Have a look at using filter>autofilter>filter on column b

 

[RDS]

Have a look at using filter>autofilter>filter on column b

Hi,
What i need to do is then email a copy of my findings.
What i am currently doing is sorting by col B, renaming the file, deleting
everything other than the required info, then attaching this to an email.
Im guessing there is an easier way

Best regards,
Rick

 

[scottymelloty]

highlight the column header names, if you have got any insert a line an
put a column name ie A1 NAME B1 ADDRESS etc

Highlight the column names DATA - FILTER - AUTOFILTER, this will brin
an arrow up on each header name if you click the arrow you can selec
whatever you want and it just brings that data up for your selection
just save file and send that, the rest of the data is still there an
if you want to reset it back just click the arrow again and select ALL

 

[dcronje]

If you are trying to extract data to another spreadsheet you can alway
look at the "Get external data" option from the data menu.

In a new spreadsheet select Data>Get External Data>New Database Quer
and follow the instructions this may be what you are looking for.

Another option could be Advanced Filter.

Let me know if this is what you ae looking for and I will provid
further details if required

 

[R D S]

Hi,
Ive had a look at this and wondered how do i pull the data from specific
columns into a new sheet where col B contains xxxxxxx?
Do I run the query from an empty database or do I work from the existing
database containing the data.

Rick