Dear Seniors,
Thank to all of you. Your help means a lot for me. thanks.
thanks,
Ashish
On Monday, July 22, 2013 11:44:56 AM UTC+5:30, Vabz wrote:
Hi,
It is working fine. In Cell A3 data is 958321.1 which is reversed
as 1.123859.
Pl check confirm.
Thanks!!
Respected Ashish,
Simply use the attached add-in.
On Mon, Jul 22, 2013 at 12:00 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Seniors,
Thank to all of you. Your help means a lot for me. thanks.
thanks,
Ashish
On Monday, July 22, 2013 11:44:56 AM UTC+5:30, Vabz wrote:
Sent: Monday, July 22, 2013 11:21 AM
Subject: Re: $$Excel-Macros$$ Query - How to make reversal string.
Dear Expert ,
Can you expline the bold line as i want to know deeply.
Function Reverse(Text As String) As String
Dim i As Integer
Dim StrNew As String
Dim strOld As String
Dear Seniors,
I have this type of data :
54321
ASDF
8796564
DFRESW
But I want OUTPUT like below mentioned :
12345
FDSA
4656978
WSERFD
How to make ti reversal through formula. Please help ??
Thanks Regards,
Ashish Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Dear Ashish sir,
thanks for your quick response, but this is not working i want solve this
query only from excel formula not VbA. coz, i want to reverse string in
some columns not whole excel sheet. please suggest me how to resolve this
query from excel formula.
Thanks,
Ashish
On Sunday,
Hi Ashish,
Try this
Function Reverse(Text As String) As String
Dim i As Integer
Dim StrNew As String
Dim strOld As String
strOld = Trim(Text)
For i = 1 To Len(strOld)
StrNew = Mid(strOld, i, 1) StrNew
Next i
Reverse = StrNew
End Function
Dear Vabs,
Thanks for you reply, the formula is working but when I change this formula
accordingly this is not working properly. please find attached excel sheet
for query data.
On 21 July 2013 21:20, vba v...@vabs.in wrote:
Hey,
Try this, this works up to 12 character.
PFA
Thanks
On Sun, Jul 21, 2013 at 11:10 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Vabs,
Thanks for you reply, the formula is working but when I change this
formula accordingly this is not working properly. please find attached
excel sheet for query data.
On 21 July 2013
Dear VbA,
thanks for your help. but this formula is not working properly.
Thanks,
Ashish
On 22 July 2013 10:27, vba v...@vabs.in wrote:
PFA
Thanks
On Sun, Jul 21, 2013 at 11:10 PM, Ashish Kumar
kumar.ashish...@gmail.comwrote:
Dear Vabs,
Thanks for you reply, the formula is
hi priti,
very nice formula.. very useful. thank you.
Thanks Regards,
Prabhu R
On 16 July 2013 14:57, priti verma pritiverma1...@gmail.com wrote:
PFA
On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E emuralidha...@gmail.comwrote:
Dear Friends good afternoon,
I need help reg. lookup
Dear Friends good afternoon,
I need help reg. lookup values
1.It is possible to vlookup the values for the left side
2.Vlookup for the second value(occurence), third value
Is their any other ways or functions to get the results.?
Thanks in advance.
--
*Thanks Regards,*
**
*Muralidhar
PFA
On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E emuralidha...@gmail.comwrote:
Dear Friends good afternoon,
I need help reg. lookup values
1.It is possible to vlookup the values for the left side
2.Vlookup for the second value(occurence), third value
Is their any other ways or
Dear Murlidhar,
Please visit here..
http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html
On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E emuralidha...@gmail.comwrote:
Dear Friends good afternoon,
I need help reg. lookup values
1.It is possible to vlookup the values for the
Respected Muralidhar,
You can use Index,Match,Indirect functions for accomplishing some look up
tasks which are not possible by VLookup.
Regards,
VijayKumar
On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Murlidhar,
Please visit here..
Hi,
ThanksVijay. can u present me with an example,it is better to understand me.
Thanks in advance.
On 16 July 2013 15:07, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Muralidhar,
You can use Index,Match,Indirect functions for accomplishing some look up
tasks which are not possible
Thanks mr, Ansari,
I cant understand the 9E+307 in the below formula
=LOOKUP(9E+307,1/(C3:C9=E9),B3:B9)
plz, help me on this with an example,it is help me more.
Thanks in advance
Warm Regards,
Muralidhar
On 16 July 2013 15:37, Muralidhar E emuralidha...@gmail.com wrote:
Hi,
Dear Muralidhar.
it's the largest number that Excel can store. This Big number is used to
look up the last number in a range.
On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E emuralidha...@gmail.comwrote:
Thanks mr, Ansari,
I cant understand the 9E+307 in the below formula
Respected Muralidhar,
You can see the following links for Examples
http://exceluser.com/blog/465/excels-best-lookup-method-index-match.html
http://www.youtube.com/watch?v=IX2TZ3OlOlA
http://www.randomwok.com/excel/how-to-use-index-match/
Regards,
Vijaykumar
On Tue, Jul 16, 2013 at 3:37 PM,
Thank u
On 16 July 2013 16:34, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Muralidhar.
it's the largest number that Excel can store. This Big number is used to
look up the last number in a range.
On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E emuralidha...@gmail.comwrote:
Dear Vijay Kumar.
Thank u
On 16 July 2013 16:40, Muralidhar E emuralidha...@gmail.com wrote:
Thank u
On 16 July 2013 16:34, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Muralidhar.
it's the largest number that Excel can store. This Big number is used
to look up the last
Repected Vijay Kumar and Noorain Ansari.
Both of u and the team Thank u very much.
On 16 July 2013 16:46, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Muralidhar,
See the following link and attached File.
http://chandoo.org/wp/2010/11/02/multi-condition-lookup/
Regards,
Vijaykumar
Dear Experts,
I have a query related to Pivot Table. Pls refer to attachment.
--
Regards,
Rakesh Kumar Sharma
Contact: +91-9971024741
--
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 @
Dear Rakesh,
please see attachment.
in case of place months in ascending order. you have to do it manually.
right click on any month and move it to left, right, to beginning or to end.
Regards,
Waseem Saifi
On 7/11/13, Rakesh Kumar Sharma rakeshks@gmail.com wrote:
Dear Experts,
I have a
use this formula in c2 =DATE(YEAR(B2),MONTH(B2),1)
and fill it down then try to sort the columns of pivot table
On Thu, Jul 11, 2013 at 6:36 PM, Waseem Saifi waseemsa...@gmail.com wrote:
Dear Rakesh,
please see attachment.
in case of place months in ascending order. you have to do it
Thanks Sir.
On Wed, Jul 3, 2013 at 10:52 AM, Vabs VBA v...@vabs.in wrote:
Hi
X refer to each cell in range A1 to D5.
Thanks
On 3 Jul 2013 10:41, Prafull Jadhav prafulltjad...@gmail.com wrote:
Dear All,
Good Morning..
I got below macro from net ..Can you explain me what x stand
Dear All,
Good Morning..
I got below macro from net ..Can you explain me what x stand here...
*Sub Upper_()*
*For Each x In Range(A1:D5)*
*'For Each x In Range(A1:D5)*
*
*
*x.Value = UCase(x.Value)*
*'x.Value = UCase(x.Value)*
*
*
*Next*
*
*
*Thanks in Advance.*
*Regards,*
*Prafull Jadhav.*
Hi
X refer to each cell in range A1 to D5.
Thanks
On 3 Jul 2013 10:41, Prafull Jadhav prafulltjad...@gmail.com wrote:
Dear All,
Good Morning..
I got below macro from net ..Can you explain me what x stand here...
*Sub Upper_()*
*For Each x In Range(A1:D5)*
*'For Each x In
Hi group,
I have a small query in VBA, Pls check my file for details,Pls Help
Thanks In adv.
--
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
Shortest is this
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: 15 February 2013 4:34
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query
Hi Chauan
Hi All,
I seek your guidance in the attached sheet, wherein, currently I am updating
manually the column: I Correct Cost Centre Contracts.I am updating this
from the data available in corresponding columns: D,E,F G. Therefore, please
guide with a formula which can extract the required data by
Hi All,
I seek your guidance in the attached sheet, wherein, currently I am updating
manually the column: I Correct Cost Centre Contracts.I am updating this
from the data available in corresponding columns: D,E,F G. Therefore, please
guide with a formula which can extract the required data by
pls chk
On Fri, Feb 15, 2013 at 3:03 PM, vatspoojav...@gmail.com wrote:
Hi All,
I seek your guidance in the attached sheet, wherein, currently I am
updating manually the column: I Correct Cost Centre Contracts.I am
updating this from the data available in corresponding columns: D,E,F G.
Hi
=IFERROR(VLOOKUP(A2,'Cost Center1'!$A$2:$A$21,1,0), ) .if you want blank
in place of N/A
On Fri, Feb 15, 2013 at 2:20 PM, vatspoojav...@gmail.com wrote:
Hi All,
I seek your guidance in the attached sheet, wherein, currently I am
updating manually the column: I Correct Cost Centre
-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query collation of data ignoring #n/a
Hi
=IFERROR(VLOOKUP(A2,'Cost Center1'!$A$2:$A$21,1,0), ) .if you want blank
in place of N/A
On Fri, Feb 15, 2013 at 2:20 PM, vatspoojav...@gmail.com wrote:
Hi All,
I seek your guidance
--
*From: * vijayajith VA vijayajith...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Fri, 15 Feb 2013 15:08:39 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ Query collation of data ignoring #n
Hi Chauan,
Use ths UDF..
Function RevStr(Rng As Range)
RevStr = StrReverse(Rng.Text)
End Function
On Fri, Feb 15, 2013 at 4:23 PM, neeraj chauhan
neerajchauhan...@gmail.comwrote:
Dear Experts,
kindly find the attached sheet and send the formula in excel for reverse
value
--
Are you
Dear Neeraj,
Try it..
Function Reverse_Order(rng As Range)
Dim i%
For i = Len(rng) To 1 Step -1
Reverse_Order = Reverse_Order Mid(rng, i, 1)
Next i
End Function
On Fri, Feb 15, 2013 at 4:23 PM, neeraj chauhan
neerajchauhan...@gmail.comwrote:
Dear Experts,
kindly find the attached sheet
Hi,
solved your query. see the attachment.
On Fri, Feb 15, 2013 at 2:20 PM, vatspoojav...@gmail.com wrote:
Hi All,
I seek your guidance in the attached sheet, wherein, currently I am
updating manually the column: I Correct Cost Centre Contracts.I am
updating this from the data
Hi Experts,
I have mention the details in the tab itself, Please do the needful..
Thanks
Pankaj Sangotra
--
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
Dear Pankaj,
Please try it..
*=OFFSET($B12,0,COUNTA($C$11:$P$11)-4,1,5)*
see attached sheet for more clarity.
--
With Regards,
Noorain Ansari
http://
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http://
Dear Neeraj,
You can use..
=EDATE(A2,6)
or
=DATE(YEAR(A2),MONTH(A2)+6,DAY(A2))
On Fri, Feb 8, 2013 at 1:35 PM, neeraj chauhan
neerajchauhan...@gmail.comwrote:
Dear Experts,
kindly find the attached sheet i want the add the 6 or 7 months in
particular date.
--
Are you =EXP(E:RT) or
thanks sir,
its working thanks again
On Fri, Feb 8, 2013 at 2:16 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Neeraj,
You can use..
=EDATE(A2,6)
or
=DATE(YEAR(A2),MONTH(A2)+6,DAY(A2))
On Fri, Feb 8, 2013 at 1:35 PM, neeraj chauhan neerajchauhan...@gmail.com
wrote:
neeraj, very bad subject and query explaination
On Fri, Feb 8, 2013 at 2:17 AM, neeraj chauhan
neerajchauhan...@gmail.comwrote:
thanks sir,
its working thanks again
On Fri, Feb 8, 2013 at 2:16 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Neeraj,
You can use..
=EDATE(A2,6)
: Dhaval Shah todhavals...@gmail.com
Subject: Re: $$Excel-Macros$$ query for getting external data from a website
To: excel-macros@googlegroups.com
Cc: keni...@yahoo.com
Date: Monday, December 31, 2012, 12:24 PM
Kenil
pls click the below mention link to download data of any eq series stocks
Hi,
I want data of last 3months of a particular stock from a website. i have link
of that website but dont know how to import it.i just want if i change just
symbol of that particular script i get the data of that particular script i
want. pls find the file attached for details.
Pls help
Kenil
pls click the below mention link to download data of any eq series stocks
www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012
*TCS*EQN.csv
www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012RELIANCE
**EQN.csv
just u have to change the
Hi Kenil,
Make changes to below code as per your requirement. If you get stuck then
let me know.
*What you need to do:*
-change cURL as per your required time period.
-change the range and sheet.
-change the query table.
Public Const cURL =
Hi
It could not be so.
Check whether you have provided correct sheet name in your project sheet
also..
Rgds//Vabs
On Wed, Oct 24, 2012 at 4:05 PM, Kenil Gala keni...@yahoo.com wrote:
Hi all,
Pls help me solve my query.
I have written my query in the attachment .
Thanks Regards.
--
Hi all,
Need help on this.
Regards,
Ankit
On Thu, Oct 18, 2012 at 5:21 PM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Hi Haseeb,
Thanks for your mail. this is really help me. but I have some point which
can make it more effective and efficient.
- Department code will be written
Hi Haseeb,
Thanks for your mail. this is really help me. but I have some point which
can make it more effective and efficient.
- Department code will be written automatically.
- and , another point is, If any employee salary is going in two
percentage(%) (as in sonu),we do not need to
Hello Ankit,
Attached is a one way. This is not a best one, some one will have better
options.
I have added two columns. One is Dpmt% 2nd one is No: of Dpmt, which
is return through a formula.
No:of Dpmt column, MUST NOT be empty or zero. Better to use dynamic range
or convert your range to
Dear All,
I have a salary sheets where there are three column i.e. Name, Department
and salary. I need department wise salary sheet but there is one
issue.there are lots of employees whose salary is going in more then 1
department so I am confused how I bind up my salary. I mentioned my method
in
Hi All,
Can it be possible or I have to do same process which I am doing.
Regards,
Ankit
On Mon, Oct 15, 2012 at 12:21 PM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Dear All,
I have a salary sheets where there are three column i.e. Name, Department
and salary. I need department wise
David - this still showing value error.
On Sat, Sep 29, 2012 at 4:48 AM, David Grugeon da...@grugeon.com.au 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, Aamir Shahzad
Hi Aamir,
Try this one.
=INDEX(C2,MATCH($H12,$H$2:$H$9,0))
Regards,
Kuldeep Singh
On Sat, Sep 29, 2012 at 2:48 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
David - this still showing value error.
On Sat, Sep 29, 2012 at 4:48 AM, David Grugeon da...@grugeon.com.auwrote:
Use
Dear Group,
When I mannualy enter the C7 into the following formula, it has no
problem,
=SUMPRODUCT(($H$2:$H$9=$H13)*(*C7*))
but when I am trying to generate C7, it's given me #value error, however
address function is creating the C7 ok seperaterly.
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, Aamir Shahzad aamirshahza...@gmail.com wrote:
Dear Group,
When I mannualy enter the C7 into the following formula, it has no
problem,
Hi Group,
I want to know how Circle Invalid function works in excel and vba.
Regards,
Hemant.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Not getting your problem???
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Excel Vba
Sent: 13 September 2012 7:40
To: excelvbacli...@googlegroups.com
Subject: $$Excel-Macros$$ Query - Circle
the people you can,
As long as ever you can.” - John Wesley
-
From: Excel Vba excelvba.lear...@gmail.com
To: excelvbacli...@googlegroups.com
Sent: Thu, September 13, 2012 10:11:28 AM
Subject: $$Excel-Macros$$ Query - Circle
can.” - John Wesley
*-
--
*From:* Excel Vba excelvba.lear...@gmail.com
*To:* excelvbacli...@googlegroups.com
*Sent:* Thu, September 13, 2012 10:11:28 AM
*Subject:* $$Excel-Macros$$ Query - Circle Invalid...
Hi Group
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query - Circle Invalid...
I think it is excel 2010 version. When you goto Data tab, then select Data
validation drop down.
You will find second option. It automatically select the invalid data.
On Thu, Sep 13, 2012 at 8:13 PM, Paul Schreiner
,
Lalit Mohan
+919711867226 [IM Only]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Excel Vba
Sent: Tuesday, July 10, 2012 7:12 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query - AutoNumber
Hi Group,
I am trying to get
Hi kenil,
Pls change accordg to your data.
=MAX(IF(B1:B70,B1:B7))
=MIN(IF(A1:A70,A1:A7))
On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala keni...@yahoo.com wrote:
hi all,
i have a query for finding maximum and minimum values.
i have written my query in the excel sheet attached. pls help me
Dear Kenil,
Without using ctrl+shfit+enter
You can also use..
=SUMPRODUCT(MIN(($D2:$G20)*($D2:$G2)))
=SUMPRODUCT(MAX(($D2:$G20)*($D2:$G2)))
On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA vijayajith...@gmail.comwrote:
On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA
...@gmail.com
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
To: excel-macros@googlegroups.com
Date: Tuesday, August 14, 2012, 12:27 PM
Dear Kenil,
Without using ctrl+shfit+enter
You can also use..
=SUMPRODUCT(MIN(($D2:$G20)*($D2:$G2)))
=SUMPRODUCT(MAX(($D2:$G20)*($D2:$G2
with a comment in another cell again,
Thanks and Regards.
--- On *Tue, 8/14/12, NOORAIN ANSARI noorain.ans...@gmail.com* wrote:
From: NOORAIN ANSARI noorain.ans...@gmail.com
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
To: excel-macros@googlegroups.com
Date: Tuesday
Yes Sir,
Perfect
Thanks a Ton.
Thanks Regards,
--- On Tue, 8/14/12, dguillett1 dguille...@gmail.com wrote:
From: dguillett1 dguille...@gmail.com
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
To: excel-macros@googlegroups.com
Date: Tuesday, August 14, 2012, 5:05
I am available for custom excel projects at only $75 hourly .
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Kenil Gala
Sent: Tuesday, August 14, 2012 12:20 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query for finding maximum
Dear Hemant,
Lalit solution is nice
You can also check..
http://www.ozgrid.com/forum/showthread.php?t=58969
On Fri, Jul 13, 2012 at 4:51 PM, Excel Vba excelvba.lear...@gmail.comwrote:
Hi Group,
How can i declare a global variable for below mentioned.
Private sub abc()
dim sh as
Hi Group,
How can i declare a global variable for below mentioned.
Private sub abc()
dim sh as worksheet
dim rng as range
set sh = Thisworkbook.Sheets(Sheet1)
set rng = sh.range(a1:csh.range(crows.count).end(xlup).row)
End sub
In my module i have 20 procedure and in future comes many
Dear
If you want a variabler such that it will works for all the procedure
in a module use below.
dim sh as worksheet
dim rng as range
Private sub abc()
set sh = Thisworkbook.Sheets(Sheet1)
set rng = sh.range(a1:csh.range(crows.count).end(xlup).row)
End sub
or else If you want it access
NEI
Not enough information
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Excel Vba
Sent: Tuesday, July 10, 2012 8:42 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query - AutoNumber
Hi Group,
I am trying to get a automatically generate
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Query - AutoNumber
Hi Group,
I am trying to get a automatically generate a Number using the last number
used + 1, through vba.
Regards,
Hemant.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise
Sent: Tue, July 10, 2012 9:42:23 AM
Subject: $$Excel-Macros$$ Query - AutoNumber
Hi Group,
I am trying to get a automatically generate a Number using the last number used
+ 1, through vba.
Regards,
Hemant.--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
*-
--
*From:* Excel Vba excelvba.lear...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Tue, July 10, 2012 9:42:23 AM
*Subject:* $$Excel-Macros$$ Query - AutoNumber
Hi Group,
I am trying to get a automatically
July 2012 9:49
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Query on Email via macro
** **
Hi,
** **
I have a query..suppose i put some thing in column B and i have mail id
in column C i want to send the mail on that ID.
** **
In the example given below
in mail??b
** **
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *ashwani agnihotri
*Sent:* 01 July 2012 9:49
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros
[mailto:
excel-macros@googlegroups.com] *On Behalf Of *ashwani agnihotri
*Sent:* 01 July 2012 9:49
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Query on Email via macro
** **
Hi,
** **
I have a query..suppose i put some thing in column B and i have mail id
Hi,
I have a query..suppose i put some thing in column B and i have mail id in
column C i want to send the mail on that ID.
In the example given below if i enter done in column B a mail should be
send on address entered in column C
ABC
ram
sham
What do you want to send in mail??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashwani agnihotri
Sent: 01 July 2012 9:49
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query on Email
*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *ashwani agnihotri
*Sent:* 01 July 2012 9:49
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Query on Email via macro
** **
Hi,
** **
I
Hi,
Plz suggest me how i can merge two excel files data to single sheet using
command prompt.
--
Thanks Regards,
Rakesh Kumar Sharma
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Dear Rakesh,
Can you provide a sample sheet.
Thanks Regards,
Prajakt Pande
+971551388482
**
On Mon, May 14, 2012 at 10:19 AM, Rakesh Kumar Sharma
rakeshks@gmail.com wrote:
Hi,
Plz suggest me how i can merge two excel files data to single sheet using
command prompt.
--
Thanks
Dear Rakesh,
you can use following code
Sub CommandButton1()
Sheets(your sheet name).Select 'first sheet from you will copy the data
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Selection.Copy
Sheets(your sheet name).Select ' where you want to paste
Selection.PasteSpecial
May 2012 12:32
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query for Merging two excel sheets using
Command Prompt
Dear Rakesh,
you can use following code
Sub CommandButton1()
Sheets(your sheet name).Select 'first sheet from you will copy the data
Range(Selection
Hi Aamir,
You can use SUBTOTAL formula accordingly.
for ex.:
Sum of visible cells :- =SUBTOTAL(A1:A100,109)
Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation
On Sat, May 12, 2012 at 8:39 PM, Aamir Shahzad aamirshahza...@gmail.com wrote:
Dear Group,
How to pick the
CLTL+G
ALT+S
K
Enter
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: 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
@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 formula of visible cells only?
Regards,
Aamir Shahzad
--
FORUM RULES (986+ members already BANNED
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 Shahzad
Sent: Saturday, May 12, 2012 10:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query
pick
aamirshahza...@gmail.com
*Sent:* Saturday, May 12, 2012 10:31 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ query
pick the values by vlookup or sumif only on visible cells.
On Sat, May 12, 2012 at 8:19 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
CLTL+G
ALT+S
K
@googlegroups.com
Subject: Re: $$Excel-Macros$$ query
Example file is attached.
On Sat, May 12, 2012 at 9:04 PM, dguillett1 dguille...@gmail.com wrote:
Your desire is not clear. Provide a file with a complete explanation and
examples.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille
]
On Behalf Of Aamir Shahzad
Sent: Saturday, May 12, 2012 10:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query
Example file is attached.
On Sat, May 12, 2012 at 9:04 PM, dguillett1 dguille...@gmail.com wrote:
Your desire is not clear. Provide a file
Of Shaik Waheed
Sent: 01 May 2012 12:25
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query.
Hi,
PFA
On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar kumar.pramod03i...@gmail.com
wrote:
Hi Experts,
PLease solve my query.
I need age betbeen in two dated like as 2
Hi Experts,
PLease solve my query.
I need age betbeen in two dated like as 2 year 3 Month)
--
Regards,
Pramod Kumar
Technocare Solution(TCS)
Rudrapur
+91 9927033573
E-Mail:-kumar.pramod03i...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
Hi,
PFA
On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar
kumar.pramod03i...@gmail.comwrote:
Hi Experts,
PLease solve my query.
I need age betbeen in two dated like as 2 year 3 Month)
--
Regards,
Pramod Kumar
Technocare Solution(TCS)
Rudrapur
+91 9927033573
Thanks...
On Tue, May 1, 2012 at 12:25 PM, Shaik Waheed waheedb...@gmail.com wrote:
Hi,
PFA
On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar
kumar.pramod03i...@gmail.com wrote:
Hi Experts,
PLease solve my query.
I need age betbeen in two dated like as 2 year 3 Month)
--
Regards,
: $$Excel-Macros$$ Query (Remove duplicate)
Dear All,
I need you assistance, I want to remove duplicate value from column A to B.
I'v attached the test file. Kindly help me in this.
Kaяan
http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237
https://plus.google.com
Dear Karan,
Please use below code..
Dim i, j As Integer
Application.ScreenUpdating = False
For i = 1 To Range(A65536).End(xlUp).Row
For j = 1 To Range(B65536).End(xlUp).Row
If Range(A i).Value = Range(B j).Value Then
Range(B j).Delete Shift:=xlUp
End If
Next j
Next i
Hi Karan,
Try Advanced filter and select Unique records..And you can Copy and paste
it in New Column..
[image: Inline image 1]
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Mon, Mar 19, 2012 at 1:07 PM, Karan Singh
101 - 200 of 293 matches
Mail list logo