Aces High Bulletin Board

General Forums => The O' Club => Topic started by: BlckMgk on February 28, 2005, 01:54:17 PM

Title: Using Lists In Excel
Post by: 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.

Title: Using Lists In Excel
Post by: Lizking on February 28, 2005, 02:00:11 PM

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

Title: Using Lists In Excel
Post by: EN4CER 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.

Title: Using Lists In Excel
Post by: BlckMgk 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