okie dokie. the short answer is: yes, it can be done via code.

the long answer is: yes, it can be done, but it's going to be very
complicated. it's going to require the coding to loop through each
device name grouping (rows 7-50) & look for duplicates. then it's
going to have to make the value of those duplicates a variable, erase
the formulas, color the duplicates, remove the lines between (so it
looks like it's one cell), & enter the variable in the center cell.
(trust me, you don't want to merge them all because then you'd have to
unmerge them before you could go to the next rack group.)

then, after you've got it looking so nice & wonderful, you're going to
have to have a combobox_change code attached to the rack group
dropdown that will UNDO everything you've just done above, including
repopulating the cells with the correct formulas, BEFORE it tries to
load a new rack group.

of course, although my codings work, i have a horrible habit of making
things much more complicated than they need to be! so it would take
quite some time to work this all out, and then pass it into the
excel.programming newsgroup to see how it can be shortened up.

you might try starting a new thread in the .programming group &
perhaps somebody more experienced than i will have a (better)
suggestion.
:)
susan



On Jul 10, 10:11 am, Susan wrote:
i got it...... reviewing........ NOW i understand what you mean.
thinking about it.
:)
susan

On Jul 10, 9:00 am, SteveMax
wrote:



File sent...let me know if there are any problems with the conversion.

Thanks,
Steve

"Susan" wrote:
well, i'm one of those kinesthetic "hands-on" learners, & i can't
visualize what you're trying to describe. although i'm sure you're
saying it perfectly understandably!
i'd be happy to take a look at it via e-mail, but i don't have excel
07 (have 2k). send it if you wish.
:)
susan

<clipped text