View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Les Les is offline
external usenet poster
 
Posts: 240
Default Look down column and enter blank row and color grey

Hi all,

I have a sheet that is sorted by name in column "E". I need to go down this
column from row 11 till i get the next name, insert a blank row and color it
grey. then i need to total up the columns G, I, K, M, O & Q and insert the
totals in the inserted grey blank row at the bottom of the relevant columns.

Result : Sections Giving me the totals in each grey row for each person in
entire sheet.


Any help would be greatly appreciated...

--
Les