Question 1

How to copy every 2 lines of data to a new sheet when the conditions
meet. i.e. from sheet1 to sheet2.
Sheet 1 holds the overall data and Sheet 2 will contains the filtered
data only.
The conditions are when cell value col2=5 and col38=178 in Sheet 1,the
current row and the row below will be copy to Sheet 2. This will loop
through Sheet 1 from top down.

Question 2
How to delete all worksheets through VBA starting with name like
Order1,Order2, .......until Order150 in one go, keeping only
MasterOrder Sheet in the workbook. It is very tedious to delete
manually.

Thanks & Regards



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