troubleshooting Question

Dynamically updating ranges in Excel - please update my spreadsheet

Avatar of hedgeselect
hedgeselectFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft OfficeMicrosoft ExcelSpreadsheets
17 Comments8 Solutions1095 ViewsLast Modified:
Could someone who is good at working with dynamic cell referencing, please make changes to the attached spreadsheet so that as new monthly performance return data is added to column B on worksheet 1 and columns B, E and H on worksheet 2, the following is dynamically updated:

In the summary statistics table on worksheet 3:

1. Each of the 4 lines in the chart are dynamically updated so that I don't need to do anything when a new monthly return is added to worksheets 1 and 2

2.  Cells C21 to C24 and  C26 to 27 need to also dynamically update with the new additional monthly returns

Thanks.

 Master-Statistics-template-1.xls
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 8 Answers and 17 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 8 Answers and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros