Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i organise a schedule
I have a gardening business with weekly, fortnightly and monthl appointments.
Then I fit other jobs in around the fixed clients. Whats the best way to organise myself? I need Names, addresses, frequency,payment,and any other information that would make my life so much easier! Thankyou to whoever answers my query! Yours truly Justins Mowing |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i organise a schedule
If you have not had much experience in excel I would just create a simple
blocked form of data. Name--Address--Frequency--Pmt--Next Appointment Then if you hilight this top row of cells and click on Data--Filter--AutoFilter you will get tons of drop down boxes. Now you can sort and choose data that matches your needs. So you can select Next Appointment and choose the date you want and it will show you all the appointments you have for that day, then you can even select the Name of the person and it will just show you there information. If you are more advanced with excel there are endless possibilities in setting this up to do whatever you want. "Justins Mowing" wrote: I have a gardening business with weekly, fortnightly and monthl appointments. Then I fit other jobs in around the fixed clients. Whats the best way to organise myself? I need Names, addresses, frequency,payment,and any other information that would make my life so much easier! Thankyou to whoever answers my query! Yours truly Justins Mowing |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to organise expenses divided between two payers | New Users to Excel | |||
Re-organise columns so they appear in alphabetical order? | Setting up and Configuration of Excel | |||
how can I use use exel to organise my bank details | New Users to Excel | |||
how to group a row so i can organise data by diff fields | Excel Discussion (Misc queries) | |||
ideas on programmes or software to organise my mobile hairdressin. | New Users to Excel |