Sort Columns to Match Existing Dashboard

[wsimpson174]

I have an excel Dashboard. I receive info once per week with 3 columns. they are not in the same order as my columns in the dashboard. I want to do a match and then sort so they match the column info on the dashboard. How can I do that?

 

[oldbrewer]

Re: 174

why not re-order the columns to match the dashboard ?

 

[oldbrewer]

Re: 174

alf	bill	colin				bill	colin	alf
						select col A and insert 3 colmns
						match bill in D:F
						2
						cut col 5
						('2+3)
						select col 1
						paste
						do twice more

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Macropod]

wsimpson174: As per Guideline 4 (https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html), please give your threads meaningful titles. 174 does not qualify.