HI Hamed,
Attachment is missing...
On Sun, Mar 11, 2012 at 12:43 PM, Gulam Hameed wrote:
> Dear Noorain & experts
>
> ** **
>
> I want make invoice in easy & shortcut method like eg: order number 8241
> 2012, it has 12 items codes, Description, Price Qty & Total Amount,
>
> I need so
Dear Noorain & experts
I want make invoice in easy & shortcut method like eg: order number 8241
2012, it has 12 items codes, Description, Price Qty & Total Amount,
I need some kind of VBA code which give all order details once select order
No in cell (G5) all the data pertaining with that pa
HI Don,
is this possible in pivot table ? .. i have three columns..a b & c.
a & b --having some order nos..& invoice no
& C is date..--todays, toms & earilier date..
if its earlier date -order nos & invo no.. should changeto red..
todays date - blue & toms date --green colr.. order
Hi Jim,
Not sure exactly what your process is, but try following the steps here:
http://www.contextures.com/xlpivot07.html#Week
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jim
Sent: Friday, March 09, 2012 4:44 PM
To: MS EX
Hi Aamir,
Should there be only one "main" per ID? ID 1 has two mains.
This formula will give your desired result based on the sum of the MAINs for
a given ID:
=IF($C2<>"MAIN",IF($B2>SUMIFS($B$2:$B$16,$A$2:$A$16,$A2,$C$2:$C$16,"MAIN"),"
Greater than Main",""),"")
This will use the average
Hi All,
I have attached a file to show my challenge. The file shows one column with
colors in cells and second column empty, but I want to add RGB Values
automatically using VBA. Help please.
cheers
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate threa
Hi Dear members,
I am new to this group.
thnx in adv.
--
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 ma
--
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 post a question in the thre
I'm using Group by Day with 7 days to create the following example:
1/1/2012 - 1/7/2012
1/15/2012 - 1/21/2012
1/22/2012 - 1/28/2012
1/29/2012 - 2/4/2012
1/8/2012 - 1/14/2012<- out of order
2/12/2012 - 2/18/2012
2/19/2012 - 2/25/2012
2/26/2012 - 3/3/2012
2/5/2012 - 2/11/2012 <-- out o
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,
isnumber is based on the SEARCH returning same
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Brian
Sent: Saturday, March 10, 2012 10:53 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Match text to a list
Thank you Kris, your solution works pe
Thank you Kris, your solution works perfectly. I was just wondering why
you use "IsNumber" when it is actually text I am looking for? I mean it
works but I am just curious.
On Saturday, March 10, 2012 11:06:57 AM UTC+2, Brian wrote:
>
> I am using Excel 2007
> In cell D18 I have some text.
>
You are welcome . .
Cheers :)
-
Thanks & Regards,
DILIP KUMAR PANDEY, mvp
MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi -62, India
On Mar 10, 2012 7:48 PM, "Mohammed Muneer" wrote:
> ** ** **
>
> Dear Dilip Thanx,
>
> ** **
>
> ** **
I make it my practice to not do that since then I may have to write it down,
etc. You need to explain in an email if you want my help.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Amit Desai (MERU)
Sent: Friday, March 09, 2012 10:30 PM
To: excel-macros@googlegro
I didn’t read it COMPLETELY. Still like pure vba better.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Kris
Sent: Saturday, March 10, 2012 8:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Match text to a list
So what ?
On Saturday, 1
So what ?
On Saturday, 10 March 2012 19:10:11 UTC+5:30, Don Guillett wrote:
>
> > In cell D18 I have some text.
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Kris
> *Sent:* Saturday, March 10, 2012 4:55 AM
> *To:* excel-macros@googlegroups
> In cell D18 I have some text.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Kris
Sent: Saturday, March 10, 2012 4:55 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Match text to a list
Hi
Sub kTest()
Dim Flg As Boolean
F
Look in the help index for FIND then incorporate into an if/end
set mf=find>>>
if not mf is nothing then
do this
else
do that
end if
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Brian
Sent: Saturday, March 10, 2012 3:06 AM
To: excel-macros@googlegroups.com
Su
Hi,
It's an array formula. Confirmed with CTRL + SHIFT + ENTER
Kris
On Saturday, 10 March 2012 17:34:19 UTC+5:30, Ashish_Bhalara wrote:
>
>
> Dear sir,
>
> I write your condition but there are no result display in the cell, I
> don't know whats happen with this formula, please see attached file
Dear Ashish,
Click on below link to learn about Multi Sheet Pivot.
http://office.microsoft.com/en-us/excel-help/consolidate-multiple-worksheets-into-one-pivottable-report-HA010226585.aspx
Thanks
Ahmed Bawazir
On Sat, Mar 10, 2012 at 3:09 PM, Ashish Bhalara
wrote:
> Dear sir,
>
> Please tell me
Hi
Sub kTest()
Dim Flg As Boolean
Flg = Evaluate("ISNUMBER(LOOKUP(9.999E+307,SEARCH(D18,L6:L27)))")
If Not Flg Then
'do something
End If
End Sub
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. P
Hi Muneer,
See the attachment where I have created a mutisheet pivot.
Use:- For example, if you have the scores of a team against different
matches and you wanted to sum the scores, you can use a multisheet pivot in
this case, see the attachment and look in sheet "pivot" which have the data
from t
I am getting an error on
i = Application.WorksheetFunction.Match(Source, target)
On Saturday, March 10, 2012 11:06:57 AM UTC+2, Brian wrote:
> I am using Excel 2007
> In cell D18 I have some text.
> I need the VBA to check if this text appears in the list in Cells L6:L27
> If it does it then exit
bpascal,
> Dim Comp() As String
> Dim PartR() As String
>
> So the sub would be:
> call BellyDance(CompBis(), PartBis(), wksA, wksB, wksC)
> or
> BellyDance CompBis(), PartBis(), wksA, wksB, wksC
Actually, you call the arrays one thing when you declare them with DIM and
something else I nyour pr
Hi Brian,
You can include the following code in your macro:-
Sub chk()
Source = Range("d18")
target = Range("L6:l27")
i = Application.WorksheetFunction.Match(Source, target)
If i >= 0 Then
'continued.. paste your code here
End If
End Sub
Regards,
DILIPandey
On Sat, Mar 10, 2012 at 2:36 PM,
I am using Excel 2007
In cell D18 I have some text.
I need the VBA to check if this text appears in the list in Cells L6:L27
If it does it then exits the sub otherwise it must do something else.
Can anyone help with this code.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use con
Hi
check whether this helps !
http://chandoo.org/wp/2011/08/03/create-powerpoint-presentations-using-excel-vba/
HTH
Mahesh
On Fri, Mar 9, 2012 at 11:34 AM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:
>
> hi experts,
>
> Need your expert advise.
>
> please provide a vba code
27 matches
Mail list logo
