Hi,
I receive a spreadsheet daily which contains much information. I have retrieve one piece of information, a price that relates to a certain code. I need to lookup this reference code in column a and then return the average of the prices in columns b&c and show this value on the top line of the spreadhseet. This row is currently populated with other data so a new line will have to be inserted.

I can manage to achieve using worksheet functions but not VBA.

Please help me.

Thanks
Simon