I have a spreadsheet where I pull in commodity price data (seperate tab by commodity) - this is working but I cannot figure out how to summarize the information onto one sheet. I would like for the program to pull in the commodity prices listed in the "Last" column (E) of Corn, SBM and LEan Hogs into the correct month on the summary sheet. For example, cell C17 on Summary would be $6.435 (from Corn CBOT cell E3). Cell C19 on Summary would be $6.5075 (from Corn CBOT cell E5) and so on for all the commodities and months.
The data from the web is not formatted such that I can use Vlookups. The pricing data comes in using fractions - I can work with it in any number format once the summary table is working?
I do not know how to write VBA, I have been able to adjust others work once it is set up for me.
Thanks!
Bookmarks