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. |
All times are GMT +1. The time now is 08:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com