Add a Row in the Main Sheet and it appear in a subsheet to which it relates

[Biggsy2020]

Hi,

In the attached Spreadsheet I would like to split the Head Register, into separate sheets based on the text input in the "c" column. Every time I then add to the Head Register its also adds automatically to the sub sheet to which it applies.

Is this possible?

I have cleared the A column given the sensitive data

Many Thanks.

[Glenn Kennedy]

See sheet Telehandler:

=IFERROR(INDEX('Head Register'!A:A,AGGREGATE(15,6,ROW('Head Register'!$A$7:$A$150)/('Head Register'!$C$7:$C$150=Telehandler!$A$1),ROWS(A$4:A4))),"")

copied across and down. Adjust the bits in red, as needed. I have no idea why you introduced (what looks like) a break in the data at around row 154.

[Biggsy2020]

Amazing Thank you so much.

The formula doesn't appear to work after Yadda 110, is there a reason for this?

Many thanks for your help its much appreciated.

[Biggsy2020]

Sorry just noticed, adjusted the "red" and it works. Really Great Thank you.

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.