If formula copy data to another sheet
 

Sheet1 'Transaction Database' stores all transactions in column format.
Sheet1 Cell Row 6 Column C, D, E, F, G etc. equals Open, Pending, Closed,
Withdrawn, Expired. There is a seperate sheet for each and titled
according...

I am using this formula to move the type of transaction to the appropriate
sheet
=IF('Transaction Database'!C$6="open",'Transaction Database'!C5,"") The only
thing that changes is "Open" Pending" "Closed" "Withdrawn" "Expired"...

My problem is, the type of transaction is copied to the appropriate sheet
but in the same column as it is in sheet1. I need the transaction to copie
to the first available column from column C on...

Is this possible???