ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help On Pulling Data By Column Headers?! Thanks! (https://www.excelbanter.com/excel-programming/331853-help-pulling-data-column-headers-thanks.html)

sunj99[_2_]

Help On Pulling Data By Column Headers?! Thanks!
 

I have a huge database extract with a list of 100+ fixed
headers/headings. For example

Account Number Size Date Source
122 12 21 20050531 A1
233 22 22 20040931 2B

I know I could do it in Access to select certain fields by headers.
How do I do it from Excel with Macro? If I want the content in Columns
- Account, Size, and Source, what shall I do?

Thanks a lot for help.

JS :(


--
sunj99
------------------------------------------------------------------------
sunj99's Profile: http://www.excelforum.com/member.php...o&userid=23935
View this thread: http://www.excelforum.com/showthread...hreadid=379324



All times are GMT +1. The time now is 12:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com