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:

Sub Update_Prices()

Dim iReply1 As Integer

    iReply1 = MsgBox(Prompt:="Do you wish to update material pricing at this time?", Buttons:=vbYesNoCancel, Title:="Update Price")
        
    If iReply1 = vbYes Then
        
        Run (Application.GetOpenFilename(FileFilter:="Text Document (*.txt), *.txt", Title:="Open File"))
        '--> This is where I need help to choose/open the file and input the Text File

    ElseIf iReply1 = vbNo Then
                            
    Else
        Exit Sub
        
    End If

End Sub
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!