David
>
> On Saturday, December 23, 2017 at 1:39:57 AM UTC-8, Aamir Shahzad wrote:
>>
>> Friends,
>>
>> I want to concatenate all below data in one cell without any space.
>> Formula please.
>>
>> data
>> 148351, 183776, 032290,
>>
>&
As I couldn't got the answer so far so please resolve the attached query.
On Sun, Dec 24, 2017 at 4:57 AM, who wrote:
> Use the Trim function. Thanks, David
>
> On Saturday, December 23, 2017 at 1:39:57 AM UTC-8, Aamir Shahzad wrote:
>>
>> Friends,
>>
>> I
-Dec-2017 3:09 PM, "Aamir Shahzad" wrote:
>
>> Friends,
>>
>> I want to concatenate all below data in one cell without any space.
>> Formula please.
>>
>> data
>> 148351, 183776, 032290,
>>
>> result
>> 148351,183776,032290
>>
Friends,
I want to concatenate all below data in one cell without any space. Formula
please.
data
148351, 183776, 032290,
result
148351,183776,032290
Regards,
Aamir Shahzad
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official
ead of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
Dear Friends,
If we have name list & want to use the custom auto filter e.g. filter the
data name start from D to start from S. How?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebo
...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
Regards,
Aamir Shahzad
--
Are you =EXP(E:R
g is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Googl
not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
ny loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to
ss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this gro
yrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA
Hi,
This is Aamir Shahzad from Pakistan, working in Bank as MIS officer, work
in excel and learning of advance excel formulas by books & this forum. I
intended to learn Macros after expert in formulas.
what streamline should I follow? any idea?
On Thu, Sep 26, 2013 at 1:02 AM, Vas
e Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://
gt;
>
> On Fri, Mar 8, 2013 at 4:47 PM, Aamir Shahzad wrote:
>
>> Dear Sir, error is reflecting. Please see
>>
>> On Fri, Mar 8, 2013 at 3:34 PM, NOORAIN ANSARI
>> wrote:
>>
>>> Dear Aamir,
>>>
>>> Please Press Atl+F11, goto Module
Dear Sir, error is reflecting. Please see
On Fri, Mar 8, 2013 at 3:34 PM, NOORAIN ANSARI wrote:
> Dear Aamir,
>
> Please Press Atl+F11, goto Module and paste it then press F5 to run macro.
>
>
>
>
>
> On Fri, Mar 8, 2013 at 2:37 PM, Aamir Shahzad wrote:
>
>>
nt to pay.
> Have a google for PDF to Excel convertor, or for OCR program.
>
> On 08/03/2013, Aamir Shahzad wrote:
> > Dear group,
> >
> > Is there any way to convert the PDF file to excel by MACRO.
> >
> > Regards,
> > Aamir Shahzad
> >
> >
;%x")
> Next intC
>
> 'Close Adobe File and Window
> SendKeys ("^w"), True
>
> 'Empty Object Variables
> Set appAA = Nothing: Set docPDF = Nothing
>
> 'Select First Cell
> Range("A1").Select
> End Sub
>
> also weblink
Dear group,
Is there any way to convert the PDF file to excel by MACRO.
Regards,
Aamir Shahzad
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1
ost a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowe
>>
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread
thanks
On Wed, Feb 27, 2013 at 3:53 PM, ravinder negi wrote:
> There are two files attached for solution. First one is normal Excel
> file and other one is Addins file.
>
> --- On *Wed, 2/27/13, Aamir Shahzad * wrote:
>
>
> From: Aamir Shahzad
> Subject: $$Excel-Macros
Thanks you Gawli Anil, it's working nice
On Wed, Feb 27, 2013 at 1:50 PM, अनिल नारायण गवली
wrote:
> Dear Amir,
>
> Pl find enclosed herewith .
>
> Warm Regards,
> Gawli Anil
>
> On Wed, Feb 27, 2013 at 1:43 PM, Aamir Shahzad
> wrote:
>
>> Hi Group,
&
Thank you very much Noorain Sir.
On Wed, Feb 27, 2013 at 1:50 PM, अनिल नारायण गवली
wrote:
> Dear Amir,
>
> Pl find enclosed herewith .
>
> Warm Regards,
> Gawli Anil
>
> On Wed, Feb 27, 2013 at 1:43 PM, Aamir Shahzad
> wrote:
>
>> Hi Group,
>> I need
Hi Group,
I need the Macro, when I run, it insert the blank rows but ask me by
message box "How many" when I give number e.g. 15, macro insert the blank
15 rows after the active cell.
Thanks in Advance.
Aamir Shahzad
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wann
d is :
>>
>>
>> Count of names matching product 'A' and Id '1S' is 4
>> and count of names matching product 'A' and ID '2B' is 4
>>
>>
>> On Thu, Feb 7, 2013 at 2:40 PM, Aamir Shahzad
>> wrote:
>>
>>
check now
=COUNTIFS($A$2:$A$10,A5,$B$2:$B$10,B5,$C$2:$C$10,C5)
On Thu, Feb 7, 2013 at 1:58 PM, Smitha S R wrote:
> Hi,
> This formula does not suit my requirement. I have to count the names
> matching the product and ID.
>
>
> On Thu, Feb 7, 2013 at 2:09 PM, Aamir Shahzad
You can use:
=COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2)
Aamir Shahzad
On Thu, Feb 7, 2013 at 1:36 PM, Smitha S R wrote:
> Hi,
>
> Please help me in finding the count of unique values matching criteria as
> in the attachment.
>
> Regard
> Smitha
>
> --
> Are you =E
hi Amar,
for sumifs formula use
=SUMIFS($C$2:$C$69,$A$2:$A$69,F3,$B$2:$B$69,">"&6000)
for all versions of excel use
=SUMPRODUCT(($A$2:$A$69=F3)*($B$2:$B$69>6000)*($C$2:$C$69))
Regards,
Aamir Shahzad
On Wed, Feb 6, 2013 at 11:29 AM, अनिल नारायण गवली
wrote:
> Dear Ama
Dear Group,
How to get the sheet names in one sheet? sample file is attached.
Regards,
Aamir Shahzad
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
Dear Noorain Sir and Group,
Still waiting for recification of the query.
Aamir Shahzad
-- Forwarded message --
From: Aamir Shahzad
Date: Tue, Dec 18, 2012 at 3:17 PM
Subject: Re: [XL-VBA Clinic] Re: $$Excel-Macros$$ Amendment in macro
To: excelvbacli...@googlegroups.com
thanks
ange.Value = ActiveSheet.UsedRange.Value
End Sub
Regards,
Aamir Shahzad
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Pr
well done & congrates Paul.
Aamir Shahzad
On Tue, Dec 4, 2012 at 11:11 AM, Rakesh Kumar Sharma wrote:
> Hi Paul,
>
> Congratulations...
>
>
> On Tue, Dec 4, 2012 at 10:33 AM, Satendra kumar > wrote:
>
>> Hi Paul,
>>
>>
>> congratulations
Please see the attached sheet
Aamir Shahzad
On Fri, Nov 9, 2012 at 9:59 PM, >>Excel Beginner<<
wrote:
> Hi shiva,
>
>please find the attachment.
>
>
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
> *
> *
> On Fri, Nov
king or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebo
You can use the following formula
=YEAR(D4)-YEAR(D3)&" Years"&" "&MONTH(D4)-MONTH(D3)&" Months"
Aamir Shahzad
On Mon, Nov 5, 2012 at 4:51 PM, Kuldeep Singh wrote:
>
> Hi,
>
> You can use *DATEDIF()* formula.
>
> Regards,
> Kul
Kindly paste code here
On Mon, Nov 5, 2012 at 12:02 PM, अनिल नारायण गवली
wrote:
> just goto macro and select the macro and run it
>
> Regards
> Gawli Anil
>
> On Mon, Nov 5, 2012 at 12:22 PM, Aamir Shahzad
> wrote:
>
>> Dear Anil,
>> Is there any code avail
ls find Attached
>> FYI
>>
>> Regards,
>> Gawli Anil.
>>
>> On Mon, Nov 5, 2012 at 11:52 AM, Aamir Shahzad
>> wrote:
>>
>>> Dear Group,
>>>
>>> I need the macro when I run, it convert the number into comma style plus
>&g
Dear Group,
I need the macro when I run, it convert the number into comma style plus
decrease decimal to zero.
e.g. 12345678.00 convert to 12,345,678
Aamir Shahzad
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED
Hi Cheer,
Please use the same mail chain for solution instead of new mail.
Aamir Shahzad
On Fri, Nov 2, 2012 at 5:21 PM, CoRe wrote:
> Hello Neeraj
>
> CTRL+1 on the value column --> Custom --> select type *0.00*
>
>
> cheers
>
>
> On Friday, November
Hi Cheer,
Please use the same mail chane for solution instead of new mail.
Aamir Shahzad
On Fri, Nov 2, 2012 at 5:21 PM, CoRe wrote:
> Hello Neeraj
>
> CTRL+1 on the value column --> Custom --> select type *0.00*
>
>
> cheers
>
>
> On Friday, November
hi Neeraj,
You can just use the Ctrl+Shift+~ key for general format.
Aamir Shahzad
On Fri, Nov 2, 2012 at 5:21 PM, sunil jagtap wrote:
> Hi Neeraj,
>
> Please try below formula
>
> =ROUND((C3*100),2)
>
> Thanks and Regards,
> Sunil
>
>
>
> On Fri, No
Dear Noorain Sir,
Can you ammend your code that when we run macro, a message box appear and
ask for select the sheets which you want to delete and we will select the
multiple sheet which we want to delete.
Aamir Shahzad
On Thu, Nov 1, 2012 at 11:34 AM, Pravin Gunjal wrote:
> *Dear Noor
you can also use
=IF(MONTH($B$2)=MONTH(A5),COUNT($D$3:D4)+1,"")
Aamir Shahzad
On Wed, Oct 31, 2012 at 5:18 PM, Rohan Young wrote:
> hi Prashant,
>
> PFA
>
> regds
>
> On Wed, Oct 31, 2012 at 5:35 PM, Prashant Pawle
> wrote:
>
>> Dear Experts
>&g
PFA
Aamir Shahzad
On Wed, Oct 31, 2012 at 1:04 PM, Shaik Waheed wrote:
> PFA,
> Hope this is what u were luking for
>
> On Wed, Oct 31, 2012 at 1:20 PM, Rajesh Agarwal wrote:
>
>> PFA
>>
>> --
>> *Rajesh Kumar Agarwal*
>> *9811063001*
>>
hi Sundarvelan,
You can use the following array formulas for count the Red & Green cells.
Please note it's calculating the cell values not cell colors. See the
attached file.
=COUNT(IF(D2:AG2>C2,D2:AG2))
=COUNT(IF(D2:AG2<=C2,D2:AG2))
Aamir Shahzad
On Tue, Oct 30, 2012 at 4:11
oups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-ma
oups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/g
I have registered thanks as well
On Thu, Oct 25, 2012 at 11:06 AM, ashish damor wrote:
> Dear Aamir,
>
> The registration is free and it does not take even 5 minutes to register.
>
> On Thu, Oct 25, 2012 at 10:52 AM, Aamir Shahzad
> wrote:
> > Dear Rajan,
> >
>
or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googleg
attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promoti
um in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any
d.
> >
> > NOTE : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
> > ---
> > You received this message because you are subscribed to the Google Groups
> > "MS EXCEL AND V
PFA
Aamir Shahzad
On Sat, Oct 20, 2012 at 1:29 PM, Rajan_Verma wrote:
> *You can use NetworkDays.INTL() parameters are same as previous *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-ma
Following formulas for Max & Min with C+S+E
=MAX(IF(ISNUMBER(A2:A40),A2:A40))
=MIN(IF(ISNUMBER(A2:A40),A2:A40))
Regards,
Aamir Shahzad
On Fri, Oct 19, 2012 at 12:24 PM, Rajesh Agarwal wrote:
> Dear Sir
> I need formula in b2 and c2 max and minimum value of a2:a40 excluding
&g
or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> own
PFA
Aamir Shahzad
On Wed, Oct 17, 2012 at 3:16 PM, Rajesh Agarwal wrote:
> Dear Sir
> I want to put formula on column B.
> Rgds
>
> --
> *Rajesh Kumar Agarwal*
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
>
tion is delete the rows & columns after the data, then save & close the
file and reopen, file size will reduce and excel will treet the last data
cell as last used cell.
Thanks.
Aamir Shahzad
On Mon, Oct 15, 2012 at 4:34 PM, Prince wrote:
> Hi Amir,
>
> I feel excel is correc
got it thanks.
Aamir Shahzad
On Mon, Oct 15, 2012 at 4:34 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Hi Aamir,
>
> ** **
>
> After deleting the rows and column close the excel and re-open the file..*
> ***
>
> ** **
>
> Then
Dear Group,
When we use the Ctrl+end command, excel automatically move the last used
cell, but when we delete the some rows or data excel still go where last
cell was used, what should we do for this?
Regards,
Aamir Shahzad
--
Join official facebook page of this forum @
https
waiting for your response plz
-- Forwarded message --
From: Aamir Shahzad
Date: Fri, Oct 5, 2012 at 10:44 AM
Subject: Macro for convert to Million
To: excel-macros@googlegroups.com
Dear Group,
I require the Macro in Add-in form which convert the full amount into the
million
Dear Group,
I require the Macro in Add-in form which convert the full amount into the
million e.g. if I want to convert the figure 1,000,000 to million it will
show as 1.000.
Procedure should 1,000,000 enter as "1,000,000mm" it automatically convert
the figure as 1.000.
Regards,
Aam
Congrates Rajan
Aamir Shahzad
On Wed, Oct 3, 2012 at 9:50 AM, Kuldeep Singh wrote:
>
> Congratulations Rajan Sir.
>
> Regards,
> Kuldeep Singh
> Back Office Executive (MIS)
> Info Edge India Limited (naukri.com)
> Phone.: +91-120-4763789, Extn.: 789, 971615535
&
Hi Group, this is Aamir Shahzad from Karachi Pakistan, currently working as
MIS Officer in a Bank. Love Excel & learning.
Aamir Shahzad
On Sat, Sep 29, 2012 at 11:43 AM, Ayush Jain wrote:
> Good to know you all from this post, please keep this thread alive by
> introducing yourself.
David - this still showing value error.
On Sat, Sep 29, 2012 at 4:48 AM, David Grugeon wrote:
> Use
>
>
>
> =SUMPRODUCT(($H$2:$H$9=$H12)*indirect((ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2)
> Regards
> David Grugeon
>
>
> On 28 September 2012 22:24, Aa
yes you are right but I am not understanding why formula generating error,
I want to know the reason? can you investigate.
Aamir Shahzad
On Fri, Sep 28, 2012 at 5:41 PM, Don Guillett wrote:
>
>
> On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote:
>>
>> D
=$H12)*(ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2
Sample file is also attached, Please suggest.
Regards,
Aamir Shahzad
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thre
Rajan - can you please define how shape color is changing.
Aamir Shahzad
On Tue, Aug 7, 2012 at 7:08 PM, dguillett1 wrote:
> Option Explicit
> Sub ChangeShapeColorsSAS()
> Dim i As Long
> Dim ms As String
>
> On Error Resume Next
> For i = 2 To 5
> ActiveSheet.Shapes(i
Congrats Rajan
Aamir Shahzad
On Wed, Jul 4, 2012 at 10:55 PM, Maries wrote:
> Congrats Rajan...
>
> On Wed, Jul 4, 2012 at 9:53 PM, NOORAIN ANSARI
> wrote:
>
>> Congrats Rajan...
>>
>>
>> On Wed, Jul 4, 2012 at 10:43 PM, dguillett1 wrot
Thank you Noorain and Ashish.
Regards,
Aamir Shahzad
On Thu, May 24, 2012 at 6:40 AM, NOORAIN ANSARI wrote:
> Dear Aamir,
>
> Please see attached sheet with Example
> Hope it will help to you.
>
> --
> Thanks & regards,
> Noorain An
Dear Group,
Kindly share the wildcard examples or theory.
Regards,
Aamir Shahzad
--
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
natures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post t
Don - if you select the entire column, Excel will consider till the last
used cell. Therefore no worried about the selection.
Regards,
Aamir Shahzad
On Wed, May 23, 2012 at 5:30 PM, dguillett1 wrote:
> Also, please do not use entire columns. Restrict to only area needed.
>
> =V
I don't think so or any other group member can provide solution.
Regards,
Aamir Shahzad
On Tue, May 22, 2012 at 10:03 AM, LAKSHMAN PRASAD wrote:
> Plz see the attached file
>
>
>
>
>
> *From:* Aamir Shahzad
> *To:* excel-macros@googlegroups.com
> *Sent
sorry not understand make it clear, lots of expert here can solve your
issue.
Aamir Shahzad
On Mon, May 21, 2012 at 11:13 AM, LAKSHMAN PRASAD wrote:
> Hi Aamir,
>
> Thanks
>
> Is working, that’s what I exactly want to do. But Its better if we avoid
> extra column. I am a
RODUCT(--($A$2:$C$11=E2)*($E$2:$E$11))>1,"","Not Present")
>
> ** **
>
> Regards,
>
> ** **
>
> Aamir Shahzad
>
> ** **
>
> On Sun, May 20, 2012 at 8:46 AM, Mohammed Muneer
> wrote:
>
> HI, Rajan its working that’s w
You also can use:
=IF(SUMPRODUCT(--($A$2:$C$11=E2)*($E$2:$E$11))>1,"","Not Present")
Regards,
Aamir Shahzad
On Sun, May 20, 2012 at 8:46 AM, Mohammed Muneer wrote:
> HI, Rajan its working that’s what I exactly want to do.
>
>
>
> Thanx Buddy….
>
Thank a lots Asa, working very nice without any trouble.
Regards,
Aamir Shahzad
On Sun, May 20, 2012 at 7:39 AM, Asa Rossoff wrote:
> Hi Aamir,
>
> How about this:
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> Application.EnableEvents = False
>
&
For example I insert the column in sheet it's taking too much time when
running this code otherwise inserting the column is too fast. Therefore I
ask you people for look & amend for this code.
Regards,
Aamir Shahzad
On Sat, May 19, 2012 at 6:37 PM, Rajan_Verma wrote:
> *Can you
Thank you so much Rajan you are really asset of this group. Can you guide
how to become the expert like you in formulas & macros.
Aamir Shahzad
On Fri, May 18, 2012 at 12:50 AM, Rajan_Verma wrote:
> I think it will be final J
>
>
>
> Sub CreateCopy()
>
> ActiveShee
thanks rajan for your expertise. But if format started from B2 to H10 when
run the code, sheet format automatically starts from A1 to. Please see &
amend that create the new copy values sheet except copy.
Aamir Shahzad
On Fri, May 18, 2012 at 12:35 AM, Rajan_Verma wrote:
>
>
ok Rajan now code is working fine but it's removing the formating.
Aamir Shahzad
On Fri, May 18, 2012 at 12:24 AM, Rajan_Verma wrote:
> *REMOVE THE ALL BLANK LINES BETWEEN LINES OF CODE*
>
>
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [I
Don,
Your macro is convert the sheet to values only not creating copy of sheet.
Rajan,
Your macro is showing error.
Regards,
Aamir Shahzad
On Thu, May 17, 2012 at 10:37 PM, Rajan_Verma wrote:
> *Try this One:*
>
>
>
>
>
> Sub MakeCopyofValues()
>
>
>
> Dim r
Dear Group,
Macro required which generate the same copy of sheet but values only.
Regards,
Aamir Shahzad
--
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
=OFFSET($F$1,MATCH(A2,$F$2:$F$21,0),-1)
Aamir Shahzad
On Mon, May 14, 2012 at 11:00 PM, Venkatesh Narla wrote:
> Hi All,
> I need help in Vlookup need formula.
>
> "Hi All,
> Column A has data; Column ""F"" is the range need E to pull"
>
>
>
thank you Don & Lalit.
Regards,
Aamir Shahzad
On Sun, May 13, 2012 at 6:47 AM, ╰» ℓαℓιт мσαнη wrote:
> Dear Aamir
>
> You can use this also..
>
> Sub Sheet1Multiplecopy()
>
>Dim noOfSheet As Long
>Dim strTEmp As String
>
d does a calculation for
> every row. It is also volatile, so it is recalculated at every calculation.
>
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Aamir Shahzad
>
> *
Example file is attached.
On Sat, May 12, 2012 at 9:04 PM, dguillett1 wrote:
> Your desire is not clear. Provide a file with a complete explanation
> and examples.
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Aamir
m:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Aamir Shahzad
> *Sent:* 12 May 2012 8:40
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ query
>
>
>
> Dear Group,
>
>
>
> How to pick the values by formul
thanks Don, but when I save file as add in & create tab then this code not
working kindly brief and where below code will apply
Sub test()
' from other excel file
Application.Run ("youraddin.xlam!macroname")
End Sub
Aamir Shahzad
On Tue, May 1, 2012 at 12:55 AM
thanks Don, can you tell me? if I save this code to .xlam (add in) format
then how I recall this macro.
Aamir Shahzad
On Sat, Apr 28, 2012 at 5:28 PM, dguillett1 wrote:
> Use this macro in a macro enabled workbook
>
> Sub insertrows()
> Dim i As Long
> On Error Resume Next
another solution
=IF(ISBLANK(B3),"",IF(AND(B3="green",B2="red"),30,0))
Aamir Shahzad
On Mon, Apr 30, 2012 at 6:33 PM, dguillett1 wrote:
> And, if you really want only change from red to green, add And LCase(c)
> = "green"
>
> Sub checkmatc
Hi Group,
how to insert the row after every unique name?
Regards,
Aamir Shahzad
--
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
I had the same idea for sorting the group data, well what about the summary
for get the total only if the heading of format is same.
Aamir Shahzad
On Mon, Apr 16, 2012 at 11:09 PM, Rajan_Verma wrote:
> Hi
>
> Please see the attached Sheet..
>
> I Add a helper column in main Dat
this is easy to copy paste but I need the formula for this if groups in
summary are not in order. Plz also provide the solution of second query.
Thanks
Aamir Shahzad
On Mon, Apr 16, 2012 at 10:35 PM, Rajan_Verma wrote:
> Hi
>
> To Get Summary , you can just filter in 2nd Column on
thanks Rajan for this useful addin. what is the short key of add in window?
Aamir Shahzad
On Mon, Apr 16, 2012 at 6:22 PM, Rajan_Verma wrote:
> Install the attached Add-in
>
> Hope it will help to get desired
>
>
>
> You can use =InWord(A1) to convert the digit in Number..
,
Aamir Shahzad
--
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't p
but this formula is counting 2 of unique numbers also.
Aamir Shahzad
On Sat, Apr 7, 2012 at 12:10 PM, The Viper wrote:
> =COUNTIF($A$2:$A$1393,A2)
> or
> =COUNTIF(A:A,A2) in a2 and copy down
>
>
>
>
> On Sat, Apr 7, 2012 at 12:32 PM, Mohammed Muneer wrote:
>
>
thanks Jaysheel \ Waseem \ MARIES \ Rajan
regards,
Aamir Shahzad
On Wed, Apr 4, 2012 at 1:22 PM, Rajan_Verma wrote:
> Hi
>
> Please find the attached sheet’
>
> =IF(ISNUMBER(INT(RIGHT(C2,6))),INT(RIGHT(C2,6)),"")
>
>
>
>
>
> Rajan
>
>
>
>
Dear Group,
How to extract 6 digit numbers from right if its number & convert this to
numbers by formula. See the attached file.
Regards,
Aamir Shahzad
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
1 - 100 of 210 matches
Mail list logo
