Search results for query: *

Many thanks for your assistance! The only remaining issue is how to deal with blanck cells. At the moment if I have a coumn with a few blank cells, the formula with inset a semi colon for each blank cell in the final list. Is there any way to just have the semi colons added between text in...

I have a column of 80 cells. Most of the cells contain text but some are blank. I would like to merge the contents of these 80 cells into one cell. The text from each cell needs to seperated by a semi-colon in the merged cell. I would also like to ignore the blank cells. I have looked at...

Thanks again macropod - this is extemely helpful. Just one last question - the macro resets all the page breaks before inserting the horizontal breaks after each new locality. Is there anyway to maintain the vertical page breaks so they are not reset every time the macro is run? Many thanks

GlennUk and Macropod - many thanks for your answers. Macropod - I've tested your macro and I am very impressed! It works perfectly but I have just one remaining issue. The macro adds a page break whenever there is a change in value within the specified column but it also adds a page break if...

I am dealing with a large amount of data in Excel (5000 rows). Each row represents a person for which certain data is held (telephone, town, age, etc) I have sorted the data in ascending order by town and would now like to insert a page break after each town (so when I print I have a seperate...