Hello,
I am currently working on a document with two sheets on the same excel document and I want the second sheet to be automatically populated when an event occurs in the first sheet. I want colums A, B, C and K from sheet 1 to be automatically copied onto sheet 2 (A,B,C and E) when "Failed" or "Swapped or Upfit" is entered into column K of the corresponding row on sheet 1.
Can someone please help with this? Thanks in advance