Search results

Hi Narayan I've uploaded the file you created for me a while ago. The macros seem not to be working. I've gone into view macros and run, this is the message I'm receiving. Can you please have a look at the worksheet to see why the macros are not working. Thank you again.

Ok thank you.

Yes you would initially enter a value in column E and columns from G to AY would be blank. If there is a mistake in data entry in columns G to AY and changed is it not possible for the information to be updated in column E?

Hi Narayan Is it possible as the data is entered from column G through to AY the data is also updated in column E? Thanks Marilyn

Hi Narayan Yes thank you very much it looks like it will work as required. I'm running it pass my Director to see if there are any changes required. I'll let you know if that is the case. Thank you for your time and effort much appreciated. Marilyn

Hi Narayan I've attached the spreadsheet with dates up to December. Looking forward to your help. Thanks Marilyn

Yes that is correct. I'll have to add the dates and upload. I'm just finishing work but will be able to provide it for you on Monday. Thanks again.

Is there any way around it so it doesn't get erased? Otherwise it might be too hard to keep track if we have requested the details for that week for each machine.

When the service is carried out column C I think probably this needs to be entered manually once that information is received. How will the value from Columns F and beyond transfer to column E?

Yes just enabled it and it has worked.

Hi Yes I do apologise it is different to the values I had initially gave you I thought they would report only the hours the machine performed that week but when obtaining the information they gave me the actual hours of the machine had in total. Sorry not messages in any of the cells.

Hi 1. Yes as you enter the values in column F14 it should update the value in column E14. If a value is then entered in cell G14 then the value in Column E14 should update to that value. The values from column F forward will increase as the machine works each week the hours of the machine...

I'm not sure what you are exactly asking for but I have put in some of the hours of the machines. As the values in column E will be constantly changing on a weekly basis depending on what input is put in Column F and beyond I have left this blank. Column E needs to update each week as the new...

Hi Narayan I've opened up your attachment but there seems not be to any formulae in any of the cells?

1. Data will be entered on a weekly basis from columns F and beyond. This data will be added to column E. Column B will not change and no data will be entered into this column. 2. If the value exceeds then this will alert us that the plant needs to be serviced. Once the service has been...

Hi Narayan I will try to explain more clearly what I'm trying to achieve. 1. The cells likely to have formula in them are column C, D & E. 3. The date from cells E onward will be the weekly dates where the hours the machine has done for the week will be recorded. What I'm trying to achieve is...

Hi Narayan If I could get your assistance again with another spreadsheet I'd appreciate it. We have plant machinery and will be recording the current hours the machine has operated on a weekly basis. I have also included the maintenance interval required for each machine. What I need on the...

Hi Narayan Yes thank you so much exactly what I was after, your help is much appreciated. Hopefully my Director will be happy with it as well.

Hi everyone thank you for your input I have been very busy and have only just managed to have a look at your responses. I have attached the spreadsheet which I have copied the drop down menu for each day which works well until as an example if I was to select the same product SMZ against each...

Hi Narayan thank you for getting back to me and providing your test spreadsheet. The drop down list needs to be available for selection for each day as I noticed that if I choose a different product say on 06/02/18 it also changes the previous day as well. Any idea how to implement the...

Hi Narayank991 & GraH - Guido. Firstly thank you for replying. I've uploaded the file for you to look at. I did paste in the formula you have provided which worked when the SMZ product was selected from the dropdown menu but when I changed it to a different product from the dropdown menu I...

Hi I'm a basic excel user. I have managed to create a dropdown list in column B3 to B6. Dependent on what selection is made in these cells I need to calculate from the corresponding rate from cells B11 to B18 multiply the Tonnage amount in cells C3 to C6 and provide a total in Cells C11 to C18...