VBA code needed / stock price macro ?

[toekneetn]

hi everyone, can someone please help me with this one function i need to finish up a school project on historical stock prices in excel?? basically i need a way to perform this function:

in row 1, i have 30 RANDOM historical dates, starting in B1 and going right

in column A, i have 10 stock symbols, starting in A2 and going down

Is there a way to automatically grab the ADJUSTED CLOSING PRICE for each symbol for each corresponding date?? if not i have to do it manually!!

Your help in this matter is much appreciated!!!!