Copied Rows do not automatically update in a Rollup Sheet
I am going to ask this questions as best I can....
- I have a sheet that I input information.
- Based on a value from a column, I automated it to copy that row into what I call a ROLL-UP SHEET.
- I then created a NEW SHEET with some new columns as well as some columns from the roll-up sheet.
- I did cell linking on the columns from the ROLL-UP SHEET.
Unfortunately, when new rows are added into the ROLL-UP SHEET from the automation, the cell linking for those columns does not automatically update in the NEW sheet.
I have tried looking into this in the forums but I cannot seem to find the right answer.
Thank you for all your help!
Help Article Resources
Check out the Formula Handbook template!