Macro to calculate average and transfer the result to another WorkBook

Dear Excel Experts,

I need your kind assistance to write a Macro which will look for 3 cells in Book1 (E10:G10) where this Macro will calculate the average for these three cells and transfer the result to Book2 (A2)

Many thanks in advance for your support.

Please Login or Register  to view this content.

Thank you very much ...solved