Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas over multiple cells
I am trying to create a "smart" invoice. I am exporting my journal entries out of Outlook 2007 to a Tab delimited file. I am importing this data into a tab in Excel called "Invoice Details". I have another tab in Excel called "Invoice". I am wanting combine all the data for a single date on the "Invoice Details" tab to a single row on the "Invoice" tab. For example on the Invoice Details Tab I have two entries for 11/26/2009: Description Date Time Phone Calls 11/26/2009 60 Documentation 11/26/2009 300 I want this to show up on the Invoice tab in a single row such as: Description Date Time Phone Calls; Documentation 11/26/2009 360 Is it possible to create a formula to do something like this. I realize it will probably be three formulas as this data is kept in three different columns. Thanks for any advice. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple IF's Using Formulas from Other Cells | Excel Worksheet Functions | |||
If formulas with multiple cells??? | Excel Discussion (Misc queries) | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
"If, Then" Formulas for multiple cells | Excel Worksheet Functions | |||
macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) |