Multi sheet sync

Tsbullard

Greetings

I have a main sheet consisting of columns 1,2,3,4,5

I have sub sheets with the same columns where column 5 is unique to each sub sheet

IF I add a row to the main sheet I want it to appear in the sub sheet listed in column 5

IF I add a row to a sub sheet I want it to appear in the main sheet with column 5 properly designating which sub sheet it came from.

I used a simple workflow for sub to main but if I use the same workflow in the main sheet seems like a loop would be created and both sheets would get filled up .

Any help or ideas are appreciated.

Thanks

Tim

Adam Murphy

I think your simple workflow is what I would have suggested, with the addition of helper columns to indicate source sheet (which can then be used as a filter on the reverse workflow). Would that work to stop the infinite loop you're describing?

Tsbullard

That is what I am trying now. Thanks

Simpler is better

Tsbullard

I would like the helper column to automatically get the sheet created in name.

OR maybe I can give each sheet a code that Auto generates on row creation. HMMMM

Will post here if I find the answer

HAve FUn

Tim

Tsbullard

Greetings

I have the copy rows from Main sheet to sub sheets and vice versa working without causing a loop using a column that contains the name of the sheet where created with an index number(prefix is name of sheet and number is generated when row created)

I would like to be able to edit a row in either the main sheet or the sub sheet and use an UPDATE function to the row in the other sheet . In SQL it would be update column xyz where column a in other sheet matches column A in this sheet.

Seem like this should be doable.

Thanks

Tim

Tsbullard

Well this got complicated fast

So hopefully this will clarify what I am Trying to do

Main sheet has all rows in it

Sub sheets have a subset of the rows in them designated by a cell in the main sheet.

IF a row is added either to the main sheet or the sub sheet copy to the other.

IF a row is edited in the main sheet or the sub sheet update the other.

Sounds easy

Any ideas out there

If I find a working solution I will post here.

Thanks

Tim