Hi Eduardo,
Sheet1 is named 'Transaction Database...
Data starts in C5.
C5 is the transaction number
C6 is the status of a transaction Open,Pending,Closed,Withdrawn or Expired.
C7 is Sellers Name
C8 is Buyers Name
C9 is Listing Date
C10 is Agents Name
etc...
Column D would be say Transaction #2
Column E would be Transaction #3
and so on...

Hope this helps!

"Eduardo" wrote:

Hi Mike, I don't understand something,
1) Sheet 1 is named Transaction Database??,
2) if Data starts in C5, as per below why sheet1 cell c6 = open
3) could you send an example just a few # to make sense, thank you

"Mike" wrote:

Hi Eduardo,

The Formula is:
=IF('Transaction Database'!C$6="open",'Transaction Database'!C5,"")
I enter it in cell C5 and copy/paste down the column to C59 then copy/paste
C5:C59 to all columns...
The formula in each sheet is changed for "Open to Pending, Closed,
Withdrawn, Expired for each coresponding sheet

"Eduardo" wrote:

Hi Mike,
Sorry I misunderstood you, just a question when you say you have entered the
formula, where have you enter it, is that a formula in a cell or a code, if
that is part of a code could you please post your code

"Mike" wrote:

Hi Eduardo,

Sorry, I don't understand your response...

The formula I included in my question is in the 5 seperate sheets titled
Open, Pending, Closed, Withdrawn, Expired. They all pull the files from the
files in Sheet1 titled 'Transaction Database'. But, lets say the file in
sheet 1 column F5:59 has Open in F5 the the formula in the 'Open' sheet pulls
the data into the 'Open' sheet, column F5:59 and leaves C and D blank.
I need it to go to column C or the first available column.

Sorry if I don't understand or if I am not explaining myself properly...







"Eduardo" wrote:

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