Hi Guys,
I have a spreadsheet that contains 30 sheets. I want to copy data form 5 of these sheets (sheet2, sheet4, sheet5, sheet6, sheet8 and they all contain named tables) to the master data sheet. All these sheet have the same column headers as the master data sheet, but are in a different order/column ref.
a sample of column headers are as below
Many Thanks in advance.
I have a spreadsheet that contains 30 sheets. I want to copy data form 5 of these sheets (sheet2, sheet4, sheet5, sheet6, sheet8 and they all contain named tables) to the master data sheet. All these sheet have the same column headers as the master data sheet, but are in a different order/column ref.
a sample of column headers are as below
Asset RAG Status | Asset Rag in Detail | Normalised location | Country |
Many Thanks in advance.