Lv 1128 points

Ajit

Favourite answers0%
Answers16
  • Need help setting up a schedule in Excel. Have asked several times, but no response.. Any Excel experts out there? Please, I need help.?

    Columns: 5 days a week, Mon - Fri

    Column a1: list of names

    Cells B1 - F1: days of the week.

    The spreadsheet is to schedule two people together. If on Monday I list in cell B2 a name from cell A9, in cell B9 I want the system to populate the name from A2. I want to be able to add or delete names as necessary. Please help.

    2 AnswersSoftware10 months ago
  • Need Excel 2 set up a scheduling program for a multitude of agents.?

    In column A, a list of names from row 1 to row x. B1 to to F1 are the days of the week, Mon - Fri. List of names can and will change as players are added or deleted. For example: Using David, Don, Joel, Jim, Lisa, A2 through A6. in B2, if I type in Joel, in cell B4, I want the name from A2 , David, to appear. .

    Mon Tue Wed Thur Fri

    David Joel Lisa

    Don Jimmy

    Joel David

    Jimmy Don

    Lisa David

    1 AnswerSoftware11 months ago
  • Need Excel 2 set up a scheduling program for a multitude of agents.?

    In column A, a list of names from row 1 to row x. B1 to to F1 are the days of the week, Mon - Fri. List of names can and will change as players are added or deleted. For example: Using David, Don, Joel, Jim, Lisa, A2 through A6. in B2, if I type in Joel, in cell B4, I want the name from A2 , David, to appear. .

    Mon Tue Wed Thur Fri

    David Joel Lisa

    Don Jimmy

    Joel David

    Jimmy Don

    Lisa David

    3 AnswersSoftware11 months ago
  • Need an Excel Expert please.?

    Trying to set up a scheduling spreadsheet:

     In column A,  I have a list of names from row 1 to  row x. This list can, and will, change depending on the number of employees on any given day.  B1 to through F1 are the days of the week, Mon - Fri. For example: David, Don, Joel, Jim, Lisa, cells A2 through A6. In B2, if I type in Joel, in cell B4 I want the name from A2 , David, to appear, and vice versa.

                                      Mon     Tue     Wed     Thur     Fri

    David                         Joel                  

    Don                                        Jim

    Joel                            David              Lisa

    Jim                                          Don

    Lisa                                                    Joel

    Not sure whether I have to set up a Macro, or what I need to do. Any help would be sincerely appreciated.

    Thanks.

    Software11 months ago