Sheet1 'Transaction Database' stores all transactions by column from row 5
to row 59.
Sheet1 Cell Row 6 Column C, D, E, F, G etc. is the type of
transaction--Open, Pending, Closed, Withdrawn, Expired.
Then I have a seperate sheet for each titled--Open, Pending, Closed,
Withdrawn, Expired.

I have entered this formula in each sheet--Open, Pending, Closed, Withdrawn,
Expired-- to move the type of transaction from sheet1 'Transaction Database'
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 copy
to the first available column from column C on in each sheet.

Is this possible???