Organize Data With New Headings Automatically

Hello,

I have a large amount of data, 30 columns, that I would like to use in an outside program. This program often wants the data with a different order of headings. Is there a formula that will automatically fill in the correct values by looking at the new headings and the original data? Please see excel attached.

For example original data.

Oranges Plums Cherries Grapefruit Apples
2 1 55 666 656
2 1 55 676 656
3 1 5 565 566
2 1 5 565 565
4 1 55 5665 566
2 1 5 755 565
32 1 5 544 555
32 1 5 445 555
4 1 55 343 555
2 11 5 344 556



NEW ORDER OF COLUMNS
Apples Grapefruit Oranges Cherries Plums
Would like formula to match and autofill data.


Each time I run the external program it wants the data in a new order so imagine how annoying that is

Thank you excel experts!

Shane

See attached.

Try this,

Create two named ranges
1/. "DataTable"
Refers to:

Please Login or Register  to view this content.

2/. "Headers"
Refers to:

Please Login or Register  to view this content.

Use the range "Headers" for the data validation in Range K1:O1 or more as you might require. Possibly in another sheet, if you would prefer it.

Then in K2 (or wherever you need, this again need not be in the same sheet.)

Please Login or Register  to view this content.

Drag/Down to cover the realistic maximun number of rows expected
Then across for how ever many columns you might need.

If you select from the drop-downs in K1:O1 the lists should change automatically, leaving blanks in this range will clear the copied list.

Add to or change any data in A:E and the lists in K:O will update.

Hope this helps.