| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Cell Value to another Sheet if...
On Sheet1 I have a column of account names and a column of dates of last vist
ie: abc company 6/1/2007 xwz corp 4/15/2007 exl inc. 2/12/2007 aaa corp 6/5/2007 bbb inc. 6/11/2007 What I want to do is if the date of last visit is equal to month(today()) then I want it to list all of those accounts seperated by a comma on sheet2. ie: abc company, aaa corp, bbb inc. Is that possible, if so how? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA to stop XL from adding the Path Sring to Sheet-to-Sheet Links | Excel Discussion (Misc queries) | |||
| Adding in a cell from one sheet to another | Excel Worksheet Functions | |||
| Excel, adding figures from one cell to a summary sheet or workbook | Excel Discussion (Misc queries) | |||
| Adding comments to unprotected cell in a protected sheet | Excel Discussion (Misc queries) | |||
| adding data from one sheet to another sheet as a dropdown list bo. | Excel Discussion (Misc queries) | |||
Threaded Mode
