add a column called Site, and put the site identifier on every row. That's
the only way to keep them together for analysis. If you want a divider row,
have a blank row with just the site name on it.

"sd" wrote:


I'm keeping information regarding work sites in rows in a spreadsheet. The
information contains data & formula. There may be multiple rows per work
site. Rows belonging to a particular site are kept together, and sites are
seperated by a colored divider row.There is also a header row. Each week a
new divider row is made & several rows about a particular site is added.
Therefore, the sites are grouped as a result of the way the information is
added, not by use of any features of Excel.

The problem is, when the sheet is sorted all the divider rows group
together, & if the sheet is saved that way its a pain to put right.Also, if
information is added out of sequence it has to be inserted into the correct
place, rather than added at the end & sorted by the sheet.

My questions a

1) What would be the best way to format the worksheet so that the groups of
information are apparent, yet the sheet is sortable & formatting is easily
maintained?

2) Is it a bad practice to use divider rows in this manner? If so, what is
a better way?

Thanks for any help!
SD