Hello,

I have a Summary Sheet (Sheet 1 in the attached file), in which I want a row to be added for all cells that contain data in a range of cells on another sheet (Sheets 2-36).

I have attached a file that is color coded on Sheets 1 & 2. The range on Sheet 2 is O5:O11. Again if there is Data in 06 I want to copy it to add a row to sheet 1. If there is no data I do not want there to be a row. I would need this for all sheets.

This may be asking too much but is it possible to use conditional formatting to create a line after each page reference? If you take a look at sheet 1 the line would be before each new "phase" or "description".


THANK YOU!
Stanexcel help.xls