Use application.enableCancelKey false at the top of module and true
at the end of module
On 09/10/2011, hanumant shinde wrote:
> Hi Paul,
>
> this is superb i never knew this thing. never even thought this might be
> happening.
> thanks for sharing it.
>
>
>
>
>>
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 wrote:
> http://www.
I take back my comment earlier, this code works great thank you!
On Oct 8, 4:51 pm, Sam Mathai Chacko wrote:
> Try this. Code with file attached.
>
> Sub Consolidator()
>
> Dim rngCell As Range
> Dim wks As Worksheet
>
> Application.ScreenUpdating = False
> For Each rngCell In Work
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" wrote:
> After looking at your file on the link p
After looking at your file on the link provided it seems that you want to
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?
Sub fil
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 tr
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 wrote:
> Just go to your gmail inbox, and repl
Hi Paul,
this is superb i never knew this thing. never even thought this might be
happening.
thanks for sharing it.
>
>From: Paul Schreiner
>To: excel-macros@googlegroups.com
>Sent: Friday, 7 October 2011 4:05 PM
>Subject: Re: $$Excel-Macros$$ A macro pauses e
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 wrote:
> Thanks Don, I can try FIND instead of looping, i am trying to add my
> file but i don't see anywhe
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" wrote:
> It would be helpful to post your files with before/after examples. I would
> think that instead of using
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 o
I suggest simply selecting your name cells in col B>data>text to
columns>space>finish
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
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 EX
check the attachment
On Sat, Oct 8, 2011 at 3:07 PM, Nemi Gandhi wrote:
> Plaease provide solution.
>
> --
> Nemi Gandhi
> 98204 92963
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER
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 @ htt
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 hope u are able to access the link so you can see the example in the Grade
9 schedule regarding the stats I want to generate in the Grade 8 schedule
--
--
Some important links for excel users:
1. Follow us on TWITT
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
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:=xlPar
19 matches
Mail list logo