Here you go, all ready and functioning:
http://www.freefilehosting.net/download/3bj2c
Checkbook_register2a.xls

In Payroll,
In B6, copied across/filled down:
=IF(ISERROR(SMALL(OFFSET('Check Register'!$K:$K,,MATCH(WSN,'Check
Register'!$L$4:$IV$4,0)),ROWS($1:1))),"",
INDEX('Check Register'!B:B,MATCH(SMALL(OFFSET('Check
Register'!$K:$K,,MATCH(WSN,'Check Register'!$L$4:$IV$4,0)),ROWS($1:1)),
OFFSET('Check Register'!$K:$K,,MATCH(WSN,'Check Register'!$L$4:$IV$4,0)),0)))

The sheet: Payroll is copied & renamed as: Expenses, Materials
to easily get the lines for the other 2 sheets.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---