=IF(B2SUMPRODUCT(MAX($B$2:$B$31*(($A$2:$A$31=A2)*($C$2:$C$31=main,Greater
than Main,)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, March 10, 2012 11:31 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query
Dear
=IF(B2SUMPRODUCT(MAX($B$2:$B$31*(($A$2:$A$31=A2)*($C$2:$C$31=main,Greater
than Main,)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Sunday, March 11, 2012 1:27 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query
could wrap it in an IF like I used above:
=IF($C2MAIN,formula,)
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: Saturday, March 10, 2012 11:28 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query
Thanks Asa
Asa, My formula tested fine without the proposed change.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Asa Rossoff
Sent: Sunday, March 11, 2012 11:28 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Query
Hi Aamir,
You're welcome
No main will ever be than maximum main of course, but it will save
calculation time.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Sunday, March 11, 2012 10:26 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query
Dear Group,
If amount of specific id is grater then Main amount it should show comment.
Please see the attached file and provide the formula for this.
Regards,
Aamir Shahzad
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
6)),Greater than Main,),)
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: Saturday, March 10, 2012 9:32 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query
Dear Group,
If amount of specific id
Dear Sir,
Please tell me the solution for the query given in the attached file.
In it the data is distributed in the different columns. The solution
is manually copy paste the data which is time consuming process.
Please tell me the solution or formula to automate the process. Also
please note
With
Application.ScreenUpdating = False
End Sub
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mukesh Kumar
Sent: Jan/Tue/2012 01:10
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query continuous copy paste
Dear Sir,
Please tell me
Thanks Noorain Ansari Ji for the solution but it works is working with
this sheet only i.e if the column headings are having two same titles.
If I have to transform three or four columns to first three or four
columns then this macro will not work there. Please suggest any
formula or user form
Dear Mukesh,
Can you provide that worksheet, where macro is not running...
Please share workbook with group..
On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.com wrote:
Thanks Noorain Ansari Ji for the solution but it works is working with
this sheet only i.e if the column
-
From: Mukesh Kumar
Sent: Tuesday, January 31, 2012 1:40 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query continuous copy paste
Dear Sir,
Please tell me the solution for the query given in the attached file.
In it the data is distributed in the different columns. The solution
@ Don Guillett
Dear sir, your macro after running giving wrong results, please check.
@ Noorain Ansari
Sir, macro after running showing error compile error. Sub or function not
defined.
Please note, i am having different workbooks in which some workbooks
contains 2 columns similar, some 3
Subject: Re: $$Excel-Macros$$ Query continuous copy paste
@ Don Guillett
Dear sir, your macro after running giving wrong results, please check.
@ Noorain Ansari
Sir, macro after running showing error compile error. Sub or function not
defined.
Please note, i am having different workbooks
Sub kTest()
Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long, p As Long
With Worksheets(Query)
ka = .Range(a1).CurrentRegion
End With
With CreateObject(scripting.dictionary)
.comparemode = 1
For c = 1 To UBound(ka, 2)
If
Dear Kris,
Following error is coming after macro execution
Run time error '9':
Subscript out of range.
Please correct it.
Regards,
Mukesh kumar
On Tue, Jan 31, 2012 at 10:00 PM, Kris krishnak...@gmail.com wrote:
Sub kTest()
Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long,
Sub Consolidator()
Dim rngSource As Range
Dim lngCols As Long, lngRows As Long
Set rngSource = Range(A1).CurrentRegion
lngRows = rngSource.CurrentRegion.Rows.Count - 1
For lngCols = 3 To rngSource.Columns.Count - 1 Step 2
rngSource.Cells(2, lngCols).Resize(lngRows,
Here's the working model. Have given a button for ease.
Sam Mathai Chacko
On Tue, Jan 31, 2012 at 10:21 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Sub Consolidator()
Dim rngSource As Range
Dim lngCols As Long, lngRows As Long
Set rngSource = Range(A1).CurrentRegion
One of the header is 'No' instead of 'No.'
Correct the headers, it should work
Kris
--
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
Thanks a lot for solving my queries Ansari ji. But still one problem
knocking my mind that these macroes are suitable for respective problems i
have given i.e for two similar headers separate code for three similar
headers another coding is required so on.
Can u give common macro irrespective
Thanks very very much Sam Mathai Chacko sir. This was the resultant code i
was looking for. You are marvellous in excel sir.
Thanks again.
Regards,
Mukesh Kumar
On Wed, Feb 1, 2012 at 12:01 AM, Sam Mathai Chacko samde...@gmail.comwrote:
The code I gave was exactly for assigning any number of
Hello group,
there is other way to translate.
Anil
--
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
hello group,
How r all of u, I have a excel file in hindi has some name and add etc. I
have to translate them in english, can we do that plz tell me. file attahced
Anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
Dear Anil,
Attached file format is same as you posted previous. All Fonts are in Hindi.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Fri, Jan 20, 2012
Yes sir, this same file, How can i do plz tell me.
I have to translate that data in english
Anil
--
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
Do you want to translate data or just want to change format ??
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anil kumar
Sent: Jan/Fri/2012 04:23
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query about translate
Yes sir
I want to translate all name and add. in english
anil
--
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
-Macros$$ query about translate
Dear Anil,
Attached file format is same as you posted previous. All Fonts are in Hindi.
--
Thanks regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
On Fri, Jan 20, 2012 at 1:40 PM, anil kumar kmr7a...@gmail.com wrote
I think no way in excel without use of any other software
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anil kumar
Sent: Jan/Fri/2012 06:12
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query about translate
I want
Of *anil kumar
*Sent:* Jan/Fri/2012 06:12
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ query about translate
** **
I want to translate all name and add. in english
anil
--
FORUM RULES (986+ members already BANNED for violation
Hi,
I use VBA to retrieve wheather data.
This work:
With ActiveSheet.QueryTables.Add(Connection:= _
URL;http://www.osmer.fvg.it/~www/IT/SYN/
TabellaStazioniUltimOra.php, _
But with the address below it retrieves nothing ( and no error message
too).
The same with
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Alberto
Sent: Monday, January 02, 2012 8:32 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Query from URL
Hi,
I use VBA to retrieve wheather data.
This work:
With ActiveSheet.QueryTables.Add
Thanks Sam,
I think my problem is solved.
Regards,
Suyog
On Wed, Nov 16, 2011 at 12:01 AM, Sam Mathai Chacko samde...@gmail.comwrote:
=IF(IFERROR(DATE(YEAR(G23),MONTH(G23),DAY(G23))=G23,0),MONTH(G23)-IF(DAY(G23)=1,0,DAY(G23)),G23)
Regards,
Sam Mathai Chacko
On Tue, Nov 15, 2011 at 3:28
Hello Noorain,
Thanks for quick response but I've added two problems in same excel.
Please review advice.
Suyog
On Tue, Nov 15, 2011 at 3:14 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Suyog,
Please see attached sheet.
--
Thanks regards,
Noorain Ansari
=IF(IFERROR(DATE(YEAR(G23),MONTH(G23),DAY(G23))=G23,0),MONTH(G23)-IF(DAY(G23)=1,0,DAY(G23)),G23)
Regards,
Sam Mathai Chacko
On Tue, Nov 15, 2011 at 3:28 PM, Suyog Kulkarni suyog.kulka...@yahoo.comwrote:
Hello Noorain,
Thanks for quick response but I've added two problems in same excel.
Hello Friends,
Find attached excel file for ref.
I'm using one software which list out required material for structure in
excel. Output of that excel file converts some length of Ft-In format in
mm-dd-yy or mm-yy format.
Ex: For Length 10-11, excel shows Nov-11 For length 11-10, excel shows
...@gmail.com
*From:* Siraj Momin (BTG) smo...@ccc.ae
*Sent:* Saturday, November 12, 2011 1:13 AM
*To:* excel-macros@googlegroups.com
*Subject:* RE: [bulk] $$Excel-Macros$$ Query related to subtotal and
condition
PFA
Best Regards
* *
Momin Siraj Ahmad
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
HI Ankit,
Find the attachment.
On Tue, Oct 25, 2011 at 9:42 AM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Dear Expert,
Plz solve out attached query.
Regards,
Ankit
--
--
Some important links for
Dear Ankit,
Please try below formula...
=LIQ/EE/INV/1112/SUMPRODUCT(--($C$5:C5=C5))
=LIQ/EE/INV/1112/COUNTIF($C$5:C5,C5)
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
Dear Expert,
Plz solve out attached query.
Regards,
Ankit
--
--
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
SUBSTITUTE(F1TEXT(G1,ddmmyyy), ,)
On Thu, Jul 28, 2011 at 5:13 PM, Hari harisha.prabha...@gmail.com wrote:
dear members,
can any one solve my query with help of formula, i am very poor in MS
excel.
find the attachement, reply at the earliest.
Thanks in advance,
have a nice day.
--
Thanks a lot dear
On 28 July 2011 18:32, ashish koul koul.ash...@gmail.com wrote:
SUBSTITUTE(F1TEXT(G1,ddmmyyy), ,)
On Thu, Jul 28, 2011 at 5:13 PM, Hari harisha.prabha...@gmail.com wrote:
dear members,
can any one solve my query with help of formula, i am very poor in MS
excel.
find
Dear Experts,
For this chart
3001-5000 = 30
5001-6000 = 40
6001-7000 = 45
7001-8000 = 50
8001-9000 = 50
9001-15000 = 110
15001-25000 = 130
25001-4 = 150
40001= =200
I use this formula:
=*LOOKUP*
(D16,{3001,5001,6001,7001,8001,9001,15001,25001,40001},{30,40,45,50,60,110,130,150,200})
or..
=*VLOOKUP*(D16,$A$1:$B$9,2,TRUE)
the above VLookUp fungtion refers to a table
*tabel A1:B9*
* 3001 30 *
* 5001 40 *
* 6001 45 *
* 7001 50*
* 8001 60*
* 9001 110*
*15001 130*
: $$Excel-Macros$$ Query
Dear Experts,
For this chart
3001-5000 = 30
5001-6000 = 40
6001-7000 = 45
7001-8000 = 50
8001-9000 = 50
9001-15000 = 110
15001-25000 = 130
25001-4 = 150
40001= =200
I use this formula:
=IF(AND(D16=3001,D16=5000),30,IF(AND(D16=5001,D16=6000),40,IF(AND(D16=6001
Dear Experts..
Please find attached query sheet...I want to add a seperate row after every
semicolon..
Please see attached sheet..
--
Thanks regards,
Noorain Ansari
--
--
Some important links for excel users:
1.
Ww
NOORAIN ANSARI noorain.ans...@gmail.com escreveu:
Dear Experts..
Please find attached query sheet...I want to add a seperate row after every
semicolon..
Please see attached sheet..
--
Thanks regards,
Noorain Ansari
--
There is no attachment
On Thu, Feb 24, 2011 at 6:33 PM, Joao Matoso jcmat...@gmail.com wrote:
Ww
NOORAIN ANSARI noorain.ans...@gmail.com escreveu:
Dear Experts..
Please find attached query sheet...I want to add a seperate row after
every
semicolon..
Please see attached sheet..
--
Thanks Ashish, Its nice, please explain how this formula is working
On Thu, Feb 17, 2011 at 5:29 AM, ashish koul koul.ash...@gmail.com wrote:
Maximum 4 classifications
1) Regular
2) Substandard
3) Doubtful
4) Loss
On Tue, Feb 15, 2011 at 8:34 PM, ashish koul koul.ash...@gmail.com wrote:
will it be these three classifications only
On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad
aamirshahza...@gmail.comwrote:
Thanks *Ashish *for
Thanks *Ashish *for reply but can you please provide formula without pivot.
Condition you have understand that if sum of any classification is grater
then others,it shows that value.
On Tue, Feb 15, 2011 at 8:14 AM, ashish koul koul.ash...@gmail.com wrote:
On Tue, Feb 15, 2011 at 12:16 AM,
will it be these three classifications only
On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Thanks *Ashish *for reply but can you please provide formula without
pivot. Condition you have understand that if sum of any classification is
grater then others,it shows
Hi all experts,
Please resolve my query by formula. sheet attached.
Regards,
Aamir Shahzad
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Hi all experts,
Please resolve my query by formula. sheet attached.
Regards,
Aamir Shahzad
--
--
Some important links for
Hi all experts,
Please resolve my query by formula. sheet attached.
Regards,
Aamir Shahzad
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi Thamu,
I don't know what is the need for the comparison of 2003 2007 excel column
versions since the query is not very much related to the 2003 column issue.
I agree that the column will be the issue in Excel 2003 when the repetition
of UNIQUE IDNO goes beyond 127 times then we could not
Dear Ankur Pandey
You cannot able to keep it in a single row If you have large amount of data.
Because Excel 2003 has only 256 columns and excel 2007 has only 16384
columns.
Thanks Regards
Thamu
On Thu, Jan 27, 2011 at 2:55 PM, ankur ankurpande...@gmail.com wrote:
hi excel experts
i need
thank you
On Wed, Jan 19, 2011 at 9:55 AM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi Aamir,
Have a look at the attached.
Regards - Dave.
--
Date: Tue, 18 Jan 2011 23:28:27 +0500
Subject: Re: $$Excel-Macros$$ Query
From: aamirshahza...@gmail.com
Hi Aamir,
Have a look at the attached.
Regards - Dave.
Date: Tue, 18 Jan 2011 23:28:27 +0500
Subject: Re: $$Excel-Macros$$ Query
From: aamirshahza...@gmail.com
To: excel-macros@googlegroups.com
Thanks for reply, now attached sheet is very clear.
Aamir Shahzad
On Tue, Jan 18, 2011 at 10
Dear experts,
How to resolved attached query, can anybody tell formula not macro.
Regards,
Aamir Shahzad
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Sorry Aamir, Can't understand the question. If your worksheet had a cell with
the desired answer in it (entered manually) this may help me understand your
request.
Regards - Dave.
From: aamirshahza...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query
Date: Mon, 17
.
Regards - Dave.
--
From: aamirshahza...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query
Date: Mon, 17 Jan 2011 23:31:49 +0500
Dear experts,
How to resolved attached query, can anybody tell formula not macro.
Regards,
Aamir
Dear Amir,
Pl provide more clarity wid complete example.
a href=http://www.signaturebar.com/img src=
http://www.signaturebar.com/uploads/images/24667.png border=0/a
On Tue, Jan 18, 2011 at 12:01 AM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Dear experts,
How to resolved attached
Dear All Members,
Here I am postin excel sheet..
*Problem :
*
*when I select the NAME I want the POLICY NOS. of that perticular
NAME only in the Drop List menu.*
For Ex. If I selet the name as Nikhil then all the policy Nos. of NIKHIL
only.
Pl help me out to solve my problem..I DO Not Want
2 décembre 2010 08:23
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Query
Dear All Members,
Here I am postin excel sheet..
Problem :
when I select the NAME I want the POLICY NOS. of that perticular
NAME only in the Drop List menu.
For Ex. If I selet the name as Nikhil
Hi Nikhil,
Please find attached solved sheet.
Thanks Regards
Mukesh
On Thu, Dec 2, 2010 at 12:53 PM, Nikhil Shah nikhil201...@gmail.com wrote:
Dear All Members,
Here I am postin excel sheet..
*Problem :
*
*when I select the NAME I want the POLICY NOS. of that perticular
NAME only
On Thu, Dec 2, 2010 at 12:53 PM, Nikhil Shah nikhil201...@gmail.com wrote:
Dear All Members,
Here I am postin excel sheet..
*I used vlookup formula plz see attchmt
*
--
--
Some important links for excel
))
as the source data.
Best regards.
Daniel
*De :* excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
*De la part de* Nikhil Shah
*Envoyé :* jeudi 2 décembre 2010 08:23
*À :* excel-macros@googlegroups.com
*Objet :* $$Excel-Macros$$ Query
Dear All Members,
Here I am
$3))
as the source data.
Best regards.
Daniel
*De :* excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
*De la part de* Nikhil Shah
*Envoyé :* jeudi 2 décembre 2010 08:23
*À :* excel-macros@googlegroups.com
*Objet :* $$Excel-Macros$$ Query
Dear All Members,
Here
Dear Experts,
Please solve my problem. How can we copy only filtered data in Excel.
--
Thanks in advance..
Noorain Ansari
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
Xls 2003
Select Data
Copy Data
Past Data
Past Only Filter Data
On Fri, Oct 15, 2010 at 2:04 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Experts,
Please solve my problem. How can we copy only filtered data in Excel.
--
Thanks in advance..
Noorain Ansari
--
Dear All,
Pl help out my query..
*Starting Dt.01/04/1998 ( Format dd/mm/ )
Ending Dt. 31/03/2003 ( Format dd/mm/ )*
Loan Dt ( Format should dd/mm/ )
*[ 1 ]* Loan Dt should be between Starting Dt. And Ending Dt...What is
formula ?
*[ 2 ]..*... If Loan Dt is below
Hi,
Please use Data Validation Select the Date option from Allow dropdown
and mention the start and end date in that.
If you are not satisfied with the above please send a sample data and
the group members will reply..
Thanks
Vinod N
On Sat, Jul 10, 2010 at 2:59 PM, Nikhil Shah
Hi Friends,
Here I am sending One Query, pl Give the formula..
Date : 31/03/2011 ( Format is dd/mm/ )
Deduct : 6 ( Months )
Answer Should be : 30/09/2010
Thanks
Nikhil Shah
--
--
Some important links for
Hi Nikhil,
Try below formula:-
=DATE(YEAR(C3),MONTH(C3)-6,DAY(C3))
Note:- Day portion of Date may vary as per the exact calculation, please
revert if you need 31 or 30 as the date every time.
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
Hi,
If original date is in A1:
=EOMONTH(A1,-6)
Regards - Dave.
Date: Wed, 7 Jul 2010 16:36:18 +0530
Subject: $$Excel-Macros$$ Query - How To Find out Month
From: nikhil201...@gmail.com
To: excel-macros@googlegroups.com
Hi Friends,
Here I am sending One Query, pl Give the formula..
Date : 31
You are welcome Nikhil..!!
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Wed, Jul 7, 2010 at 6:17 PM, Nikhil Shah nikhil201...@gmail.com wrote:
Hi Dilip
Thanks for sending me
Assuming your current date is in a1 cell
=date(year(a1),month(a1)-6,day(a1))
Please let me know,if this works
On Wed, Jul 7, 2010 at 4:06 AM, Nikhil Shah nikhil201...@gmail.com wrote:
Hi Friends,
Here I am sending One Query, pl Give the formula..
Date : 31/03/2011 ( Format is
Hi
You can use the below formulae for calculation as required:
=EDATE(31-mar-2011,-6)
Regards
Rajender Soni
On Jul 7, 5:21 pm, Avinash Daga avinashdag...@gmail.com wrote:
Assuming your current date is in a1 cell
=date(year(a1),month(a1)-6,day(a1))
Please let me know,if this works
Sub CustomQuery()
Dim cat As ADOX.Catalog
Dim cmd As ADODB.Command
Dim strPath As String
Dim newStrSQL As String
Dim oldStrSQL As String
Dim strQryName As String
Dim myArr()
Dim objCell As Object
Dim lstRow As Long
lstRow = Cells(Rows.Count, A).End(xlUp).Row
ReDim myArr(0 To lstRow - 2)
'lastrow
Sub CustomQuery()
Dim cat As ADOX.Catalog
Dim cmd As ADODB.Command
Dim strPath As String
Dim newStrSQL As String
Dim oldStrSQL As String
Dim strQryName As String
Dim myArr()
Dim objCell As Object
Dim lstRow As Long
lstRow = Cells(Rows.Count, A).End(xlUp).Row
ReDim myArr(0 To lstRow - 2)
'lastrow
I want to insert data in excel thru access db. Please help, how to save
data in variables in VBA in excel. I have to save this data in different
cells as per my requirement.
Please send any sample query with insert update queries with sample
database.
Thanks in advance
Malek Sarfraj
Respected Excel Friends,
Attached please find the excel sheet -- in which i have explained my query.
Try to resolve it
Thanks
J C SHAH
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video
Hi All Champs,
I have a spreadsheet where in every month some customers are being added per
client, now some clients have left during some month, my problem is I am not
able to get the net customers every month after deducting the customers who
have left. lets for simplicity sake think of clients
Hellow all excel guru's friends.
I have some query -- or i want to know the shortcuts.
1] Can we delete the name given to particular cell in name box - if we
type F5 - the name box appear
I would like to know how to change the name and delete the name given to
some reference.
2] There
HAPPY DIWALI NEW YEAR TO ALL OUR EXCEL GURU’S FRIENDS
Attached please find the Excel –tips –Query No.3 File
In Sheet 1 – All the details given
In sheet 2 – Types of Reports required
In sheet 3 – Other type of Summery reports required
Thanks in advance for using the mastermind to
How to put zero ('0') in Blank Cells scattered in a table?
-
Ankur Satija, Consultant
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA
Hello, everyone. This is my first post. I've looked high and low for
an answer to this problem.
I'm making a form in Excel to easily input data. I want to operate it
with the keyboard as much as possible. There is a section of my form
with four radio buttons. I want the captions above the
Respected Group memebers,
Attach please find the query file no.3 ---
I would like to know the macro to do the necessary entries as shown in the
files.
Thanks - have a nice day.
--~--~-~--~~~---~--~~
Dear All
I have excel file with 10,000 email id in one column. I want to send mail to
all of these. i have to put , or ; at every email id so that it could be
send to all. How can i do it
pl tell help me -.
regards
--
Amit Arora
--~--~-~--~~~---~--~~
201 - 293 of 293 matches
Mail list logo