| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bottom Up search for multiple entries
Hi Hans,
Am Wed, 10 Oct 2012 07:37:42 -0700 (PDT) schrieb Hans Hamm: Want to look in sheet 3, row D... bottom up find each Program entry (there can be 10+ entries for the same program) Then copy those entries (program names) and past into sheet 2 starting with cell A5. try: Sheets("Sheet3").Columns("D:D").AdvancedFilter Action:=xlFilterCopy, _ CopyToRange:=Sheets("Sheet2").Range("A5"), Unique:=True Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using SEARCH in a single cell to COUNT multiple entries of same te | Excel Programming | |||
| Using SEARCH in a single cell to COUNT multiple entries of sam | Excel Programming | |||
| Using SEARCH in a single cell to COUNT multiple entries of same te | Excel Programming | |||
| Search Column - Find Multiple Entries - Sum Then Delete to Single Entry | Excel Programming | |||
| Search For Multiple Entries - Combine and Sum | Excel Programming | |||
Threaded Mode
