My boss does a telephone roster, and has a list of staff and 1/2 hour slots for each day when we cover the phone, and does a seperate sheet for each day of the month. Is there any way of filtering the data so I can see only the rows that contain the times of day, and all the rows with my personal times in for the whole month? hope that makes sense!
2007-02-15 11:51:09 · 6 answers · asked by properdivers 2 in Computers & Internet ➔ Programming & Design
I agree that this would be a job for a database.
When you highlight mutiple sheets in Excel the sort options is not available.
2007-02-15 12:24:23 · answer #1 · answered by blndchik 5 · 0⤊ 0⤋
From top of my head - I think there could be more than one ways to do this and I am sure you don't necessarily have to use the database... but the exact procedure to do this can be determined only after I see the spreadsheets. If you email me the excel file or a sample excel file that has data in the same format as your original roster, I do the required stuff to help you view your entries for the entire month.
your_taurean@yahoo.com
2007-02-15 12:24:42 · answer #2 · answered by SmartSpider 4 · 1⤊ 0⤋
Excel isn't a program that can do that but you should really take all of the information from the Spreadsheet and put it into Microsoft Access. That is great program for creating and organizing information, it puts it into a database and you can make it in alphabetical order. I would definetly suggest using that. I hope that this helps! Good Luck
2007-02-15 12:32:04 · answer #3 · answered by cks 3 · 0⤊ 1⤋
Excel isn't a application that ought to attempt this yet you are able to fairly take each and each and every and each and each and every of the the help of the Spreadsheet and positioned it into Microsoft get actual of get admission to to. it fairly is tremendous application for arising and organizing practise, it places it actual right into a database and also you are able to make it in alphabetical order. i'd definetly propose utilising that. i'm hoping that this allows! solid success
2016-12-04 05:47:47 · answer #4 · answered by ? 4 · 0⤊ 0⤋
I could be wrong but I don't thing so.
the cells of the spreadsheet are individual.
If you have the information in records, for example in access you could sort by any data that you have.
You can export to access but it would be a lot of work to do all the time.
2007-02-15 12:11:20 · answer #5 · answered by ? 3 · 0⤊ 0⤋
Its one of my favorite tasks. Using someone else 'impossible' spreadsheet and make it work for me. Email it to me if it is not confidential.
2007-02-15 17:52:06 · answer #6 · answered by unnga 6 · 0⤊ 0⤋