Ltd| Tel: (040)
39179113|09346062227 **yso...@magna.in* *
**www.magna.in*<http://www.magna.in/>
*|*
** **
--
*Deepak Rai*
SAS BASE CERTIFIED Programmer
Mobile: 9873415255
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, a
Hi Santanu,
Please find the solved file. Hope this is what you are looking for. :)
Regards,
Deepak Rai
On Fri, Dec 17, 2010 at 1:42 AM, Rahul Kamal Gandhi
wrote:
> Sir,
>
> As per my interpretation your output is in Attached file.
>
>
> Regards, Rahul Gandhi
> +91-97117
Hi Rohan,
This is really nice.
Regards,
Deepak Rai
On Fri, Dec 17, 2010 at 9:49 AM, Rohan Young wrote:
> Hi Hanumant,
>
> Just hit Ctrl+F go to option and in look in set the criteria on Values u
> will get that
>
> bye for now
>
> Deepak (ROHAN)
> 9818247278
>
&g
Hi,
You can also use name range for "*Source Data*" Parameter. I usually prefer
to use this in my reporting if all my input and output data are in same
workbook.
Regards,
Deepak Rai
On Sat, Dec 18, 2010 at 1:35 AM, Daniel wrote:
> Hi,
>
> Change the pivottable n
Hi Alisha,
It would be really helpful if you can share a dump file.
Regards,
Deepak Rai
On Tue, Dec 7, 2010 at 4:06 PM, alisha malhotra wrote:
> Hi Group,
>
> I have one pivot table. In that I want to show the cumulative sum.
> e.g.
> Qtr1 sale:- 10 units
> Qtr2 sale:- 20
Hi,
Please find the attached solution. In sheet one I have two validation
lists, which is taking data from Sheet2. Sheet2 has named ranges.
Hope this will help you. With the help of Named Range and Indirect formula
you can do this very easily.
Regards,
Deepak Rai
On Wed, Dec 8, 2010 at 7:33
calculation
feature off by the following code :
Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub
Hope this will help you.
Regards,
Deepak Rai
On Thu, Nov 25, 2010 at 6:45 PM, girish kumar
wrote:
> Dear Experts,
>
> I have attached one VBA Code which we
Hi,
I will also suggest to use sumif function for this purpose.
Regards,
Deepak Rai
On Sun, Nov 14, 2010 at 2:51 PM, ratu elissa wrote:
> use SUMIF Formula
>
>
> On Sun, Nov 14, 2010 at 2:25 PM, bhavya khanna wrote:
>
>> Hi Everyone.
>>
>> Can someone explain I
If sh.Name = sTemp Then
MsgBox "Sheet already exist"
MsgBox sh.Name
Exit Sub
End If
Next sh
MsgBox "Sheet doesn't exist"
ActiveWorkbook.Sheets.Add
ActiveSheet.Name = sTemp
End Sub
Regards,
Deepak Rai
On Sun, Nov 14, 2010 at 2:17 PM, Krupesh Bhansali wro
t;><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&
Hi Peter,
Sure soon I will send you that consolidation macro.
Regards,
Deepak Rai
On Mon, Oct 4, 2010 at 11:08 PM, Peter Konijn wrote:
> Hi,
>
> It works, thanks a lot for your support.
>
> I am still curious for the macro of Deepak Rai.
>
>
>
> Regards Peter
Hi Ayush,
Congratulations buddy... Keep up the good work. :)
Regards,
Deepak Rai
On Sun, Oct 3, 2010 at 3:47 PM, Ayush wrote:
> Dear Group,
>
> I am proud to announce that I am awarded Microsoft Most Valuable
> Professional MVP on October 01, 2010 for providing technical expertis
Peter,
I have this macro I will customize it as per your need & will soon share the
same with you.
Regards,
Deepak Rai
On Fri, Oct 1, 2010 at 11:35 PM, Deepak Rai wrote:
> Hi Peter,
>
> For this you need to have a common folder where you can store all your Data
> files after
Hi Peter,
For this you need to have a common folder where you can store all your Data
files after that through VBA macro you can consolidate all those N numbers
of Data files into a consolidated excel file. You would not able to do this
by manual approach.
Regards,
Deepak Rai
On Fri, Oct 1
Hi Pankaj,
In your case the attached formula can also help.
Regards,
Deepak Rai
On Thu, Sep 30, 2010 at 8:58 PM, Venkat wrote:
> Dear Pankaj,
>
> Look attached resolved formula
>
> Best Regards,
>
> Venkat
> On Thu, Sep 30, 2010 at 6:28 PM, Pankaj Kumar
> wro
cel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><>&l
at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><>
3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><>&l
Hi Neil,
You can use name range for this, for example Range("Test1").select here
Test1 is a name range. Hope this will help you.
Regards,
Deepak
On Sat, Sep 11, 2010 at 2:13 PM, neil johnson wrote:
> Hi Everyone,
>
> How can we make dynamic range in excel vba. Please explain it . How can we
> f
Hi All,
Really nice logics. Keep the good work.
Regards,
Deepak
2010/9/6 सुधीर इंगळे
> Dear Kalyan
> Kindly check the attach file
> I think it solve your query
>
> Regards,
> Sudhir Ingale
>
>
> On Mon, Sep 6, 2010 at 8:47 AM, Kal xcel wrote:
>
>> Dear experts,
>>
>> I am sending a file w
Hi Kalyan,
Please find the attached solved file. Hope this will help.
Regards,
Deepak
On Mon, Sep 6, 2010 at 1:17 PM, Kal xcel wrote:
> Dear experts,
>
> I am sending a file where I need to show a series of dates after giving
> start date & end date.
>
> File is attached .
>
> Thanks in advance
Hi Pankaj,
On internet you can find lots of learning stuffs on conditional formatting
with good examples. On you tube as well there are some good video's on
conditional formatting. Hope this will help.
Regards,
Deepak
On Mon, Sep 6, 2010 at 12:43 PM, C.G.Kumar wrote:
> Follow the link;
>
>
> 1.
Hi Ankit,
Please find the attached solved file. Column highlighted with yello color
has the solution as requested.
Thanks,
Deepak
On Mon, Jul 5, 2010 at 5:59 PM, Ankit Chandna wrote:
> Hi,
>
>
> hi to all ..i need a help PFA and help me to get reqired result.
>
> Regards,
> Ankit
>
> --
>
> ---
Hi Jonas,
Can u share the code so that I can find the solution for you ?
Regards,
Deepak
daksh1...@gmail.com
On Tue, Jun 8, 2010 at 1:32 AM, Jonas wrote:
> I have code that exports a query from Access to Excel. At times I am
> unable to open the Excel file that I created. When I double clic
Hi,
You can modify your formula as =CONCATENATE("FY09-Q4",CHAR(10),"
(",TEXT(SUM(A2:A4),"0,000"),")") .
Regards,
Deepak
On Tue, Jun 8, 2010 at 8:31 PM, Sharath Sambrani <
sharath.c.sambr...@gmail.com> wrote:
> thanks Paul,
>
> it worked amazingly!
>
> :)
>
> On Tue, Jun 8, 2010 at 8:19 PM, P
Hi,
Give me a sample file I will solve this for you.
Regards,
Deepak
On Tue, Jun 8, 2010 at 8:35 PM, molinari wrote:
> I have a list of reports to be printed out Monday - Friday, where each
> worksheet is Monday, Tuesday, Wednesday, Thursday, or Friday. I made
> another worksheet to list repo
Hi,
Plz share a sample file.
Regards,
Deepak
On Sat, May 1, 2010 at 3:23 AM, LJWarren wrote:
> I have 5 major categories defined, and depending on which category is
> chosen, up to 20 sub-categories. How do I embed an "if" statement into
> my data validation? Thank you.
>
> --
>
> ---
lt;><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/exce
group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe from this group, send email to excel-macros+
> unsubscribegooglegroups.com or reply to this email with the words "REMO
riends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
> --
> Thanks For Mail.
>
> --
>
> --
> Some im
uot;B1:B10")
Hope this is what you are looking for. Please revert in case it doesn't
work.
Thanks,
Deepak Rai
On Thu, Feb 25, 2010 at 2:58 PM, Harpreet Gujral
wrote:
> The idea is to name the range and then use it within the macro for ease of
> referencing.
>
&
groups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800
t;
> > We reach over 6,800 subscribers worldwide and receive many nice notes
> about
> > the learning and support from the group.Let friends and co-workers know
> they
> > can subscribe to group at
> > http://groups.google.com/group/excel-macros/subscribe
> >
>
TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5.
.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><>&
t;><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to
any advice or alternative formula for the same. I want to do
it by formula only not by VBA.
--
Thanks,
Deepak Rai
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add
Hi Daniel,
This is what I was looking at. Its working fine. Thank you soo much for your
kind help. Fantastic solution.
Regards.
Deepak Rai
On Thu, Dec 10, 2009 at 5:38 PM, Daniel wrote:
> Hello.
>
>
>
> For instance :
>
>
>
> ConnectString = "Provi
ADO for database
connectivity with Excel. I am using Office 2007.
Any help will be highly helpful for me.
--
Thanks,
Deepak Rai
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free
subscribe to group athttp://groups.google.com/group/excel-macros/subscribe
>
> --
>
> --
> Some important links for excel users:
> 1. Exc
.
Regards,
Deepak Rai
On Mon, Dec 7, 2009 at 6:44 PM, Paul Schreiner wrote:
> I suspect you'll be waiting quite a while.
> adding a "browse button" is quite confusing.
> You might as well say: "I'd like to add a "take the dog for a walk" button"
> B
Hi,
You can use custom fromat to get that 09:00:00.
Regards,
Deepak Rai
On Tue, Dec 1, 2009 at 8:10 AM, Toddy wrote:
> I am trying to capture the time in a variable that I am using to
> populate as text into an email via Lotus Notes from Excel and VBA.
>
> When VBA picks up th
Hi,
Please try this code, Hope this will help.
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Regards,
Deepak Rai
On Tue, Dec 1, 2009 at 10:03 AM, Dave Bonallack
wrote:
> Hi,
> Try doing it manually with the macro recor
t;><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice not
Hi,
Thanks if my solution helped u, for this problem I need detailed
explanation of your problem.
Regards,
Deepak Rai
On Tue, Nov 17, 2009 at 8:56 PM, vinod rao wrote:
> Thanks Andy. Plz help me on other file about deleting columns
>
>
> On Tue, Nov 17, 2009 at 8:46 PM, Aindr
Hi,
As per my understanding I have attached a solution of it. Please find the
attached file.
Regards,
Deepak Rai
On Tue, Nov 17, 2009 at 6:45 PM, vinod rao wrote:
> Hello Team,
>
> I need a macro to change Column B from Tisp to PAT if the Column D is Core
>
>
Hi Nayan,
Please find the enclosed sample tracker. You can customize as per your need.
Regards,
Deepak Rai
On Thu, Nov 12, 2009 at 7:56 PM, Nayan K Lodaya wrote:
> Hello Anyone ,
>
> Please can you send / share leave tracker file you have for your
> organisation…as I am looking
Hi,
U can use =C3 & " " & TEXT(D3,"mmm-yy").
Regards,
Deepak Rai
On Thu, Nov 12, 2009 at 7:36 PM, Nayan K Lodaya wrote:
> =CONCATENATE(C3," ",TEXT(D3,"mmm-yy"))
>
> Hope this helps
>
>
>
> *From:* Prashanth Banneni [mailto
Hi,
I am attaching a file which is based on the same logic. U can use the same
logic for your requirement.
Hope this will help u.
Regards,
Deepak Rai
On Tue, Nov 10, 2009 at 12:11 PM, RolfJ wrote:
>
> Assuming that your country column is column A, place the following
> code int
please.
Regards,
Deepak
On Sat, Nov 7, 2009 at 6:53 PM, Deepak Rai wrote:
> Hi,
>
> Please find the enclosed attachment, hope this will help.
>
> Regards,
>
> Deepak
>
> On Fri, Nov 6, 2009 at 9:35 PM, Tony from Work wrote:
>
>>
>> Hello!
>> Giv
al to a
> certain label, for example:
>
> D 2
> B 3
> A 1
> B 2
> C 3
> A -1
> A 0
> A 3
> C 2
> A 2
> A 5
>
> I have to find the sum only of the first 3 A that are greater than
> zero; in this case the result is 6.
>
> Many t
Hi Pooja,
I would suggest to use custom category in the format cells window. In the
Type: option please type "HH:MM:SS" & apply this on the selected cell. Now
whenever u will change the time it will come in HH:MM:SS format.
Regards,
Deepak Rai
On Sun, Nov 1, 2009 at 12:03 AM, Pooj
Hi Pooja,
Please find the enclosed file with the solution.
Regards,
Deepak Rai
On Sat, Oct 31, 2009 at 9:25 PM, Pooja Sharma wrote:
> Hi All,
>
> I need your help in extracting some words (having defined format) from one
> cell in another cell. Attached is a sheet where I have m
Hi,
Why don't you use Select Case instead of IF statement ?
Regards,
Deepak Rai
On Mon, Oct 26, 2009 at 10:47 AM, Anish Shrivastava wrote:
> Hello Experts..
>
> I m using While and Wend statement in my code and it has got more than 100
> if conditions. when I run the ma
Hi Hemant,
Nice logic. It will also be very helpful.
Regards,
Deepak Rai
On Thu, Oct 22, 2009 at 7:41 PM, Deepak Rai wrote:
> Hi JP,
>
> Please find the below VBA code for the solution of your problem. Hope this
> will help you.
>
> Private Sub Workbook_SheetSelection
I would like to be able to select a cell in a worksheet and then run a
> macro to open a dialogue box to browse through folders and files on my
> computer, select a file, and insert that file path and name into the
> active cell. Can someone please help me to do this? A
al of 30 sheets with
same logic . I need it in every sheet. If there is any other alternative
or solution please help me.
Regards,
Deepak Rai
--~--~-~--~~~---~--~~
--
Some importa
On Tue, Aug 11, 2009 at 2:08 AM, Deepak Rai wrote:
> Hi,
>
> In the Developer Tools click on More Controls & then select Calender
> Control 12.0.
> Please follow the below steps to get the Calender Control:
>
> 1. Right Click on Menu Bar
> 2. Select "Customize Qu
Hi Anil,
Please find the attached sheet with answer of your query.
Regards,
Deepak Rai
On Mon, Aug 10, 2009 at 12:07 PM, Sandeep wrote:
> I Need to calculate the range as per the criteria mentioned in attached
> file please help me.
>
> >
>
>
--
down
5. Select Developer Tab
6. Select Insert Controls option
7. Don't forget to select the option "Show Quick Access Toolbar below the
Ribbon"
Hope this will help you.
Regards,
Deepak Rai
On Mon, Aug 10, 2009 at 1:38 PM, Iqbal Shaikh wrote:
> Hi ALL.
>
&g
Hi Ashish,
Press CTRL+ENTER in the cell because this is an array formula.
Regards,
Deepak Rai
Sirjee
One additional help required on ur solved work sheet regarding the problem
by Anilji. Noticed what i feel is strange behaviour.
I use Excel2007. Your formula with {=SUM(IF(E4:E8>0,E4
Hi Harris,
You can also use =IFERROR(A1,0) where A1 = #N/A.
Regards,
Deepak Rai
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Andre Dreyer
Sent: Friday, August 07, 2009 1:48 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel
Hi Anil,
Use this formula for calculating the positive value only in a row:
=SUMIF(B1:D1,">0",B1:D1)
Where B1 = 30 , C2= -20 & D2 = 60.
Hope this will help you.
Regards,
Deepak Rai
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.
t
> these can be moved around by the user after the macro has run.
>
> Thanks in advance.
>
> >
>
--
Thanks,
Deepak Rai
--~--~-~--~~~---~--~~
--
Some important lin
64 matches
Mail list logo
