Have inserted row carried over to other sheets

**frankD101** · 09-13-2018, 08:02 PM

Hello,
I am trying to solve a problem and am unsure how to achieve this. I have a single spreadsheet with multiple tabs that contain text information. I would like to consolidate segments of rows of information from each tab onto an isolated tab (this I know how to do and have any information on those rows that may change on the tabs, automatically update on the consolidated tab)

However, sometimes I need to go to the original tabs and add/insert rows of information. I would like for the consolidated tab of information to also then automatically pull in these new/inserted rows.

I've gotten somewhat close with an INSERT function, however I have to have the rows match on both tabs. This will not work for my purposes. I'd like to be able to specify on tab 1 that I need rows 5-20 to be updated on the consolidated tab. And then also have tab 2 rows 13-18 also be updated on the consolidated tab, and on either tabs 1 or 2 if I insert a new row the consolidated tab would auto inject that new row with whatever data I've entered.

Any help is greatly appreciated.

**kersplash** · 09-13-2018, 08:59 PM

You'll need to attach a workbook showing sample data and what you want as your output.

Go Advanced -> Manage Attachments -> Upload

**frankD101** · 09-14-2018, 08:22 AM

OK I think I've uploaded a spread sheet that gives a rough look at sort of what I'm trying to do.

Each sheet has groups of information, and I'd like to be able to consolidate particular groups to a new sheet and not only have the information update (that's not a problem and I can do that), it's having it so if I go back to Sheet 2 and insert a new row into the category it will automatically insert that new row onto the consolidated sheet.