Hi
This is a problem I regularly have to deal with and have always done manually, but I am sure you clever guys can help;-)
Client provides me with 2 or 3 (or more) spreadsheets with name, address, contact info... could be up to 30 columns or more.... but the column layouts on the different...