I have two tab delimited spreadsheet files of a product database. My
MAIN concern here is that I need to import the prices from one
spreadsheet, to a specific column in my original spreadsheet, and I
need those prices to correspond with the respective product IDs. Is
this possible ??? thanks in advance guys!

My main spreadsheet (tab delimited file) I have it setup as
follows:

A                             B                           C
        D

ProductID49483     Brief Description     Image.jpg           3.00
ProductID93094     Brief Description     Image.jpg           5.00
ProductID30940     Brief Description     Image.jpg           8.00

my alternate spreadsheet (tab delimited file) is as follows:

A                              B

ProductID49483      4.50
ProductID93094      8.50
ProductID30940      9.50

I want to make it so that I can Import my alternate spreadsheet into my

main spreadsheet, but I only want it to alter column D on my main
spreadsheet (changing prices). I need a macro, or a formula which will
import column B from my alternate spreadsheet into column D in my main
spreadsheet. I also need this macro/formula to be able to correspond
the price with the correct productID...so it changes the correct
product to its designated price.