I have a spreadsheet table and need to run a report to extract data from a selection of columns, in a specific order different to that which is received.
As this is a task I do often, it is a pain to handover in my absence bc I need to re-sort the spreadsheet each time; and the headers differ (so I need to match them... e.g. Name is User, Invoice is Number etc but it's not an issue if it is automatically ordered) so I have to match them up each time. Unfortunately despite my efforts of persuasion, I have no control over the arrangement of data received or uploaded as these are uniform across many other areas.
So far, I have a workaround where I have numbered the columns I need, in the order I need them, then I simply sort them. But I need something a bit more automatic for those people who will be doing this in my absence and are much less Excel savvy.
In summation: once data is entered into the target sheet, I would like the summary sheet to pull through the required columns (Row 2), in a specific order (Row 1)
TIA!
e.g.
As this is a task I do often, it is a pain to handover in my absence bc I need to re-sort the spreadsheet each time; and the headers differ (so I need to match them... e.g. Name is User, Invoice is Number etc but it's not an issue if it is automatically ordered) so I have to match them up each time. Unfortunately despite my efforts of persuasion, I have no control over the arrangement of data received or uploaded as these are uniform across many other areas.
So far, I have a workaround where I have numbered the columns I need, in the order I need them, then I simply sort them. But I need something a bit more automatic for those people who will be doing this in my absence and are much less Excel savvy.
In summation: once data is entered into the target sheet, I would like the summary sheet to pull through the required columns (Row 2), in a specific order (Row 1)
TIA!
e.g.
A | B | C | A | B | C | A | B | C | A | B | C | A | B | |
1 | 3 | 0 | 0 | 4 | 1 | 2 | 7 | 8 | 5 | 6 | 9 | 10 | 0 | 0 |
2 | Invoice | Sequence | Period | Date | AC1 | AC2 | Phone | Name | Code | Title | OUT1 | OUT2 | OUT3 | OUT4 |
3 | ||||||||||||||
4 | ||||||||||||||
5 | |