One way - Select all your data and use Data / Subtotals - Hide the detail
and show just the summaries. Select all, do Edit / Go to / special /
visible cells only, then copy and paste into another sheet.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"stuart" wrote in message
...
i have several rows that have the same data, e.g code & name. one of the
columns is a number, which is different for each row. I want to merge all
the rows into 1 but i want the number field to be the total.

Can I do this?

stuart.