I have an excel sheet where the "F" column contains order status. Where that order status is "Processed" I want to put todays date in the "G" column next to it. There may be several instances or the word Processed in the F column.
So for instance:
F4, F7 and F8 may have the word "Processed" in them. I want to press a button which runs through all the values in the values in the F column and would end up putting today's date in G4, G7 and G8.
I've tried to work this out using other examples, but I'm nowhere near.
thanks for your help.
So for instance:
F4, F7 and F8 may have the word "Processed" in them. I want to press a button which runs through all the values in the values in the F column and would end up putting today's date in G4, G7 and G8.
I've tried to work this out using other examples, but I'm nowhere near.
thanks for your help.