5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
On Sun, Feb 5, 2012 at 2:05 AM, Hemant wrote:
>
> Good way to make some additional money.
> http://hidayeterkan.com/home.work.php?gugmailID=a7et9
>
> --
> FORUM RULES (986+ members already BANNED
Dear Team,
Please forward excel test file for basic & advance level, if anybody have it.
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intend
Dear Team,
Does any have excel training ppt or module for Basic & Advance. If yes, please
forward it with sample file.
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged info
Dear sam,
Thanks for your valuable Advice
Regards
chandru
On Tue, Feb 7, 2012 at 12:22 AM, Sam Mathai Chacko wrote:
> There is no object model in Excel which tests the use of subtotal in a
> worksheet/range.
>
> The closest you could get is to look whether the used range has something
> li
Hi Asa and Sam
Thanks for all the info. It will take me a couple of days to comprehend it
all and then I will get back to you.
I really appreciate your help
Regards
Charlie
On Tue, Feb 7, 2012 at 12:10 PM, Asa Rossoff wrote:
> Hi Charlie,
>
> I don't have a lot of practicle experience i
del cell
bel cell del
cell bel del
cell ell llec
blood consist of red cell and white cell
simos is a cell
max cell
sony cell
a cell is a source of energy for some electronic devices and stands as a
two way power.
Above mentioned lines are having the word "cell" in common,
Hi Muneer
The original attachment is not at all clear. Neither Don nor I have the
faintest idea what you want. Could you send another attachments with added
the result you want where you want it? I.e just fill in the shaded cells
(if that is where the result goes) with the values you would expe
Sorry Don, please check the attachment its very clear in it.
Regards,
Muneer,
CC...
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1
Sent: Monday, February 06, 2012 6:56 PM
To: excel-macros@googlegro
Wow, thanks Sam. When I was trying this myself, I started down this
approach and couldn't make it work. Thanks for the lesson.
John
On Mon, Feb 6, 2012 at 3:06 PM, Sam Mathai Chacko wrote:
> If your rows go in to the thousands, using autofilter will add a bit more
> (~40%) efficiency
>
> Sub
Hi Charlie,
I don't have a lot of practicle experience in all areas of Excel, so I just
realized there is an easier way to link controls to the worksheet!
Simply use the ControlSource property of the control and provide a cell
reference or named range. See
http://www.ozgrid.com/Excel/free-tra
Nice
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Monday, February 06, 2012 2:06 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need A Macro To Move Rows
If your rows go in to the thousands, using autofilter will add a bit more
(~40%)
As many of you know, I adhere to the KISS principle and rarely use all of these
forms or a lot of CF. I prefer to have a macro do the work. In fact, on many
projects I do not even use visible formulas. I also like to breakup vlookups,
etc into meaningful blocks instead of entire columns. ie: Ins
Your use of the CHOOSE formula here is absolutely obsolete.
Having CHOOSE({1,2},RATESHEET!$B$6:$B$9,RATESHEET!$C$6:$C$9) is equivalent
to simply using RATESHEET!$B$6:$C$9
Instead, you could have passed the column number dynamically by looking
were the CR COIL is located. For this you could have m
Thanks Sam.you guys are genius. VEry grateful
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Sam Mathai Chacko
Sender: excel-macros@googlegroups.com
Date: Tue, 7 Feb 2012 00:40:37
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Your txtavgto1.Value in form 2 is empty during execution of the form
initialize event. I have just added a conditional statement to work around
the error.
Now, your objective is not clear. So you might want to rephrase.
Second, I am of the same opinion as Don. It seems you have generated an
obses
The text can be formatted by having the space *within* the format
=CHOOSE(A1,C2,C3,C4,C5)&TEXT(C10/I1," 0,0.00")
or using Don's suggestion
=INDEX(C2:C5,MATCH(D12,D2:D5))&TEXT(C13/INDEX(E2:E5,MATCH(D12,D2:D5)),"
0,0.00")
Regards,
Sam Mathai Chacko
On Mon, Feb 6, 2012 at 10:31 PM, wrote:
HEre's a discussion on this topic. Scroll down to a little over the half
way mark, and you should find a few probable solutions. One was about
deleting the pdfmaker file (do you have that?). Second was about changing
some setting in Excel. Either way, I haven't faced this myself, so no
solutions fr
There is no object model in Excel which tests the use of subtotal in a
worksheet/range.
The closest you could get is to look whether the used range has something
like an =SUBTOTAL(*) somewhere, and then use the code that I suggested
below. But that would then not be fool proof. The possibility tha
Hi sam,
If Subtotal method is there than only remove subtotal works , in that
case whether subtotal paticular sheet is there or not if subototal method
is there i will use below code will work.if not thereby pass
remove subtotal then subtotal commant will work this my query
chandru
A more appropriate event for this case would be the Exit event. You can
just type in your number, for example 3 and hit the ENTER key. And
generally speaking, the lesser the lines, the more efficient the code.
Private Sub TextBox8_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox5.Value
To keep it shorter, and more efficient, one could write
Sub ClearSubTotal()
ActiveSheet.UsedRange.RemoveSubtotal
End Sub
Regards,
Sam Mathai Chacko
On Mon, Feb 6, 2012 at 2:16 PM, Maries wrote:
> Hi,
> **
> *Try this code:*
> **
> Sub Macro1()
> Cells.Select
> Selection.RemoveSu
Thanks boss
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: "dguillett1"
Sender: excel-macros@googlegroups.com
Date: Mon, 6 Feb 2012 09:50:15
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM
See attached
Don
Dear Raghu,
You can use..
=VLOOKUP($G$2,CHOOSE({1,2},RATESHEET!$B$6:$B$9,RATESHEET!$C$6:$C$9),2,0)
See attached sheet..
On Sat, Feb 4, 2012 at 12:02 AM, raghu gr wrote:
> Hi experts,
>
> I have a invoice file and summary file, i want the formula in rate column,
> which has to pick from rate
Thank you sir, its working
with regards
raghu
On Mon, Feb 6, 2012 at 8:20 PM, The Viper wrote:
> check the attachment and go to rate sheet
>
>
> On Sun, Feb 5, 2012 at 2:13 PM, raghu gr wrote:
>
>> hi,
>>
>> Thanks a lot sir,
>>
>> For the same type of file i tried to write formula in the atta
I’m confused. Start over with a better explanation and before/after examples
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Monday, February 06, 2012 8:08 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Extract the single word called "cell" from
Glad to help
Don Guillett
SalesAid Software
dguille...@gmail.com
From: John A. Smith
Sent: Monday, February 06, 2012 9:11 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need A Macro To Move Rows
Thanks again for your assistance Don, your help is very much appreciated.
John
Thanks again for your assistance Don, your help is very much appreciated.
John
On Mon, Feb 6, 2012 at 10:03 AM, dguillett1 wrote:
> Place in a module and save the file as macro enabled. xls or .xlsM
> ‘==
> Option Explicit
> Sub lineemupSAS()
> Dim i As Long
> Application.ScreenUpdati
Place in a module and save the file as macro enabled. xls or .xlsM
‘==
Option Explicit
Sub lineemupSAS()
Dim i As Long
Application.ScreenUpdating = False
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -2
Cells(i, 1).Resize(, 10).Copy Cells(i - 1, "K")
Rows(i).Delete
Next i
Columns
thank you so much
On Mon, Feb 6, 2012 at 7:04 PM, dguillett1 wrote:
> Your macro worked on sheet 1 because you were on sheet 1 and didn’t
> work on sheet 2 because your with did not have the necessary dots.
> with sheet2
> .do it
> .do that
> .do anoither
> end with
>
> Don Guillett
> SalesAi
Regards,
Muneer,
CC...
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don
Your life would be simpler if you designed withOUT all of these userforms, etc.
KISS
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Shankar Bheema
Sent: Sunday, February 05, 2012 10:59 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ datediff doubt
Dear Experts,
I pl
Your macro worked on sheet 1 because you were on sheet 1 and didn’t work on
sheet 2 because your with did not have the necessary dots.
with sheet2
.do it
.do that
.do anoither
end with
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Shankar Bheema
Sent: Sunday, February 05, 2012 10:50
Glad to help
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Somnath Khadilkar
Sent: Sunday, February 05, 2012 8:43 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a small MACRO to SPLIT
Many thanks Don Guillett Sir,
You hv done
Dear Friends,
I am using excel 2007 and my files are not opening in the first attempt if
i minimize the window and maximize or right click inside open or new then
once the contents will show. Please let me know how can i rectify the error.
--
Thanks & Regards,
Mohamed Idhrees. S.
--
FORUM RUL
Kindly check below links
http://www.techonthenet.com/excel/formulas/index_function.php
http://dmcritchie.mvps.org/excel/vlookup.htm
http://www.ozgrid.com/Excel/left-lookup.htm
On Mon, Feb 6, 2012 at 3:33 PM, Jai wrote:
> Dear Excel Group Member,
>
>
> Please give the some example of index fun
Dear Excel Group Member,
Please give the some example of index function & Match Function & how can
use both function in combined.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formu
Hi charlie,
Got it.
Ok, the error is just indicating that the vlookup failed to find the Part#.
It failed for at least two reasons: (1) The VLookup is in the Change event,
which fires after every change, such as after each keypress - -so the whole
part# was probably not entered yet, and (2) The v
Hi,
**
*Try this code:*
**
Sub Macro1()
Cells.Select
Selection.RemoveSubtotal
End Sub
Regards,
MARIES.
On Mon, Feb 6, 2012 at 11:37 AM, chandra sekaran wrote:
> HI ALL
>
> I have write small macro , i want revmove subtotal if Active sheet
> subtotal method is there
>
>
>
> Sub Macr
38 matches
Mail list logo
