Hi All,
I want to wirte a macro where i have to calculate the average of Stock Return for each company at the end of each year. Then copy the value and paste it in a diferent sheet.
I have attached the workbook for the same. I have highlighted the area with yellow colour.
Plz looking forward ur help
Regards,
Upananda
Last edited by pani_hcu; 08-26-2009 at 02:14 PM. Reason: title
Put this formula in B3 of "Final Data" and copy down/across. No macro needed.
=INDEX(Sheet2!$C$2:$T$584,MATCH(DATE(B$1,12,31), Sheet2!$A$2:$A$584, 1)+1, MATCH($A3, Sheet2!$C$1:$T$1, 0)+1)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks JB,
The formula is working fine.
Thanks and Regards,
Upananda
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks