Updating a summary tab when additional rows are added from the feeder tab

[LoriC24]

Hello,

I currently have a report that includes a tab that summarizes 2 separate tabs. I have them linked to when the user updates the current information, it rolls up but I need to capture any new rows/colums they may add as well. Would a macro solve this?
Thanks!

[Richard Buttrey]

Hi and welcome to the forum.

Without seeing and understanding your data it's somewhat difficult to comment with certainty Almost certainly a macro may achieve what you want, (macros can do most things) but it may not be necessary. It's possible that using a dynamic range name (one that adjusts automatically as new rows/columns are added may suffice.

Upload the actual workbook for more specific advice and indicate how you use it and what you expect to see when new data is added.

[LoriC24]

Currently information from the GT and BF sheets roll up to the Opps sheet (which is protected). I need any additional rows / columns they add on their pages to reflect on the Opps sheet. Thank you!