Naresh Patel
asked on
Watch V6
I had this question after viewing Data-Updating-VBA-V4.
Like Above Question Code use sheet LumSum Calculation & Rolling Returns Lumsum ...like same need to do it for Sheet Rolling Returns SIP From Sheet SIP Calculation.
See Attached
Thanks
Funds-Watch-v5.xlsm
Like Above Question Code use sheet LumSum Calculation & Rolling Returns Lumsum ...like same need to do it for Sheet Rolling Returns SIP From Sheet SIP Calculation.
See Attached
Thanks
Funds-Watch-v5.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sheet Birla is not between Start and End sheet.
Yes i am preparing all AMC sheets in birla Data is not correct. as from given link wont allow data older than 10 years so i will update old data of each AMC sheet manually from different source.
Thanks
ASKER
Please look at SIP Calculation where the formulas in O5:AC5 returns errors.
Formula changed
=IFERROR(SUM(INDIRECT("I"&MATCH(MAX($M$7:$M$48),$G:$G,0)-O$6*12):INDIRECT("I"&MATCH(MAX($M$7:$M$48),$G:$G,0)-1))*VLOOKUP(MAX($M$7:$M$48),$M$7:$N$48,2,FALSE),"")
Thanks
ASKER
Perfect
ASKER