Hi Guys,

I have a spreadsheet with multiple sheets...

Basically it's a register recording employee days off.
What I need is, when a cell drop-down is selected yes under off day and days are filled in next to it, I need it to populate a table(register) on another sheet with the name, Surname, Days off etc.
The register must not have blanks.

Example. Only row 5 and 14 have days off, They must populate Row 2 and 3 of the register, under the heading.

The spreadsheet has multiple calculations like IF functions, Arrays etc. but Its just the register that I can't get right.

What would I need to do?

Thanx