| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
List a group of repeated data from sheet1 to sheet2 but not repeat
--
thadi I have one excel sheet1 look like the following. UserName Location Division Software Name Version Maria.Sigmund Parkade Probation Adobe Reader 7.0 Maria.Sigmund Parkade Probation Lotus Notes 6.5.5 Eric.Bell Parkade IT WebFldrs 1.0 Eric.Bell Parkade IT Adobe Reader 7.0 Eric.Bell Parkade IT Symantec AntiVirus 8.1 I want to modify this sheet1 to sheet 2 using Excel Macro in the following format: UserName Location Division Software Name Version Maria.Sigmund Parkade Probation Adobe Reader 7.0 Lotus Notes 6.55 Eric.Bell Parkade IT WebFldrs 1.0 Adobe Reader 7.0 Symantec AntiVirus 8.1 I am a novice user in Excel Macro. I greatly appreciate any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic Update of Dropdown List Box data | Excel Worksheet Functions | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Looking for comparable data records between Sheet1 and Sheet2 | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
