I am setting up a simple accounts workbook

I have one sheet with 11 column headings and as each transaction is
allocated to a department

I then have a worksheet for each department -

I am trying to get it so that when an entry is made in the main sheet it
also appears in the department sheet also

I have used the following formulas but now the main sheet has passed Row 31
the data is not being picked up on the dpartment sheets

In Cell B6 on the dept sheet

=IF($A$6="","",IF(Summary!B6=A$6,ROW(),""))


In Cell C6 and then copied across the Columns

=IF(ROWS($5:5)COUNT($B:$B),"",INDEX(Summary!A:A,S MALL($B:$B,ROWS($5:5))))

I would appreciate any assistance

thanks

--
JohnM