Author Topic: Using Lists In Excel (Read 129 times)

BlckMgk · « **on:** February 28, 2005, 01:54:17 PM »

If anyone is familiar with excel, could you please help me with the following:

I'm working with lists on a spread sheet.
I select the "sorts" from the column headers to only display what I need.

What I need to know is if I can shoot that sorted list out to another sheet/book.

I.e. if I was doing a query create a table.

-BM

p.s. if i'm making no sense......... i apologize.

Lizking · « **Reply #1 on:** February 28, 2005, 02:00:11 PM »

Can't you just sort it then right click copy and paste it?

EN4CER · « **Reply #2 on:** February 28, 2005, 02:02:56 PM »

MS Access might be better suitable for the task I believe you are trying to accomplish. Excel is ok for a small table of data but when you start talking queries I would migrate to Access if possible.

BlckMgk · « **Reply #3 on:** February 28, 2005, 02:07:18 PM »

Quote

Originally posted by Lizking
Can't you just sort it then right click copy and paste it?

why yes I can..

Thank you