Hi
Try:
Sub Mtest()
Dim found As Range
Dim m As String, Temp As String
Dim count As Integer
Dim ws As Worksheet
count = 0
m = InputBox(prompt:=Enter value for search, Title:=Excel Find)
For Each ws In ActiveWorkbook.Worksheets
Set found = ws.Cells.Find(What:=m, LookIn:=xlValues, lookat:=xlPart)
People working on this solution must remember I paste this solution in the
schedules of the other classes in Grade 8 as well.Unless I can paste all the
schedules for the different Grade 8 classes together and get all the stats
for all the classes at one go
--
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
Plaease provide solution.
--
Nemi Gandhi
98204 92963
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
check the attachment
On Sat, Oct 8, 2011 at 3:07 PM, Nemi Gandhi nemigan...@gmail.com wrote:
Plaease provide solution.
--
Nemi Gandhi
98204 92963
--
--
Some important links for excel users:
1. Follow us
It would be helpful to post your files with before/after 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
Sent: Saturday, October 08, 2011 9:01 AM
To: MS
I suggest simply selecting your name cells in col Bdatatext to
columnsspacefinish
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Nemi Gandhi
Sent: Saturday, October 08, 2011 4:37 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Querry ncg
Plaease provide solution.
http://www.box.net/shared/et0q8my9qpvjefeciryx
HI
This is the link to the Grade 8 file for which I want stats to be worked out
like the Grade 9 schedule
--
--
Some important links for excel users:
1. Follow us
Thanks Don, I can try FIND instead of looping, i am trying to add my
file but i don't see anywhere i can attach my file. Do you know where?
Tx
Matt
On Oct 8, 11:47 am, dguillett1 dguille...@gmail.com wrote:
It would be helpful to post your files with before/after examples. I would
think that
Just go to your gmail inbox, and reply to the mail.
OR
Go to box.net, and you can upload your file there, and provide a link here.
Regards,
Sam
On Sun, Oct 9, 2011 at 12:57 AM, Monizri moni...@gmail.com wrote:
Thanks Don, I can try FIND instead of looping, i am trying to add my
file but i
Hi Paul,
this is superb i never knew this thing. never even thought this might be
happening.
thanks for sharing it.
From: Paul Schreiner schreiner_p...@att.net
To: excel-macros@googlegroups.com
Sent: Friday, 7 October 2011 4:05 PM
Subject: Re:
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 happened...
any ideas for code or logic i can use?
On Oct 8, 3:29 pm, Sam Mathai Chacko samde...@gmail.com wrote:
Just go to your
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
After looking at your file on the link provided it seems that you want to
simply use dataautofiltercopy. 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?
Sub
The autofilter can be an alternative. Is it possible get the loop to
read into the second bit of code where it has FHCX and spit out
code that way? Thats where ive been racking my brain.
I do appreciate this Don
On Oct 8, 4:29 pm, dguillett1 dguille...@gmail.com wrote:
After looking at your
I take back my comment earlier, this code works great thank you!
On Oct 8, 4:51 pm, Sam Mathai Chacko samde...@gmail.com wrote:
Try this. Code with file attached.
Sub Consolidator()
Dim rngCell As Range
Dim wks As Worksheet
Application.ScreenUpdating = False
For Each
Hi
I just had a query from someone asking me if I want the stats worked out
from the SCHEDULE sheet of the Grade 8 file, yes that is correct as that
sheet contains all the codes per subject /learning area for each
student/learner
On Sat, Oct 8, 2011 at 5:51 PM, shaneallen
Use application.enableCancelKey false at the top of module and true
at the end of module
On 09/10/2011, hanumant shinde arsfan2...@yahoo.co.in wrote:
Hi Paul,
this is superb i never knew this thing. never even thought this might be
happening.
thanks for sharing it.
18 matches
Mail list logo