budget planning/analysis, financial
plans, revenue...
Warm Regards.
*DEV ATLANTIS IT GROUP.*
*(515)399-1237*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com
Hi All,
Below is my macro code to get the items from my pivots present in different
sheets.
Sub somename()
Dim pt As PivotTable, pt2 As PivotTable, pi As PivotItem, pi2 As PivotItem,
pf As PivotField, pf2 As PivotField, pf3 As PivotField
Dim pf4 As PivotField, pi3 As PivotItem, pi4 As PivotItem
Hi Prabhu,
see if the enclosed file helps
Regards
Umesh
On Sun, May 29, 2011 at 9:55 AM, Prabhu wrote:
> Hi Friends,
>
> I have attached a sheet, which contains space in prefix and suffix.
>
> But below formula is not working.
>
> Kind do the needful.
>
>
> --
>
>
Hi,
What's the code you want to pass and to which cell. mention that also
Regards
Umesh Dev
On Mon, May 23, 2011 at 11:32 PM, Skanda wrote:
> The column "difference" highlighted in green is calculated as the
> difference between the two cells to its left.Then %differenc
.
Regards
Umesh Dev
On Sat, May 21, 2011 at 5:35 PM, kannan excel wrote:
> If i put my executive name, his weekly and monthly perfomance will come
> automatically
>
>
> On Sat, May 21, 2011 at 5:31 PM, kannan excel wrote:
>
>> Hi rajan,
>>
>> i am main
Hi Vikram,
Find the sheet enclosed
Regards
Umesh Dev
On Mon, May 16, 2011 at 11:07 PM, vikram wrote:
> Hi,
>
>
>
> Please help regarding formula for validation:
>
>
>
> If we enter any numeric value in particular column it does not allow a
> duplicate
Hi Rakesh,
can you attach the excel sheet
Regards
Umesh Dev
On Fri, Apr 1, 2011 at 4:29 PM, rakesh kumar wrote:
> Hi ! Group members,
>
> I have a pivot table, which shows 5 income groups in row Range and their
> counts. However, when I apply a filter it leaves 3 income group
Hi Puttu,
explain it in excel sheet and also mention all the possibilities.
Regards
Umesh
On Fri, Apr 1, 2011 at 5:12 PM, Puttu * wrote:
> awaiting for your replay please.
>
>
> On Fri, Apr 1, 2011 at 4:49 PM, Puttu * wrote:
>
>> Experts please help me on this it's bit urgent sorry to bother.
Hi John,
change the formula to IFERROR(AVERAGE('Dept A'!B10,'Dept B'!B10,'Dept
C'!B10),"")
Regards
Umesh
On Tue, Mar 29, 2011 at 8:22 PM, John A. Smith wrote:
> I have like tabs from different departments and need to summarize an
> average score by day. But if there were no scores in a partic
Hi Ayush,
Congrats to you and the team.
Regards
Umesh
On Mon, Mar 21, 2011 at 10:08 PM, neil johnson wrote:
> Hi ,
> Congratulation to you sir
> On 3/20/11, Ayush Jain wrote:
> > Dear Excel Group Members,
> >
> > I am very glad to share that* discussexcel.com <
> http://www.discussexcel.com>
>
>
> Thanx and It's feel good to see done with macro. And how to copy it to my
> main
> workbook.
>
> Meaning of Pending Amount : It mean's payment which was not collected yet.
>
> Regards
> Sudhir
>
> On 21/03/2011, Umesh Dev wrote:
> > Hi Sudhir,
Hi Sudhir,
Check if its working. I have done it for only "Running Balance". I am not
clear with the " Pending Amount" the numbers are contradicting in the format
which you had attached. if you can let me know how it is done. I can rework
the code.
Regards
Umesh Dev
On Sat
Hi Sudhir,
It is still not clear, how to get the Running Bal and the Pending Amount.
Regards
Umesh
On Sat, Mar 19, 2011 at 12:55 AM, sudhir kumar wrote:
> Dear Experts,
>
>
> Please read my attachment and solve it.
>
> thanx
>
>
>
> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
Hi Susan,
Assuming that the formula is right. To change the number to time format. Do
it this way mentioned below:-
Right Click the cell -> Click on* format cells* * *-> Select *Time*
from *Category(Number)
*-> Choose the format you want.
Regards
Umesh Dev
On Sat, Mar 19, 2011 at 2:23
sample excel sheet would be easier to understand and solve
Reg
Umesh
On Thu, Mar 17, 2011 at 11:20 PM, Preston Moore wrote:
> I am just starting to use VBA so I am a neophyte. I have data that shows
> units sold by product listed by store for over 40 stores. Each store has
> its own ID code a
Congrats Ashish
On Wed, Mar 2, 2011 at 5:36 PM, DILIPandey wrote:
> Congrats Ashish...!!
>
> Best Regards,
> DILIPandey
>
> On Mar 1, 8:38 pm, Ayush wrote:
> > Hello Everyone,
> >
> > Ashish Koul has been selected as *'Most Helpful Member'* for the month of
> > Feb 2011.
> > He has posted 97 po
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,
Hi Sudhir,
Select the row A => Click on Data Tab => Click on Advanced => Select Unique
Records Only. That's it.
Regards
Umesh
On Wed, Feb 9, 2011 at 4:29 PM, sudhir kumar wrote:
> Dear Frnd
>
> I have list which have many repeated names
> i want short it with formula
>
>
> thanx
>
> --
> <>
Hi Mujeeb,
attach an excel sheet with example.
Reg
Umesh
On Mon, Feb 7, 2011 at 4:38 PM, Mujeeb wrote:
> Hi team,
>
> Could you pls help me in solving this excel formula.
>
> Eg;
>
> If A1 has some text for eg " My name is Google"
> In B1 if we type any text from A1, Eg "name " C1 should appe
Hi Hector,
Change the formula to IF(ISBLANK(D2),(B2-A2)*24,(D2-B2)*24) in the vba you
have mentioned is esblanco
Regards
Umesh Dev
On Thu, Feb 3, 2011 at 2:01 AM, Hector Ruiz wrote:
> Hi all, I made a macro to do a consultation with automatic cell ranges,
> with letters running bu
congrats Ashish
Regards
Umesh Dev
On Wed, Feb 2, 2011 at 8:25 PM, Ayush wrote:
> Ashish Koul has been selected as *'Most Helpful Member'* for the month of
> Jan 2011.
> He has posted over 75 posts (11% of total posts) in January 2011 and helped
> many people through his
Hi,
If you kindly put the data in excel it would be easy.
Reg
Umesh
On Tue, Feb 1, 2011 at 12:22 AM, jmccaski wrote:
> I have an arry of over 21,000 rows with data in this format:
> VarName TimeString VarValue
> Pos 27.01.2011 12:49:35 32
> Pres27.01.2011 12:49:35 -2
> Set
Hi sudhir,
Click *Conditional formatting* tab ->Select *New Rule* -> Select *Format
only cells that contain* -> click on *Format* and choose the color.
Regards
Umesh Dev
On Sun, Jan 30, 2011 at 9:27 PM, sudhir kumar wrote:
> Dear Experts
>
>
> please hep me for a fo
Hi
I hope the enclsd sheet will help you.
Regards
Umesh Dev
On Sun, Jan 30, 2011 at 12:40 PM, Ms-Exl-Learner . wrote:
> Hi Vikalp,
>
> Please refer the attached excel for solution.
>
> I have automated everything in formula and you need not to do any manual
> input in Sol
Hi jitender,
Find the enclsd sheet if it could help.
Regards
Umesh
On Sun, Jan 30, 2011 at 1:55 PM, Jitender kumar wrote:
> Dear Sir
>
> I have problem with excel file.Please provide the solution.(See attachment)
>
> Regards
>
> Jitender
>
> --
>
> -
Hi Vikram,
Its working in my sys. if its not working on your sys then let me know where
the file is saved and also where your acro-reader is saved.
Regards
Umesh Dev
On Sat, Jan 29, 2011 at 12:50 PM, vikram wrote:
> Hi,
>
>
>
> Please help regarding below query as I need this
Hi CS,
If you want to color the band. You can Conditional Formatting to get the
result.
Regards
Umesh
On Thu, Jan 27, 2011 at 3:04 PM, Born to Win wrote:
> Hello Expert,
>
> In Attached Sheet i am making a tracker For Attrition In first summary
> sheet i have to show Band with Colour correspon
Hi Vikram,
I clearly did not understand your query, however I have rectified the code.
Regards
Umesh Dev
On Wed, Jan 26, 2011 at 9:32 PM, vikram wrote:
> Hi Umesh,
>
>
>
> Thanks a lot for your help.
>
>
>
>
> I need one more help regarding below macro for c
Hi Vikram,
I am enclosing a file. It would ask for file each time you run the macros.
Use this as a template and the save as daily file. Is it clear?
Regards
Umesh Dev
9019107882
On Tue, Jan 25, 2011 at 7:51 AM, vikram wrote:
> Hi Umesh,
>
>
>
> I need one more help regardin
Hi David,
let me know the fields and how would you want it to be created.
Umesh
On Mon, Jan 24, 2011 at 12:32 AM, DavidG wrote:
> how do i add a file?
>
> On Jan 21, 8:57 pm, DavidG wrote:
> > Hi
> >
> > I am trying to build a system for a hairdressers to manage their
> > contacts and activit
Hi Ashish
Thank you ... You made it very simple. I was finding it difficult to loop.
Thanks Omar for the input.
Thanks and Regards
Umesh Dev
On Sat, Jan 15, 2011 at 9:53 PM, ashish koul wrote:
> check the attachement see if it helps
>
>
> On Sat, Jan 15, 2011 at 7:14 PM, Umes
Hi All,
Can anyone help me with the code in *VBA *to find unique values and pasting
it separately in Excel.
Regards
Umesh Dev
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
Hi Pankaj,
Go to advanced filters and select Unique records
Regards
Umesh
On Fri, Aug 27, 2010 at 11:21 AM, rajput wrote:
> I have a lot of Data including number & Alphabet , I am confussed
> that duplicate will be entered,,,which command i find duplicate records
>
> --
>
> -
Worksheets(i).Name = Newname & _
ThisWorkbook.Worksheets(i).Index
Next i
End Sub
Umesh Dev
On Tue, Nov 3, 2009 at 6:56 PM, Chanti wrote:
>
>
> Hi Team,
>>
>> Is there a way we can segregate the data depending upon the name
>> (column A) to different tab
have used Isnumber, match and "*"
etc
Happy belated Diwali to you
Regards
Umesh Dev
On Mon, Oct 19, 2009 at 12:16 AM, Dilip Pandey wrote:
> Hi Umesh,
>
> I have used "OFFSET" function to get the name to which the target names are
> matching. It picks the name
Hi Dilip,
Can you explain the logic pls.
Regards
Umesh
On Tue, Oct 13, 2009 at 8:39 PM, Dilip Pandey wrote:
> Thanks Michael,
>
> The enhancement is done in the attached file as per your requirements.
> Thanks
>
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
>
Regards
Umesh Dev
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel
Thank You Paul
Regards
Umesh Dev
On Thu, Oct 1, 2009 at 7:40 PM, Paul Schreiner wrote:
> A "Class" is a way of defining a new object and attributes.
>
> let's say you wanted to create an object called "People".
>
> Now, for each person in "People&qu
Hi All,
Can anyone tell the difference between a Module and a Class Module. What are
the advantages in writing a code in either Module/Class Module.
Regards
Umesh Dev
Hi All,
I have forgotten my excel password. Can anyone tell how to break it.
Regards
Umesh Dev
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA
Hi Pat:
May be you could look at http://ideas.repec.org/c/wpa/wuwppr/0302001.html
and Then possibly extend based on your requirements
Thank you,
Dev
On Jun 20, 5:09 am, Pat Sheehan wrote:
> Hi,I am looking to design a questionnaire via Excel with Yes/No options
> against the questio
Hi -
This link should provide you to head start on how to write macro. This
could be customized based on your needs.
http://support.microsoft.com/kb/213360
Hope this helps,
Dev
Kamlesh - I am hoping you need information on VBA programming. There
are umpteen references out in the world. Also the same for formulas.
Hope this helps.
-Dev
On Jun 2, 6:08 am, kamlesh agrawal wrote:
> Hi
> I am new to this group . i want some material for v b programming and lis
iTotal = iTotal + oRange.Value
Next
MsgBox ("Total Value is : " + iTotal)
Thank you,
Dev
On May 29, 9:47 am, Ramesh Katta wrote:
> Hi Gurus,
>
> I am Ramesh, new to vba programs. I need a macro to calculate sum for
> range of column. The should be displayed with MsgBo
.Paste
Call oCrntDoc.Save(True, False, False)
Call oCrntDoc.Send(True)
Set oCrntDoc = Nothing
Set oWrkSpace = Nothing
AppActivate ("Notes")
Hope this helps!
Thank you,
Dev
On Feb 12, 4:26 am, Darshan Amreliya wrote:
> Hi
> I required a macro to send a email via Lotus note
or design of such SLA tracker if you
have it ready. It will be really helpful for me as I am doing this for
first time...
Thanks in advance..
Regards,
Dev
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To
Hi,
I think you can also use the "Text to column" function by giving the
separator as ",". It will split the column into two by useing , as a
separator..
Hope this help..
Regards,
Dev
On Thu, Nov 20, 2008 at 8:44 PM, Tom Jeffries wrote:
> The attached Workbook contains
Hi -
You will have to define the slab range and the rate in separate
columns. use IF() to identify the range and calculate.
Hope this helps!
-Dev
On Dec 3, 10:25 am, "raghuveer kumar" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I had a small query.
>
> I had a data
Dude - this problem is already solved. Here is the link
http://www.vbaexpress.com/kb/getarticle.php?kb_id=72
Regards,
-Dev
On Nov 27, 12:17 pm, sanj <[EMAIL PROTECTED]> wrote:
> Hi Friends,
>
> Can anyone advise me, how can I arrange excel sheets in ascending
>
am hoping this would help you to head start. Let me know if you need
help.
Thank you,
Dev
On Nov 15, 10:47 pm, "rajesh mishra" <[EMAIL PROTECTED]>
wrote:
> Dear Sir,
>
> I am working with in factory there two shift working.I Attached the sheet
> with mail.Kindly give
Hi,
I am hoping this link would be of help to you
http://www.business-spreadsheets.com/forum.asp?t=33
You should be able to apply to your domain seamlessly.
Thank you,
Dev
On Oct 12, 10:44 pm, "v sheeba" <[EMAIL PROTECTED]> wrote:
> Dear All,
> Its any one taught m
Yes, you could. Use =TEXT(A1, "DDD") where A1 referes to the cell.
-Dev
On Oct 13, 11:51 pm, "Mayank Patel" <[EMAIL PROTECTED]> wrote:
> Hi friends,
> Is there any worksheet function to get the day like Monday, Tuesday
> etc. from any given da
Sachin,
There are numerous tutorials available online. Here are the details
http://www.anthony-vba.kefra.com/vba/vbabasic1.htm
http://www.anthony-vba.kefra.com/vba/vbabasic2.htm
And MSDN has valuable collections of code snippets.
Hope this helps.
Thank you,
Dev
On Oct 14, 3:16 am, "s
this...
Regards,
Dev
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-ma
54 matches
Mail list logo
