If formula copy data to another sheet

M

Mike

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to copy data in one sheet to another 8
Copy & paste range 0
summing data from a list 2
Match Command 1
If then formula with multiple cells 2
Formula to Find Latest Transaction Date and amount for a customer 6
I have a Table that I can't Sort--Final attempt for help 9
SUMIF/AND combination? 2

Top