Thanks Norman, got it to good and managed to create a macro to automate the
whole thing... the website was brilliant...thanks v. much.

I hv one further question regarding macro, is there a website on macro with
"if functions" ie, if ... then create roll (say)


"Norman Jones" wrote:

Hi Kikkoman,

Consider using Excel's intrinsic Advanced Filter feature to copy data from
the ALL sheet to the Open and Closed sheets. To copy extracted data to
another sheet, it is necessary to invoke the filter from the destination
sheet.

If you are not familiar with the intricacies of the Advanced Filter
feature, you may wish to visit Debra Dalgleish's AF tutorial pages at:

http://www.contextures.com/xladvfilter01.html

If you wish to automate the data extraction, turn on the macro recorder
while you perform the operation manually. This should provide you with base
code that can be adapted for generic use.

If you experience any problems with your code, post back with details.

---
Regards,
Norman



"Kikkoman" wrote in message
...
i have a wksheet with 3 tabs - All, Open & Closed

In Column G of "ALL" tab, it shows the status of either Open or closed
I will change the status in the ALL tab from Open to closed or v/v.

I want to run a macro so that all open items are automatically copied
(whole
roll)into the Open tab and closed items to Closed tab.