RE: $$Excel-Macros$$ Query.

ma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf 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 wrote:

Re: $$Excel-Macros$$ Query.

Thanks... On Tue, May 1, 2012 at 12:25 PM, Shaik Waheed 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) >> >> -- >> Reg

Re: $$Excel-Macros$$ Query.

Hi, PFA On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar wrote: > 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 > >

$$Excel-Macros$$ Query.

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 thre

Re: $$Excel-Macros$$ Query (Remove duplicate)

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 * On Mon, Mar 19, 2012 at 1:07 PM, Karan Singh wrote: >

Re: $$Excel-Macros$$ Query (Remove duplicate)

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 Application.S

Re: $$Excel-Macros$$ Query (Remove duplicate)

Go to data- remove duplicates Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: Karan Singh Sender: excel-macros@googlegroups.com Date: Mon, 19 Mar 2012 13:07:52 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query (Remove duplicate) Dear

RE: $$Excel-Macros$$ Query

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$$ Qu

Re: $$Excel-Macros$$ Query

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.

RE: $$Excel-Macros$$ Query

ot;"),"") This will use the maximum of the MAINs for a given ID. Array formula, confirm entry with CSE (ctrl-shift-enter): =IF($C2<>"MAIN",IF($B2>MAX(IF(($A$2:$A$16=$A2)*($C$2:$C$16="MAIN"),$B$2:$B$1 6)),"Greater than Main",""),"")

Re: $$Excel-Macros$$ Query

ven ID. Array formula, confirm entry with CSE (ctrl-shift-enter): =IF($C2<>"MAIN",IF($B2>MAX(IF(($A$2:$A$16=$A2)*($C$2:$C$16="MAIN"),$B$2:$B$16)),"Greater than Main",""),"") Asa From: excel-macros@googlegroups.com [mailto:excel-macros@g

Re: $$Excel-Macros$$ Query

=IF(B2>SUMPRODUCT(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@googlegr

RE: $$Excel-Macros$$ Query

the MAINs for a given ID. Array formula, confirm entry with CSE (ctrl-shift-enter): =IF($C2<>"MAIN",IF($B2>MAX(IF(($A$2:$A$16=$A2)*($C$2:$C$16="MAIN"),$B$2:$B$1 6)),"Greater than Main",""),"") Asa From: excel-macros@googlegro

$$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,

Re: $$Excel-Macros$$ Query continuous copy paste

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 wrote: > The code I gave was exactly for assigning any number of header groups. > >

Re: $$Excel-Macros$$ Query continuous copy paste

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

Re: $$Excel-Macros$$ Query continuous copy paste

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 will

Re: $$Excel-Macros$$ Query continuous copy paste

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 wrote: > Sub Consolidator() > > Dim rngSource As Range > Dim lngCols As Long, lngRows As Long > Set rngSource = Range("A1").CurrentRegion > lngRows = rngS

Re: $$Excel-Macros$$ Query continuous copy paste

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, 2

Re: $$Excel-Macros$$ Query continuous copy paste

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 wrote: > > Sub kTest() > > Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long, p As Long > >

Re: $$Excel-Macros$$ Query continuous copy paste

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)

Re: $$Excel-Macros$$ Query continuous copy paste

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 in

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 in which some workbooks contains 2 columns similar, some 3 columns

Re: $$Excel-Macros$$ Query continuous copy paste

- 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 is

Re: $$Excel-Macros$$ Query continuous copy paste

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 wrote: > 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

Re: $$Excel-Macros$$ Query continuous copy paste

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 acco

RE: $$Excel-Macros$$ Query continuous copy paste

ntireRow.Insert .Range("A1").Value = "Name" .Range("B1").Value = "No" End With Application.ScreenUpdating = False End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of M

$$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 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 tha

Re: $$Excel-Macros$$ query about translate

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

Re: $$Excel-Macros$$ query about translate

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 to translate all name and add. in english > > > > > &g

RE: $$Excel-Macros$$ query about translate

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 to

Re: $$Excel-Macros$$ query about translate

Dear Noorain   Anil want to do like under written   Jh yksds'k dqekj vxzoky  to  Shri Lokesh Kumar Aggarwal From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Friday, 20 January 2012 2:13 PM Subject: Re: $$Excel-Macros$$ query

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) 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

RE: $$Excel-Macros$$ query about translate

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, this

Re: $$Excel-Macros$$ query about translate

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

Re: $$Excel-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, 2

$$Excel-Macros$$ query about translate

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, lik

Re: $$Excel-Macros$$ Query from URL

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

$$Excel-Macros$$ Query from URL

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 http://weather.uwyo.ed

Re: $$Excel-Macros$$ Query on dd-mm & mm-yy format

Thanks Sam, I think my problem is solved. Regards, Suyog On Wed, Nov 16, 2011 at 12:01 AM, Sam Mathai Chacko wrote: > > =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, Su

Re: $$Excel-Macros$$ Query on dd-mm & mm-yy format

=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 wrote: > Hello Noorain, > > Thanks for quick response but I've added two problems in same excel. > Please review & advi

Re: $$Excel-Macros$$ Query on dd-mm & mm-yy format

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 wrote: > Dear Suyog, > > Please see attached sheet. > > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogs

Re: $$Excel-Macros$$ Query on dd-mm & mm-yy format

Dear Suyog, Please see attached sheet. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Nov 15, 2011 at 10:32 AM, Suyog Kulkarni wrote: > Hello

Fwd: $$Excel-Macros$$ Query on dd-mm & mm-yy format

which are in correct format. Please review. Thanks & regards, Suyog K -- Forwarded message -- From: Suyog Kulkarni Date: Tue, Nov 15, 2011 at 10:32 AM Subject: $$Excel-Macros$$ Query on dd-mm & mm-yy format To: excel-macros@googlegroups.com Hello Friends, Find attached

$$Excel-Macros$$ Query on dd-mm & mm-yy format

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

Re: [bulk] $$Excel-Macros$$ Query related to subtotal and condition

g = True > End Sub > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Siraj Momin (BTG) > *Sent:* Saturday, November 12, 2011 1:13 AM > *To:* excel-macros@googlegroups.com > *Subject:* RE: [bulk] $$Excel-Macros$$ Query related to subtotal and &g

RE: [bulk] $$Excel-Macros$$ Query related to subtotal and condition

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

Re: $$Excel-Macros$$ Query related to subtotal and condition

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 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. Please solve my > p

$$Excel-Macros$$ Query related to subtotal and condition

Dear All members, I am attaching herewith a file regarding tds and the requirement is mention in that file related to subtotal and conditions. Please solve my problem . Thanks to all in advance Regards LKModi 9309243685 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ Query regarding serial no.

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://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Query regarding serial no.

HI Ankit, Find the attachment. On Tue, Oct 25, 2011 at 9:42 AM, Ankit Agrawal wrote: > Dear Expert, > > Plz solve out attached query. > > Regards, > Ankit > > -- > > -- > Some important links for excel users: > 1. Fo

$$Excel-Macros$$ Query regarding serial no.

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

Re: $$Excel-Macros$$ Query

Thanks a lot dear On 28 July 2011 18:32, ashish koul wrote: > SUBSTITUTE(F1&TEXT(G1,"ddmmyyy")," ","") > > > On Thu, Jul 28, 2011 at 5:13 PM, Hari wrote: > >> dear members, >> >> can any one solve my query with help of formula, i am very poor in MS >> excel. >> >> find the attachement, reply a

Re: $$Excel-Macros$$ Query

SUBSTITUTE(F1&TEXT(G1,"ddmmyyy")," ","") On Thu, Jul 28, 2011 at 5:13 PM, Hari 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. > > -- > Yours, >

RE: $$Excel-Macros$$ Query

: $$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

Re: $$Excel-Macros$$ Query

=*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* *2500

$$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,D16<=7000),45,IF

Re: $$Excel-Macros$$ Query: Seprate Row after every Semicolonq

There is no attachment On Thu, Feb 24, 2011 at 6:33 PM, Joao Matoso wrote: > Ww > > NOORAIN ANSARI escreveu: > > >Dear Experts.. > > > >Please find attached query sheet...I want to add a seperate row after > every > >semicolon.. > > > >Please see attached sheet.. > > > >-- > >Thanks & regards,

Re: $$Excel-Macros$$ Query: Seprate Row after every Semicolonq

Ww NOORAIN ANSARI 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 > >-- >---

$$Excel-Macros$$ Query: Seprate Row after every Semicolon

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.

Re: $$Excel-Macros$$ Query

Thanks Ashish, Its nice, please explain how this formula is working On Thu, Feb 17, 2011 at 5:29 AM, ashish koul wrote: > > > IF(MAX(SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),SUMIFS(C:C,A:A,A4,B:B,"Regular"),SUMIFS(C:C,A:A,A4,B:B,"Loss"),SUMIFS(C:C,A:A,A4,B:B,"Substandard"))=SUMIFS(C:C,A:A,A4,B:B,"Doubt

Re: $$Excel-Macros$$ Query

IF(MAX(SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),SUMIFS(C:C,A:A,A4,B:B,"Regular"),SUMIFS(C:C,A:A,A4,B:B,"Loss"),SUMIFS(C:C,A:A,A4,B:B,"Substandard"))=SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),"Doubtful",IF(MAX(SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),SUMIFS(C:C,A:A,A4,B:B,"Regular"),SUMIFS(C:C,A:A,A4,B:B,"Loss"),SUMIFS(C

Re: $$Excel-Macros$$ Query

Maximum 4 classifications 1) Regular 2) Substandard 3) Doubtful 4) Loss On Tue, Feb 15, 2011 at 8:34 PM, ashish koul wrote: > will it be these three classifications only > > > On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad > wrote: > >> Thanks *Ashish *for reply but can you please provide formu

Re: $$Excel-Macros$$ Query

will it be these three classifications only On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad wrote: > 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

Re: $$Excel-Macros$$ Query

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 wrote: > > > On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad > wr

Re: $$Excel-Macros$$ Query

On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad wrote: > > Hi all experts, > > Please resolve my query by formula. sheet attached. > > Regards, > > Aamir Shahzad > > -- > > -- > Some important links for excel users: >

$$Excel-Macros$$ Query

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 : http://twitter.com/excelda

$$Excel-Macros$$ Query

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 : http://twitter.com/excelda

Re: $$Excel-Macros$$ query for a solution

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 abl

Re: $$Excel-Macros$$ query for a solution

hi tamu thnks for quick reply i need only bill no. and amount in single row. for every unique id new row is needed. max 50 bill no. are their in respect to a single unique id. i hope now i m clear . On Thu, Jan 27, 2011 at 4:59 PM, TG T wrote: > Dear Ankur Pandey > > You cannot able to keep

Re: $$Excel-Macros$$ query for a solution

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 wrote: > hi excel experts > i need one help > i need da

Re: $$Excel-Macros$$ Query

thank you On Wed, Jan 19, 2011 at 9:55 AM, Dave Bonallack wrote: > 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...@g

RE: $$Excel-Macros$$ Query

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

Re: $$Excel-Macros$$ Query

ry 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

Re: $$Excel-Macros$$ Query

Dear Amir, Pl provide more clarity wid complete example. http://www.signaturebar.com/>http://www.signaturebar.com/uploads/images/24667.png border=0> On Tue, Jan 18, 2011 at 12:01 AM, Aamir Shahzad wrote: > Dear experts, > > > > How to resolved attached query, can anybody tell formula not macro

Re: $$Excel-Macros$$ Query

t; 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 anybod

RE: $$Excel-Macros$$ Query

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: Mo

$$Excel-Macros$$ Query

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 : ht

$$Excel-Macros$$ Query Excel File

Hello Friends, Below is a snapshot of code I use to query any excel worksheet having tabular data. Do somebody have idea how to query excel file if i need distinct value from a particular column or I want to use some type of query like updated? ***

Re: $$Excel-Macros$$ Query

7,$E$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 >

Re: $$Excel-Macros$$ Query

t; > 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 :* $$Exc

Re: $$Excel-Macros$$ Query

On Thu, Dec 2, 2010 at 12:53 PM, Nikhil Shah wrote: > Dear All Members, > > Here I am postin excel sheet.. > > *I used vlookup formula plz see attchmt > * > > -- > > -- > Some important links for excel users: > 1. Fol

Re: $$Excel-Macros$$ Query

Hi Nikhil, Please find attached solved sheet. Thanks & Regards Mukesh On Thu, Dec 2, 2010 at 12:53 PM, Nikhil Shah 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 in the Dr

RE: $$Excel-Macros$$ Query

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.

$$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 then all the policy Nos. of NIKHIL only. Pl help me out to solve my problem..I DO Not

$$Excel-Macros$$ Query regarding macros

Hi Everyone i have two workbook , workbook 1 workbook 2. I make macro in workbook 1. now i want to run macro in workbook2. How i can run macro independly in every workbook. Is there any solution . Thanks -- -- Some

Re: $$Excel-Macros$$ Query :- Copy Only Filtered Data in Excel..

Dear Ansari, After filtering the data,select the filtered data and then press Alt+;(Select Visible cells Only) the you can paste only the filtered data any were you want. Regards, Vijaykumar -- -- Some important l

Re: $$Excel-Macros$$ Query :- Copy Only Filtered Data in Excel..

Hi Noorain, Use filter then ctrl+ shift + * (*above alphabet U and I) other alternative is Advance Filter. Thanks, Saber On Fri, Oct 15, 2010 at 2:04 PM, NOORAIN ANSARI wrote: > Dear Experts, > > Please solve my problem. How can we copy only filtered data in Excel. > > -- > Thanks in advance..

Re: $$Excel-Macros$$ Query :- Copy Only Filtered Data in Excel..

Xls 2003 Select Data Copy Data Past Data Past Only Filter Data On Fri, Oct 15, 2010 at 2:04 PM, NOORAIN ANSARI wrote: > Dear Experts, > > Please solve my problem. How can we copy only filtered data in Excel. > > -- > Thanks in advance.. > Noorain Ansari > > -- > > ---

$$Excel-Macros$$ Query :- Copy Only Filtered Data in Excel..

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 link

Re: $$Excel-Macros$$ Query - Date Formula

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 wrote:

$$Excel-Macros$$ Query - Date Formula

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 St

Re: $$Excel-Macros$$ Query - How To Find out Month

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 wrote: > 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,

Re: $$Excel-Macros$$ Query - How To Find out Month

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 wrote: > Hi Friends, > > Here I am sending One Query, pl Give the formula.. > > Date : 31/03/2011 ( Format is dd/mm/ ) > Deduct : 6 (

Re: $$Excel-Macros$$ Query - How To Find out Month

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 wrote: > Hi Dilip > > Thanks for sending me formula..I have apply this

RE: $$Excel-Macros$$ Query - How To Find out Month

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

Re: $$Excel-Macros$$ Query - How To Find out Month

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 dilipan...@gmai

$$Excel-Macros$$ Query - How To Find out Month

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 e

$$Excel-Macros$$ Query Access from Excel; Results End Up in Excel

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

$$Excel-Macros$$ Query Access from Excel; Results End Up in Excel

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

<    1   2   3   4   >