thanks for your reply :)

yes there is enough rows but not columns.. if I wanted to put all the
companies in one sheet it would be 5 (columns) x about 215 companies..
256 :(

Now the question is.. how to write the macro so it looks in all the
sheets? :S


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements