Hi Mike,
try

'Copy information in the new Tab
Worksheets(Your Sheet).Select
Set ws1 = Worksheets(Your Sheet)

'find first empty row in database starting column C
With ws1
iRow1 = .Cells(.Rows.Count, 3).End(xlUp).Offset(1, 0).Row

"Mike" wrote:

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???