I have a file (file1.xlsm), which has 3 columns: Class, Supplier and Invoice. This is a download from an accounting package. The number in the Class column can appear more than once, if more than one invoice has been issued for that Class..
I have a second file (file2.xlsm) that has one line for each Class and in this line there are 4 cells (columns M,N,O &P) for the involve numbers to appear. So, if there is only 1 invoice for the class, the invoice number will appear in cell M of the Class line, if there are 2 invoices, the second invoice will appear in column N, and so on.
Looking for a solution that will do this.
Many thanks
I have a second file (file2.xlsm) that has one line for each Class and in this line there are 4 cells (columns M,N,O &P) for the involve numbers to appear. So, if there is only 1 invoice for the class, the invoice number will appear in cell M of the Class line, if there are 2 invoices, the second invoice will appear in column N, and so on.
Looking for a solution that will do this.
Many thanks