Maybe you could do something different.

Keep the data, but hide it--if the value of the cell is the same as the one
right above, make the font color match the fill color (white on white).

It might make it easier to other things (like data|filter|Autofilter and
sorting).

If you want to try, take a look at Debra Dalgleish's site:
http://contextures.com/xlCondFormat03.html#Duplicate

Tasmania wrote:

I have one excel sheet1 look like the following:

UserName Location Division Software Name Version

Maria.Sigmu Parkade Probation Adobe Reader 7.0
Maria.Sigmu 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 8.1

I want to create sheet 2 using Excel Macro in the following
format:

UserName Location Division Software Name Version

Maria.Sigmu Parkade Probation Adobe Reader 7.0
Lotus Notes 6.55
Eric.Bell Parkade IT WebFldrs 1.0
Adobe Reader 7.0
Symantec 8.1

I am a novice user in Excel VBA. I greatly appreciate any help.

--
thadi

--

Dave Peterson