Hi Anil,
Try yourself with below online tutorial. if you need help, you can revert.
http://www.excel-pratique.com/en/vba.php
.
Enjoy
Team XLS
On Tue, Jul 29, 2014 at 1:46 PM, anil nim anilnim1...@gmail.com wrote:
Dear all,
I want to learn Macros and VBA from any
IN WHICH COMPANY...
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of KATHIRVELAN N
Sent: Saturday, March 08, 2014 6:41 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help me for interview : Excel Formulas and Macros
Dear Friends,
I
Dear Thameem,
Open attached file. I have applied rule what you have asked.
just select from cell A2:C4 and go to conditional formatting-manage rules.
It will be cleared.
On Sat, Jun 22, 2013 at 2:56 PM, thameem thamee...@gmail.com wrote:
Dear all,
Plz find attached file, its sample, I want
thank you bro
On Wed, Jul 3, 2013 at 3:00 PM, Waseem Saifi waseemsa...@gmail.com wrote:
Dear Thameem,
Open attached file. I have applied rule what you have asked.
just select from cell A2:C4 and go to conditional formatting-manage rules.
It will be cleared.
On Sat, Jun 22, 2013 at 2:56
In attached file, please see the conditional formating formula and range
to apply
Rgds,
[dp]
Pada 22/06/2013 16:26, thameem menulis:
Dear all,
Plz find attached file, its sample, I want high for range of cells,
only at that condition, plz help me to learn, for condition or sample
find
SORRY , I need high only for 3 condition... there is zero in row 2 also,
in my data alot of zero are there... because still my data is on process
not yet freeze... so it can change.. once it get freeze, we can apply C3=0
or c2=0 condition, but to freeze data, it will take 2 more months, but i
can you provide us more raw data in excel with some example that meet
your requirement to make it more clearly to understand !
Rgds
[dp]
Pada 22/06/2013 17:21, thameem menulis:
SORRY , I need high only for 3 condition... there is zero in row 2
also, in my data alot of zero are there...
Plz check attached file
On Sat, Jun 22, 2013 at 2:39 PM, De Premor d...@premor.net wrote:
can you provide us more raw data in excel with some example that meet
your requirement to make it more clearly to understand !
Rgds
[dp]
Pada 22/06/2013 17:21, thameem menulis:
SORRY , I need
Attached, new rule based on C 0 and D=0
Rgds,
[dp]
Pada 22/06/2013 18:03, thameem menulis:
Plz check attached file
On Sat, Jun 22, 2013 at 2:39 PM, De Premor d...@premor.net
mailto:d...@premor.net wrote:
can you provide us more raw data in excel with some example that
meet your
Thank you, it working fine, I will update in my file now, thank you once
again.
regards,
Thameem.m
On Sat, Jun 22, 2013 at 4:42 PM, De Premor d...@premor.net wrote:
Attached, new rule based on C 0 and D=0
Rgds,
[dp]
Pada 22/06/2013 18:03, thameem menulis:
Plz check attached file
Dear Sundarvelan,
You can try this.
=INDEX($B$2:$B$20,MATCH(K2,$D$2:$D$20,0),1) Paste it I2
Ctrl+Shift+Enter.
=INDEX($C$2:$C$20,MATCH(K2,$D$2:$D$20,0),1) Paste it J2
Ctrl+Shift+Enter.
Regards,
Kuldeep Singh
On Thu, Sep 6, 2012 at 6:46 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
PFA
On Thu, Sep 6, 2012 at 12:36 PM, Sundarvelan N nsund...@gmail.com wrote:
Dear Friends,
Help me to find the circle and area. Please find the attached file for
your reference.
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
Dear Sundar,
You can use single Vlookup for both required Column
*=VLOOKUP(K2,CHOOSE({1,2,3},$D$2:$D$20,$B$2:$B$20,$C$2:$C$20),{2,3},0)
*
with ctrl+shift+enter
See attached sheet for more clarity.
On Thu, Sep 6, 2012 at 12:36 PM, Sundarvelan N nsund...@gmail.com wrote:
Dear Friends,
=INDEX($B$1:$F$20,MATCH(K2,$D$1:$D$20,0),1)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: 06 September 2012 12:37
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
“Please help me” is NOT a good subject line. Please describe your problem in
the body of your email and also attach file.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Manoj Kumar
Sent: Friday, July 20, 2012 12:43 AM
To: excel-macros@googlegroups.com
Dear Manoj,
Attachment is missing
On Fri, Jul 20, 2012 at 11:13 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Dear Expert,
Please help me
Query file attached with mail...
Regard
Manoj
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
Thanks Noorain Ji...
On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Manoj,
Please try it.
=INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0))
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
Happy to Help
On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote:
Thanks Noorain Ji...
On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Manoj,
Please try it.
Dear Kuldeep,
thanks..
I need function witch I already provide by Noorain...
On Mon, Jul 16, 2012 at 3:47 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi,
Use this
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
naukrikuld...@gmail.com || www.naukri.com
*Please*
[█ ▆ ▅ ▃ ▂★Great Noorain Sir★▂ ▃ ▅ ▆ █]
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Mon, Jul 16, 2012 at 4:21 PM, Manoj Kumar
I think you should use a pivot table for this. click anywhere in the list
and then click insert/Pivot table and follow the prompts.
On 15 May 2012 17:14, Ankit Agrawal ankit.agrawal...@gmail.com wrote:
Deal All,
I need your help on the same.
Any Confusion plz let me know.
Regards,
Ankit
Deal All,
I need your help on the same.
Any Confusion plz let me know.
Regards,
Ankit
On Fri, May 4, 2012 at 2:00 PM, Ankit Agrawal ankit.agrawal...@gmail.comwrote:
Dear all,
I have some data in one sheet and I have to generate report which format
is also on second sheet. How can we
Hello Mr Sam,
Thank you very much of your help.
Regards
Son
2011/11/28 Sam Mathai Chacko samde...@gmail.com
Great, so no modifications required for Excel 2010
The code below works for both 2003 and 2010
Sub Consolidator()
Dim rngStart As Range
Dim varArray As Range
Hi Rajan,
Thank you very much but i like macro better because it is really fast.As
you known my sheet is large with lots of rows.
Hope that your experience'll help everyone .
Regards
Son
2011/11/27 rajan verma rajanverma1...@gmail.com
Hi
Please see the attached file.. Pivot table can be
Hi Mr Sam.
I wonder this code used for which office as 2003,2007,2010.Because my
office is 2003 and result is not to like my desirement.
Hope that you can feed back more to me
Regards
son
2011/11/27 Sam Mathai Chacko samde...@gmail.com
Here's a macro to get this done
Sub Consolidator()
Son, the macro is written for 2007-10. Will send a modified version,
but before that, can you confirm the result is correct in 2007-10? If
not, what is the issue?
Sam
On 28/11/2011, son nguyen sonnguye...@gmail.com wrote:
Hi Mr Sam.
I wonder this code used for which office as
Hi Sam
I tried on office 2010 ,result is ok.Could you send me a modified version
2003 and explain for me a bit of this code as i am a beginer of VB.
Thanks a lot
Son
2011/11/28 Sam Mathai Chacko samde...@gmail.com
Son, the macro is written for 2007-10. Will send a modified version,
but
Great, so no modifications required for Excel 2010
The code below works for both 2003 and 2010
Sub Consolidator()
Dim rngStart As Range
Dim varArray As Range
Application.ScreenUpdating = 0
Range(F1).CurrentRegion.Clear
With Cells.Find(What:=Machine, Lookat:=xlWhole,
Chacko
Sent: Monday, November 28, 2011 8:32 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help me with a macro
Great, so no modifications required for Excel 2010
The code below works for both 2003 and 2010
Sub Consolidator()
Dim rngStart As Range
Dim varArray As Range
Dear son
Here with i attached excel file using sumif command.
Mothilal
On Sat, Nov 26, 2011 at 8:23 PM, son nguyen sonnguye...@gmail.com wrote:
Dear all,
I have problem of calculating sheet.Detail as sheet attached.
I want to have a macro to sum value within qty, and downtime column
Hi
Please see the attached file.. Pivot table can be used for this ..
Regards
Rajan
On Sat, Nov 26, 2011 at 8:23 PM, son nguyen sonnguye...@gmail.com wrote:
Dear all,
I have problem of calculating sheet.Detail as sheet attached.
I want to have a macro to sum value within qty, and downtime
Here's a macro to get this done
Sub Consolidator()
Dim rngStart As Range
Application.ScreenUpdating = 0
Range(F1).CurrentRegion.Clear
With Cells.Find(What:=Machine, Lookat:=xlWhole,
searchDirection:=xlNext, After:=Cells(1))
Set rngStart = Range(.Offset(1), .Offset(,
Hi Vijayajith,
Data validations can be created from one workbook to another
workbook.
Example:
Attached are the two workbook
1. Source_Book.xlsx
2. My_Book.xlsx
My list is available in Source_Book - sheet1 -
range(A1:A5)
and my validation is in workbook - My_Book.xlsx - Sheet1 -
--
*From: * vijayajith VA vijayajith...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Thu, 10 Nov 2011 19:41:37 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ help me
hi
I have
: * excel-macros@googlegroups.com
*Date: *Thu, 10 Nov 2011 07:25:57 -0600
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ help me
Post your file
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* vijayajith VA
Post your file
Don Guillett
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Thursday, November 10, 2011 6:11 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ help me
HI
I have some datas in tab with coloumns(code and name)
in one more tab with same datas but
@googlegroups.com
Date: Thu, 10 Nov 2011 07:25:57
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help me
Post your file
Don Guillett
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Thursday, November 10, 2011 6:11 AM
To: excel-macros
Please Copy in a filter mode the desired data. Then select all (alt d f s) and
in desired column use paste special (alt e s v ) and select skip blank option
there.
Hope fully it will solve ur queries.
Sandeep Chhajer.
Sent on my BlackBerryŽ from Vodafone
-Original Message-
From:
: *Re: $$Excel-Macros$$ help me
Post your file
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* vijayajith VA vijayajith...@gmail.com
*Sent:* Thursday, November 10, 2011 6:11 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ help me
HI
I have some datas
Copy values to an UN filtered destination.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Thursday, November 10, 2011 8:11 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help me
hi
I have tried using pastespecial but its working
its
--
*From: * dguillett1 dguille...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Thu, 10 Nov 2011 07:25:57 -0600
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ help me
Post your file
Don Guillett
SalesAid Software
, 10 Nov 2011 19:41:37
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help me
hi
I have tried using pastespecial but its working
its copying only two cells
can you help me ?
Pleas find the attachment
Thank you
On Thu, Nov 10, 2011 at 7
-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help me
Hi
Thank you Very much for your help.
If i run this macros.Some error is showing like VA_book1.xls is not found
error 1004
i have saved correctly in my folder i run the macros but its not working
Please help me
On Sun, Nov 6
Sent: Monday, November 07, 2011 9:35 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help me
Hi Don Guillett,
Once again thank you very much .
I those two excelbooks saved one folder and named as VA_book1.xls - (one file
-blank file)
and one more file saved as VA_book2.xls .i
try this
http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheets%20to%20sheet1%20in%20same%20workbook
On Tue, Jul 5, 2011 at 11:12 AM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
I have 30 to 40 excel sheets in one workbook..if i want to copy all the
excel sheet
@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Tuesday, July 05, 2011 2:17 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ help me urgent
try this
http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20shee
ts%20to
PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ help me urgent
** **
try this
http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheets%20to%20sheet1%20in%20same%20workbook
On Tue, Jul 5, 2011 at 11:12 AM, vijayajith VA
Hi
=ROUNDUP(5284/12,1) = 440.4
=ROUNDDOWN(440.4*12,0) = 5284
--
*Thanks Regards
Thamu
*
On Mon, May 16, 2011 at 11:57 AM, memonkavi memonk...@gmail.com wrote:
Dear sir
thanks 1nz again wat i requst that result i got from ur formula.,i
want to reverse for example i multiple 440.04 by 12
thanks alot rajan verma!!
kavi
On May 15, 9:10 pm, rajan verma rajanverma1...@gmail.com wrote:
Use minus Sign before your formula...
On Sun, May 15, 2011 at 7:27 PM, memonkavi memonk...@gmail.com wrote:
Dear Sir
This is my problem
one cartoon 12 boxes
I have 440 cartoon 4
thanks oflot Rajesh Nahawal!
kavi
On May 15, 9:32 pm, Rajesh Naharwal myxlgr...@gmail.com wrote:
Hi Dear,
Use this formula,
=roundup(5284/12,1)
*Rajesh Naharwal
On 15 May 2011 19:27, memonkavi memonk...@gmail.com wrote:
Dear Sir
This is my problem
one cartoon 12 boxes
Dear sir
thanks 1nz again wat i requst that result i got from ur formula.,i
want to reverse for example i multiple 440.04 by 12 then i got the
result on excel itz (5280.48) bt i wnt the answer as 5284 how can i
get it?
regards kavi
On May 15, 9:32 pm, Rajesh Naharwal myxlgr...@gmail.com wrote:
Use minus Sign before your formula...
On Sun, May 15, 2011 at 7:27 PM, memonkavi memonk...@gmail.com wrote:
Dear Sir
This is my problem
one cartoon 12 boxes
I have 440 cartoon 4 boxes
cartoon 440x12=5280
boxes4
Hi Dear,
Use this formula,
=roundup(5284/12,1)
*Rajesh Naharwal
On 15 May 2011 19:27, memonkavi memonk...@gmail.com wrote:
Dear Sir
This is my problem
one cartoon 12 boxes
I have 440 cartoon 4 boxes
cartoon 440x12=5280
boxes4
.
--
Date: Sun, 24 Apr 2011 09:03:05 +0530
Subject: Re: $$Excel-Macros$$ Help me in this
From: yashr...@gmail.com
To: excel-macros@googlegroups.com
Thanks Dave, for your suggestion. but problem is that i want to update all
sheets on daily basis. If i'll do this, it also
To place the top left part of the chart in , say, D15 :
ActiveChart.Parent.Top = Range(D15).Top
ActiveChart.Parent.Left = Range(D15).Left
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Hector Ruiz
Envoyé : lundi 21 février 2011
Thanks Daniel for helping me solve my problem.
Hector
2011/2/22 Daniel dcolarde...@free.fr
To place the top left part of the chart in , say, D15 :
ActiveChart.Parent.Top = Range(D15).Top
ActiveChart.Parent.Left = Range(D15).Left
HTH
Daniel
*De :* excel-macros@googlegroups.com
Hi,
I sent a reply to this email a while ago. But when I went to resend it today, I
found some errors which are now fixed. I also removed some lines of code which
weren't necessary.
I've modified your macro below.
I've used For Each / Next to loop through each cell in the UsedRange, and Like
hi vikas,
very gud yr,
but can u tell us hw did u do this,as it is locked file
pls yr its helpful for us also
thanks
On Fri, Jun 4, 2010 at 9:26 PM, Vikas Chouhan vikask...@gmail.com wrote:
hi,,
just chk..
On Fri, Jun 4, 2010 at 6:45 PM, vineet vineet_p...@yahoo.com wrote:
HI
U r always welcome.
Thanks n Best of luck.
DiLipandey
On 4/30/10, vinod rao vinod.ma...@gmail.com wrote:
Hi Dilip,
Exactly, i worked. Thank you very much.
thanks
Vinod
On Thu, Apr 29, 2010 at 1:53 PM, Dilip Pandey dilipan...@gmail.com wrote:
Dear Vinod,
Your desired solution is
Dear Vinod,
Your desired solution is attached with this email. :)
--
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 Tue, Apr 27, 2010 at 11:39 PM, vinod rao vinod.ma...@gmail.com wrote:
Dear Vinod,
Have a look in attached Zipped,It will help you.
Hope it Will Help
On Tue, Apr 27, 2010 at 11:39 PM, vinod rao vinod.ma...@gmail.com wrote:
Hello,
I want a conditional formating for the string found to be done in column F
and colour the entire row.
Example
in cell
Hello,
Please let me know what was the attachement. I am using excel 2003 and
cannot use any other.
Please assist.
Regards,
Vin
On Wed, Apr 28, 2010 at 11:58 AM, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Dear Vinod,
Have a look in attached Zipped,It will help you.
Hope it Will
Dear Abdul
One way can be pasting all the addresses in the field BCC of the mail
specifying your mail id in the field TO of the mail .
Regards
Jatin
On Fri, Jan 22, 2010 at 8:48 PM, Abdul Rasheed rashee...@gmail.com wrote:
i have a list of e-mail address on one exel sheet and
63 matches
Mail list logo