Jeff commented that he wants to bring in the latest x columns in from spreadsheet using MS Query, where x is some number. The columns are expanding, so he doesn’t always know what the latest will be.
I started with this example spreadsheet Note that the “date” headers aren’t really dates but strings (they have a [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/04/28/dynamic-columns-in-ms-query/
Posted
Apr 28 2010, 07:00 AM
by
Daily Dose of Excel