Hi We keep track of expenses on a simple spreadsheet and I have managed to copy data to a second sheet ie monthly totals, which is very helpful. I now want about 4 or 5 cells of data to appear in a second sheet but only when a certain cell has data in it.
To explain my self better. When i have a certain category of expenditure (For us it will be the costs of renvating a house) i need it to automatically appear on the second sheet with out any blank rows so that I can analyse this expenditure data further.

Hope that is clear and thank you in advance for your help