Recent content by kmakifl

Hui/Faseeh, can I make a pivot table to see people required per widget vs. cumulative?

Hui - Thank you very much for your help - I believe it will work. Faseeh - Thanks for the offer, and no worries on late reply. I will post followup as soon as I update the data.

Hi Faseeh, Thanks for sharing your file. Here is the basic information for my file, I made some comments within same. I hope I have explained sufficiently and that you can assist me. https://docs.google.com/open?id=0B5Vr4r9QZCxgSm9kd1loSVozVzg Thank you.

Hello Everyone, I would appreciate your comments or directions .. a template or how to setup the following: I need to implement and maintain optimal workflow where production employees are required to 1) meet a minimum daily output e.g 200 widgets; 2) complete assembly within 2-3 days of them...

Thanks Narayan, I am on my own, only one in my area with more than basic excel.

I am not familiar with macros, so I am not sure how to copy/paste into my workbook.

Hi Narayan, I am attempting to locate the two files, can you upload again? Thanks.

Asa, you were correct about the value. Thanks to all.

Hi Hui, I know this is supposed to be very simple but I am having a little difficulty with this. I have selected the range,applied your instructions,chose format in lieu of set Yellow. all that fall below 24 highlights but cell with 24 does not.

Thanks, Asa. Narayan, I was able to open but did not find the instructions in the Summary Report. The links are lost.

Narayan, I could not open summary file, error message file not found.

Thanks Narayan.

I am trying to set a rule that if range values are 0 to 24 the cells should turn yellow, if >=25 green. I have one cell with a value of 24 and another with a value of 25, these did not change but remain white, no fill. What step have I missed? Thank you.

Any help is greatly appreciated. Thank you.

Hi, 1. can you direct me to macro examples that will help me achieve the summary sheet? I can probably follow that. Okay for the naming convention. 2. The file imports as you see in the example, except where I have added the total and average cells. I am not sure if I can avoid the zero...