i need a bit of clarification with this please:
i need to select col A:B on sheet "Breakdown"
if A:B empty then insert col C from sheet "Data" into A (leaving B
empty)
but, if there's data in A:B, insert 2 columns and move A:B to the right
(so now the data from a:b will be c:d) and insert col C from sheet
"Data"
thanks!
------------------------------------------------
~~ 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