Multiple Arguments
I am trying to restore a template that an employee typed over the fomulas. The creator of the document no longer is employed with us, and since I know very little about excel, I hope someone can help me with this. I was able to get the formula to work in some of the columns but others don't work. On Column G & H this person has three days of instead of two so I tried to enter a third augument in the formula, but that does not work. On the documents that were not password protected I found two different ways the days of the month are populated Column B & C. The swings tab is the easies to change but it gives an #value error. The days tab works but if the user does not understand excel fairly well they may have a hard time updating the form each month, and again some of the column are not reading the formula. Hope this all make since.
OT-Signup-for-Supervisors--May-2.xlsx
OT-Signup-for-Supervisors--May-2.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
poucedeleon: I am not sure which text are you referring to but did you try the file that I posted above? It works.
Sid
Sid
ASKER
Found the problem on my own
Copy the cells C6 to C36 from Sheet "MJ - Days" and paste it in C6 to C36 in Sheet "MJ - Swings".
Once you do that the values will correctly populate.
See sample attached.
Is this what you wanted?
Sid
OT-Signup-for-Supervisors--May-2.xlsx