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.

Hi Kikkoman,

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

The use of If conditions is so ubiquitous that any site dealing with macros
should have examples.

Look, perhaps at David McRitchies Tutorial page at:

http://www.mvps.org/dmcritchie/excel....htm#tutorials


---
Regards,
Norman



"Kikkoman" wrote in message
...
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

Norman,

? ubiquitous

doesn't that carry an implicit negative connotation to it? I thought what
CADS!

--
Regards,
Tom Ogilvy

"Norman Jones" wrote in message
...
Hi Kikkoman,

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

The use of If conditions is so ubiquitous that any site dealing with
macros
should have examples.

Look, perhaps at David McRitchies Tutorial page at:

http://www.mvps.org/dmcritchie/excel....htm#tutorials


---
Regards,
Norman



"Kikkoman" wrote in message
...
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

Hi Tom,

doesn't that carry an implicit negative connotation to it?

No, not in my opion, though words such as 'common' are frequently used with
such implied significance. Certainly, I intended no such disparagement!

I thought what CADS!

LOL!

---
Regards,
Norman



"Tom Ogilvy" wrote in message
...
Norman,

? ubiquitous

doesn't that carry an implicit negative connotation to it? I thought
what
CADS!

--
Regards,
Tom Ogilvy

"Norman Jones" wrote in message
...
Hi Kikkoman,

I hv one further question regarding macro, is there a website on macro

with "if functions" ie, if ... then create roll (say)

The use of If conditions is so ubiquitous that any site dealing with
macros
should have examples.

Look, perhaps at David McRitchies Tutorial page at:

http://www.mvps.org/dmcritchie/excel....htm#tutorials


---
Regards,
Norman

Your absolutely correct.

Interestingly in most of the few dictionaries I queried, the example phrases
mostly seemed to be associated with a negative theme:

"plodded through the shadows fruitlessly like an ubiquitous spook" Joseph
Heller.

"the repetitiveness, the selfsameness, and the ubiquity of modern mass
culture" Theodor Adorno

In spite of the ubiquitous beggars, gypsies and 'naked urchins', Skopje was
an attractive town in the early part of the century.
--Anne Sebba, Mother Teresa: Beyond the Image

Airborne gambling, shopping and videoconferencing may all be ubiquitous in
the future.
--Peter H. Lewis, "The Cybercompanion," New York Times, February 7, 1999

Adding to my perplexity, this lack of clarity even appeared evident among
the best and brightest sociologists, historians, literary scholars, art
historians, those working in cultural studies, American Studies, and
journalism; the problem looked to be ubiquitous.
--Michael Kammen, American Culture, American Tastes

Maybe many things that are omnipresent are generally undesirable.

Anyway, guess I am not alone <g

--
Regards,
Tom Ogilvy


"Norman Jones" wrote in message
...
Hi Tom,

doesn't that carry an implicit negative connotation to it?

No, not in my opion, though words such as 'common' are frequently used
with
such implied significance. Certainly, I intended no such disparagement!

I thought what CADS!

LOL!

---
Regards,
Norman



"Tom Ogilvy" wrote in message
...
Norman,

? ubiquitous

doesn't that carry an implicit negative connotation to it? I thought
what
CADS!

--
Regards,
Tom Ogilvy

"Norman Jones" wrote in message
...
Hi Kikkoman,

I hv one further question regarding macro, is there a website on
macro

with "if functions" ie, if ... then create roll (say)

The use of If conditions is so ubiquitous that any site dealing with
macros
should have examples.

Look, perhaps at David McRitchies Tutorial page at:

http://www.mvps.org/dmcritchie/excel....htm#tutorials


---
Regards,
Norman

Hi Tom,

Thank you for the interesting quotes.

Slightly to redress the balance, the following quote comes from the IBM
Systems Journal http://www.research.ibm.com/journal/sj/404/marwick.html

'---------------------------------------
Today, of course, intranets and the Internet are ubiquitous, and we are
rapidly approaching the situation where all the written information needed
by a person to do his or her job is available on line. However, that is not
to say that it can be used effectively with the tools currently available.
'---------------------------------------
Given the source and context, one has to assume no pejorative intent.

Anyway, guess I am not alone <g

Not alone, except in ubiquitous pre-eminence!


---
Regards,
Norman


"Tom Ogilvy" wrote in message
...
Your absolutely correct.

Interestingly in most of the few dictionaries I queried, the example
phrases
mostly seemed to be associated with a negative theme:

"plodded through the shadows fruitlessly like an ubiquitous spook" Joseph
Heller.

"the repetitiveness, the selfsameness, and the ubiquity of modern mass
culture" Theodor Adorno

In spite of the ubiquitous beggars, gypsies and 'naked urchins', Skopje
was
an attractive town in the early part of the century.
--Anne Sebba, Mother Teresa: Beyond the Image

Airborne gambling, shopping and videoconferencing may all be ubiquitous in
the future.
--Peter H. Lewis, "The Cybercompanion," New York Times, February 7, 1999

Adding to my perplexity, this lack of clarity even appeared evident among
the best and brightest sociologists, historians, literary scholars, art
historians, those working in cultural studies, American Studies, and
journalism; the problem looked to be ubiquitous.
--Michael Kammen, American Culture, American Tastes

Maybe many things that are omnipresent are generally undesirable.

Anyway, guess I am not alone <g

--
Regards,
Tom Ogilvy