Capture data

Would i need a macro for the follow problem or is there a fucntion

i have a sheet called capture that has 4 columns headed Time, Dog, Paddy, Betfair.

Each column will copy data from other sheets when a certain thing happens.

What i want it to do is when column 3 and 4 have a value larger than 0 is move to next row and start again and so on etc.

Any ideas?

You cannot do that using a function, however, it can also be done (somewhat) without a macro. If you protect your worksheet, and only unlock the cells in the 4 used columns, once you press the TAB key after column 4 it will automatically go to the next row.

Let me know if that helps.

Hi,

Does that mean i need to press tab key every time the cells are greater than 0.

ie once its cell in column c,d are greater than 0 i need to manually press tab and would this copy the formulas from above row??