Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data from one sheet to another using a formula | Excel Discussion (Misc queries) | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
Formula Help - Copy data from one sheet to another based on criter | Excel Worksheet Functions | |||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
With a formula copy data from one sheet to another | New Users to Excel |