Dear Kiran,
You can use in VBA Version for Selection Range,
*Sub uppercase()
Dim abc As Range
For Each abc In Selection
abc.Value = VBA.UCase(abc)
Next
End Sub
*
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
Hi Jack,
Does cell B3 contain a formula or are you entering a value directly?
The Worksheet_Change event is triggered by changes that result from direct
entry.
The Worksheet_Calculate event is triggered by worksheet calculation. If
there is a formula in B3, it will never be the Target in
Hi guys,
thank you very much for your help.
You solved my problem and thank you for different posibilities from
which I can learn.
Best regards,
seba
On 10 nov., 18:21, Sam Mathai Chacko samde...@gmail.com wrote:
Two options try
If Not IsEmpty(Range(A1)) Then
Dear Experts,
Kindly find the attached sheet.
I want to only last date qty and stock in three sites.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem,
Either of these:
(1) Right-click, remove hyperlink in each cell.
(2) Highlight all cells, Copy (ctrl-c); then in another column, Paste
Special, Values (alt-e,s,v)
To prevent emails, URLs and UNC paths from automatically becoming hyperlinks
when entered/edited, change the AutoCorrect options:
Hi Neeraj,
This can be achieved with the use of Pivots.
Attached is the Solution.
Please let me know if you need any clarification.
Cheers,
Andy
On Fri, Nov 11, 2011 at 2:12 PM, Neeraj Chauhan
neerajchauhan...@gmail.comwrote:
Dear Experts,
** **
Kindly find the attached sheet.
Dear Neeraj,
Please try through below formula, See attached sheet..
=OFFSET($D$1,SMALL(IF($B$2:$B$24=$I2,ROW($D$2:$D$24),),COUNTIF($I$2:$I2,$I2))-1,0)
Press ctrl+shift+enter
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
Good one Noorain..
Can you help how this array works please..
Cheers,
Andy
On Fri, Nov 11, 2011 at 3:34 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Neeraj,
Please try through below formula, See attached sheet..
Yes that's the thing :)
Kim
--
FORUM RULES (934+ 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)
You can try Allow User To Edit Range Option.. Hope it will help..
On Fri, Nov 11, 2011 at 2:01 AM, dguillett1 dguille...@gmail.com wrote:
I should have been clearer. I meant to suggest they each have their own
FILE and then you have a macro to combine. If all in the same folder its
fairly
In this particular sample you can simply filter by date. However, that may not
be what you need in all cases??
Don Guillett
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Friday, November 11, 2011 4:04 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help
HI
Thanks Its Working thank you very much
On Fri, Nov 11, 2011 at 12:03 AM, chhajersand...@gmail.com wrote:
**
Please after copy, paste special it in un filtered data...(Use shortcut
alt d f s and then alt e s v tick @ skip blank)
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
Hi sam,
I Can use vlookup but i am having morethan 6000 blank rows if i use
vlookup up while dragging
some other rows data will change rite ?
Thanks
On Thu, Nov 10, 2011 at 10:44 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Not sure why you don't want a vlookup. Suggest using that, or
Should do it ALL. See attached
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Urghhh
Sent: Friday, November 11, 2011 4:43 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Combine data from multiple sheets, multiple hits
Yes that's the thing :)
Kim
--
FORUM
DEAR EXCEL MEMBERS ,
I WANT TO SUM OF SPECIFIED ROWS , HERE WITH I ATTACHED FILES. I.E STOCK ,
SALES.
THANKS WITH
--
J.Mohilal
Universal Computer Systems
# 16, Brindavan Complex
Otteri, Vellore-2
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread
Thanks for sending immediate answer. Thanks , Thanks ...
Mothilal.J
On Fri, Nov 11, 2011 at 8:30 PM, dguillett1 dguille...@gmail.com wrote:
Look in the help index for SUMIF
=SUMIF($D$2:$D$21,stock,$G$2:$G$21)
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* jmothilal
Dear Experts,
To make a Summary, i'm using indirect formula and need your help
advise to complete the same..
Here with enclosed the example along with the issue.
thank you.
Jp
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
I believe you can merge it like this
Private Sub Worksheet_Change(ByVal Target As Range)
Dim oPic As Picture
If Target.Address = B3 Then
Select Case Target.Value
Case Is = DSL-Cleaner
Rows(1:156).Hidden = False
Rows(157:208).Hidden
Dear JP,
Please find attached sheet, I hope it will help to u..
try..
=VLOOKUP($A2,INDIRECT($G$3!A:D),MATCH(B$1,AN!$A$1:$D$1,0),0)
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Can be done without CSE formula
Here's an example
Regards,
Sam
On Fri, Nov 11, 2011 at 6:52 PM, dguillett1 dguille...@gmail.com wrote:
In this particular sample you can simply filter by date. However, that
may not be what you need in all cases??
Don Guillett
SalesAid Software
Hello Noorie Sam;
Good ones, but as you know, If a site has LARGE date more than 1 (*not sure
does the OP have this situation or not*), this wouldn't work as
expected. I think the attached would work.
__
HTH
Haseeb
--
FORUM RULES (934+ members already BANNED for violation)
1)
Hello JP, Please do not post multiple thread for the same query.
In Summary B4, copy down across.
=LOOKUP(9E+300,INDIRECT('$A4'!B1:ADDRESS(2^20,COLUMNS($A4:B4
__
HTH
Haseeb
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
THANKS SO MUCH , ITS WORKING FINE GET THE RESULTS.
THANKS WITH
MOTHILAL.J
On Fri, Nov 11, 2011 at 10:31 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Mothilal,
try this one..
=SUMPRODUCT(--($D$2:$D$21=D22)*($E$2:$E$21))
On Fri, Nov 11, 2011 at 8:23 PM, jmothilal
Dear Mr. Modi,
Attached is the soln. pl chk if this is ok.
Regards,
Andy
On Sat, Nov 12, 2011 at 12:09 PM, L.K. Modi ca.mod...@gmail.com wrote:
Dear All members,
I am attaching herewith a file regarding tds and the requirement is
mention in that file related to subtotal and conditions.
PFA
Best Regards
Momin Siraj Ahmad
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of L.K. Modi
Sent: 12 November 2011 10:39 AM
To: excel-macros@googlegroups.com
Subject: [bulk] $$Excel-Macros$$ Query related to subtotal and condition
25 matches
Mail list logo