I have an excel document with 14 sheets. (Twelve individual months, unknown payments, duplicate payments). They all make use of the same headings (A4:L4). Column K is a drop down menu.
I am looking to copy a row from the month sheets to either the unknown payments or duplicate payments sheets based on the selection from column K (either Unknown or Duplicate respectively).
I don't have any experience using VBA. Is anyone able to help?