How to Auto sort cells containing formulas pulling data from another sheet?????

**new@excel** · 04-05-2013, 04:48 PM

To keep it short I want to sort a position schedule by shift time. So if I have 3 staff members scheduled for am/pm concessions, I would like it to auto sort from earliest to latest as/after data is edited in the Master sheet. I hope this makes sense! I have attached a sample of the schedule I am working on. Thank you!

**:) Sixthsense :)** · 04-06-2013, 02:38 AM

Please Refer the attached file for solution

**new@excel** · 04-06-2013, 04:17 AM

WOW!!!! I don't know what else to say or how I can THANK YOU enough!!!!! I knew there was away to to transfer times to specific cells based on am or pm and be sorted from earliest to latest. I'm gonna input everything into the Full schedule and confirm it works. I will let you know the outcome. Thanks again! I really do appreciate it!

**new@excel** · 04-06-2013, 09:27 PM

OK so I spoke too soon. That would have worked perfectly if I was dealing with only one position (Concessions). So I apologize Sixthsense for not clarifying the extent of the details and for not attaching a better example of the schedule I am trying to customize. So I hope I didn't waste too much of yours or anyone else time. I have attached a more detailed example of what I am working on.

So in this example I have a Master schedule set for Friday. I already have the data transferring from the "MASTER" worksheet to its corresponding cell in the "FRIDAY" worksheet. I am trying to find away to sort the data by shift from earliest to latest so when a shift manager looks at it they will easily be able to see who is scheduled where and when.

Again my apologies for wasting anyone's time and will understand if you decide not to bother with this second attachment.

Thank you!