Have an exisiting line on a worksheet that has a cell that identifie
that it is a combination of lines

Know the logic behind the combine ie if Combine should be individua
line for Dept X, Dept Y and Dept Z

Want to know how I can extract this data onto another worksheet.

Might be best to show an example:-

Example Line on exising worksheet
Date Account Number Combine

Output required

Date Account Number Dept X
Date Account Number Dept Y
Date Account Number Dept Z

Any ideas on the code to do this

--
Balthasar
-----------------------------------------------------------------------
Balthasar G's Profile: http://www.excelforum.com/member.php...fo&userid=3726
View this thread: http://www.excelforum.com/showthread.php?threadid=57212