Import Text File Ddata Into Excel Spreadsheet - Multiple Columns & Rows

Hello All,

Did a quick search for multi-row/column text file importing but came up short with what I am looking for. I am still learning VBA and Macro design, so some of the online help I have found is still a little over my head...

I have a spreadsheet to be used in cost estimating, or which I want to keep a separate text file with current prices that can be used to update on command by the user (via a button). The text file will be comma delimited. The text file will have the [Name of the Material] "," [Price] (i.e. Concrete,100.00) and each material will be placed on a new line.

I currently have the following code in place for the user to select which price file to import:

Please Login or Register  to view this content.

Below is a list of cell locations I need the data to input into. I have replaced descriptions of material with alphabetical character for simplicity. I also would like to have the data formatted into "Accounting" style, Arial Size 11 font, and cell centered.

Material	Column	Row
A	8	18
B	6	21
C	6	24
D	6	25
E	6	28
F	6	29
G	6	30
H	8	33
I	8	34
J	8	35
K	6	38

Please let me know if there is anything else I need to add, or other questions.

Thank you in advance for the help with this!

No one? I'v been at it for a couple hours and can't get anything to work.