I have an Excel table, and based on this data, I want to build a report with some aggregated values (sums), each one according to a set of criterias . For each aggregated value in this report, I want to be able to get to the corresponding table rows, change a value in any of these rows, so that the underlying table data changes, and I re-run the report to get an updated view. What is the easiest way to achieve this requirement?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Update underlying rows of sum cells
- Thread starter dimking
- Start date
awoohaw
Well-known Member
- Joined
- Mar 23, 2022
- Messages
- 4,543
- Office Version
- 365
- Platform
- Windows
- Web
Hi and welcome. There is an addin called xl2bb (link below) that would really help the forum help you. If you can post a sample of what you want it would be great.
But, as far as what you wrote. Are you asking to have a formula in a cells that you subsequently want to change? That can't be done. If i've misunderstood, an xl2bb example would be great.
But, as far as what you wrote. Are you asking to have a formula in a cells that you subsequently want to change? That can't be done. If i've misunderstood, an xl2bb example would be great.
Upvote
0
Similar threads
- Question
- Solved
