I have a spreadsheet that has data from Columns A thru to K where th
number of records changes each time the user imports the data (in
named range called WIP_Area). In Column A each row has a ‘category
which can be one of the following Work in Progress, Incoming, On Hol
or Other Business, the data is sorted (via a custom list) in thi
order. I want to then insert a heading row at the start of eac
category that contains the category heading with a border and shadin
that covers columns A thru to K.

Does anyone know how I can easily find the start of each category t
then insert a row?

Thanks
Kare

--
ks
-----------------------------------------------------------------------
ksp's Profile: http://www.excelforum.com/member.php...nfo&userid=626
View this thread: http://www.excelforum.com/showthread.php?threadid=54928