Sorting rows on different tabs by date

**moose48fox** · 10-23-2012, 09:54 AM

Hello,

I want to thank everyone for the help ahead of time. This is my first time posting and I am hoping you will be able to help me with a problem, I tried searching to see if it was asked before but could not find it.

I have a excel doc that have multiple tabs (different clients) with information (task, date due, who's responsible, and client), and I want to have a master tab that lists all tasks on any tab put in order by date. Essentially so everyone in the office can quickly see what their most pressing task's are. I attached a dummy excel doc that shows what I am looking for, but if you have any additional questions to help me please let me know and I will get back to you as soon as possible.

Thank you,
Randy

**Blake 7** · 10-23-2012, 10:34 AM

hiya - just my opinion but I think that you are making things dificult for yourself unless there is a good reason you are approaching this task in the way you are.
I would have one sheet with ALL data on (for ALL clients) then you could simply add a formula like this =IF(A2="","",NETWORKDAYS(TODAY(),A2)) with would give you the number of days till deadline (if due date is in col a) or you could pivot this data. Either way, its a lot less complicated. At least to me.

**moose48fox** · 10-23-2012, 10:49 AM

I really like the days till due section and will add that, but the boss wants this setup so I am stuck finding a way to get him what he wants. this will be a doc that all the individual employees can enter the tasks they have for their clients and then the boss can quickly look at the master and see what needs to be done ASAP.

Thank you for your response