[mso] Re: Combining Excel Data

I'm not sure I completely understand what you are asking, Leeba...can't you
just use an autofilter>custom>greater than 0 to produce what you want?

Click inside the row that has your column headings...go to
Data>Filter>Autofilter...this adds dropdowns to the top of every
column...click on the one for the attendees column and choose "Custom"....in
there  choose "is greater than" in the box on the left and type a 0 in the
box on the right 

Then if you want to produce a new page that just includes these...after
you've applied this filter, go to Edit>Go To>Special>Visible Cells Only and
this will select just the cells that are visible....copy them and paste them
in a new sheet or workbook


Linda
Linda's Computer Stop
http://personal-computer-tutor.com
ABC Free Ezine ~ Free Ebooks and Tutorials
*all outgoing mail scanned by Norton AV.  If you got a bug that looks like
it came from me, it did NOT!

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of LeebaF@xxxxxxxxxxx
Sent: Monday, May 24, 2004 5:36 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Combining Excel Data

Sorry I have been bothering everybody. Lately I feel like i am marrying off
my son for all the work that i am doing for my boss's son's wedding. (My son
is a 1.5 years old lol).
 
Now my problem is; i have the invitation list divided into seperate sheets
by category. I want to make one list of the people that are coming. (that
the attendees column is not 0). How can i program it to copy the cells of
the Last name, First name, and table. I am not writing the exact column
names as they are in Hebrew. Please write for the general names that i said.
thanks in advance
Leeba


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: