Hi
I am trying to figure out if there is a simple way to replicate the contents of multiple sheets into one sheet based on the headings of those multiple sheets.
Please find attached an example (test.xlsx) of what I am trying to achieve.
In sheet 1, I have the headings of A-F out of order.
In sheet 2, I have the headings of A, B and C with various numbers underneath each heading.
In sheet 3, I have the headings of D, E and F with various numbers underneath each heading.
What I am trying to do is:
- Get the contents under the headings of sheets 2 and 3 under the correct headings of sheet 1.
- As I make alterations to the headings in sheet 1, the information underneath updates automatically (e.g. switch headings around).
- Make sheet 1 to be live, in that, as I make changes (or add more or delete rows, or paste information) to sheets 2 & 3, that the contents of sheet 1 would automatically update.
If anyone out there can help, I'd be most appreciative.
Cheers
Bookmarks