; simply use data>autofilter>copy. If that is correct, it is fairly
> easy to
> > > > write a macro to loop thru looking for X and then filter the data
> sheet
> > > by
> > > > that value and copy to the other sheets. Is that what you want?
> >
>
gt; Sub filterandcopy()
> > > 'for each c in activesheet.usedrange.specialcells(xlce
> > > For Each c In Range("b2:b21,f2:f21,j2,j21")
> > > If UCase(c) = "X" Then
> > > 'MsgBox c.Row
> > > End If
> > > Next c
>
lle...@gmail.com
>
>
>
> -Original Message-
> From: Monizri
> Sent: Saturday, October 08, 2011 2:56 PM
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ Read a menu and produce results
>
> awesome, here's a linkhttp://www.box.net/shared/o0uley3s
ri
Sent: Saturday, October 08, 2011 2:56 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Read a menu and produce results
awesome, here's a link
http://www.box.net/shared/o0uley3sbbh3fxu315ou
The tabs that say FHCX, FHMX, and FNMX are what i wanted the results
to be once the loop
I just attach to email. Send to me if you like.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Monizri
Sent: Saturday, October 08, 2011 2:27 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Read a menu and produce results
Thanks Don, I can
ter examples. I
> > would
> > > think that instead of using a loop you would use FIND (look in vba help)
>
> > > Don Guillett
> > > SalesAid Software
> > > dguille...@gmail.com
>
> > > -Original Message-
> > > From: Monizri
> >
D (look in vba help)
> >
> > Don Guillett
> > SalesAid Software
> > dguille...@gmail.com
> >
> >
> >
> >
> >
> >
> >
> > -Original Message-
> > From: Monizri
> > Sent: Saturday, October 08, 2011 9:01 AM
> &g
that instead of using a loop you would use FIND (look in vba help)
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
>
>
>
>
> -Original Message-
> From: Monizri
> Sent: Saturday, October 08, 2011 9:01 AM
> To: MS EXCEL AND
EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Read a menu and produce results
Hi Sam, I apologize for not being clear, i was sure how to pose the
question.
I have two spreadsheets. One with a menu with a bunch of criteria (of
which you can select the criteria you want by placing an "X&
Hi Sam, I apologize for not being clear, i was sure how to pose the
question.
I have two spreadsheets. One with a menu with a bunch of criteria (of
which you can select the criteria you want by placing an "X" in a
designated area ). The second spreadsheet will have data i need to
search through. So
I believe the forum is not able to comprehend what 'can i get excel to read
a menu with selections using "X" in a cell' is trying to convey. Maybe you
want to rephrase it, or share an example of what you are trying to do.
Sam
On Fri, Oct 7, 2011 at 10:55 PM, Monizri wrote:
> Hi, I have the foll
11 matches
Mail list logo
