Hi All,
I am looking on to prepare a bell curve for my team based on their monthly
preformace.
Which should show them where they stand in comparision to others and it has
to be prepared with formula only.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT
Hi Group,
I have created few images using the camera tool in excel 2007 and windows
xp. now my system has been upgraded to MS2010 with windows 2007.
Since the time the system has been upgraded all the images in all files
are increasing automatically to a fix size .
When I try to reduce the size
Hi,
Is any one providing MS access classes in Gurgaon.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
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/discussexcel
FORUM
Hi Dharmendra,
Please find attached my updated resume
--
Regards
Santosh
santoshkumar.subu...@gmail.com
> Date: Wed, 30 Oct 2013 11:20:03 +0530
> Subject: [XL-VBA Clinic] URGENT OPENING WITH SERCO - MIS
> From: dharmendra2...@gmail.com
> To: excelvbacli...@googlegroups.com
> CC: rajachauh...@r
Hi Group,
I need to create a formula that will give the cell address of a value from
the whole workbook.
Attached is the sample sheet for easy reference.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:
Hi Group,
I have been trying to calculate the actual production time with certain
conditions to it .
Attached is the sample sheet with an example and conditions.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TI
Abacus Software Services Pvt Ltd
>
>
> On Thu, Aug 22, 2013 at 4:55 AM, santosh subudhi
> wrote:
> > Hi Group,
> >
> > Is it possible to extract the data which are not common between two
coloums
> >
> > Attached is sample sheet with problem
> >
>
Hi Group,
Is it possible to extract the data which are not common between two coloums
Attached is sample sheet with problem
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
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 Faceb
Hi Group,
Need information on what is 9E+307 and when/where/how to use it.
Few example will be of very helpful to me with supporting links.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
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
Hi Team,
Is it possible to still the image(Eg: Graph) on the screen even though we
scroll down or scroll right.
Usually when we scroll to right or down the image also moves with cells.
If it is possible please help me a example sheet or a link where I can find
the details of the same.
--
Regar
Hi Group,
Please share attrition tracker which calculates the attrition % on
monthly,quaterly,halfyearly and yearly level
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
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
.
Regards
David Grugeon
On 15 May 2013 13:51, Prabhu Pinky wrote:
Nope. it is not possible..
On 15 May 2013 01:14, santosh subudhi wrote:
Hi Group,
Is it possible in excel to lookup the comments along with the value.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Are you =EXP(E:RT) or =NOT
Hi Group,
Is it possible in excel to lookup the comments along with the value.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
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.
Hello Ravi,
The code provided by you is coping a particular range instead it should
completely copy the sheet the way it is doing in the code provided by
ashish.If you can do that for me I can use your code .
*Function file_exists(fl_path As String) As Boolean*
*
*
*If Dir(fl_path) <> "" And
Hi,
Hope the attached file meets your requirement.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
Date: Tue, 30 Apr 2013 15:46:29 +0530
Subject: Re: $$Excel-Macros$$ How to create hyperlink within workbook
From: gawlianil8...@gmail.com
To: excel-macros@googlegroups.com; itpabdulg...@gmail.co
;) = ""
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub
--- On *Tue, 4/30/13, santosh subudhi *wrote:
From: santosh subudhi
Subject: $$Excel-Macros$$ copy the active worksheet and paste it to another
workbook in a given path.
To: "excel-macros"
Date: Tuesday, Apri
Hello Team,
I need a code that will copy the active worksheet and paste it to another
workbook in a given path.
The path will be in one of the cells of the active worksheet.
For example my active workbook name is book1 and I want the sheet 1 of book
1 to be copied and save it in another workbook
Hello Kuldeep,
Please find attached the sheet. Hope this meets your requirement.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Date: Sat, 20 Apr 2013 10:52:27 +0530
Subject: Re: $$Excel-Macros$$ Hyperlink by Sheets Name.
From: naukrikuld...@gmail.com
To:
>
> Set rng = Sheets(1).Range("a1:d" &
Sheets(1).Range("a1048576").End(xlUp).Row)
>
> rng.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
> flname, Quality:=xlQualityStandard, _
> IncludeDocProperties:=True, IgnorePrintAreas:=False,
> OpenAfterPublis
t current file to pdf
To: excel-...@googlegroups.com
PFA
Hope this helps.
Mention destination folder name in cell p2 & make sure to add "/" in the
end.
Cheers!!
On Tue, Apr 16, 2013 at 3:24 PM, santosh subudhi wrote:
Hello Ashish,
We are using MS office 2007.
I have attach
3 14:52:28 +0530
Subject: Re: $$Excel-Macros$$ print current file to pdf
To: excel-macros@googlegroups.com
PFA
Hope this helps.
Mention destination folder name in cell p2 & make sure to add "/" in the
end.
Cheers!!
On Tue, Apr 16, 2013 at 3:24 PM, santosh subudhi <
santoshkum
2013 14:52:28 +0530
Subject: Re: $$Excel-Macros$$ print current file to pdf
To: excel-macros@googlegroups.com
PFA
Hope this helps.
Mention destination folder name in cell p2 & make sure to add "/" in the
end.
Cheers!!
On Tue, Apr 16, 2013 at 3:24 PM, santosh subudhi <
san
@googlegroups.com
which version of excel r u using .. can u share a sample file
On Sun, Apr 14, 2013 at 7:23 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
Hello Team
I am looking for VBA code to print a active sheet into pdf without user
interface.
Suppose the cell AA1 contai
Hello Team
I am looking for VBA code to print a active sheet into pdf without user
interface.
Suppose the cell AA1 contains the address where the pdf to be stored and
Cell AA2 contains the name by which the pdf to be stored.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Are you =EXP(E:R
:
Dear SantoshKumar.Subudhi,
Pl see the attach sheet.
Warm Regards,
Gawli Anil.
On Mon, Mar 25, 2013 at 11:35 AM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
Hello Prafull,
Thank you for your early reply.
The solution provided by you contains only two criteria's
f it is as per your requirement .
Regards,
prafull jadhav.
On Sun, Mar 24, 2013 at 2:27 PM, David Grugeon wrote:
I want to know where we are going next with this. What happens if the
amounts are different?
On Sunday, 24 March 2013, santosh subudhi wrote:
Hello Group,
I need a way to high
Hello Group,
I need a way to highlight the amts that I can offset with each other based
on the below conditions:
1) Customer should be same
2) Profit Center has to be same
I need to do this *with out macros.*
*
*
Any type of help would be of great help.
--
Regards
Santosh
santoshkumar.subu...@g
Hello Group,
I have a attendance tracker which works fine but when I try to increase the
data range or insert a new row it gives me a error.
Attached is the excel file the top part works fine,however when I tried to
insert a new row/increase the range it gives me error.I have shown the
error par
Hello Group,
Is it possible to look up the value in the cell along with the cell
comments or cell colour.
As far I know we can pick the cell colour using "Get.cell" but not aware
how to us it and I cannot use macros in the file
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Are you =EXP(
Hello Group,
Need a small help on how to calculate the max with two or more conditions.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
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
Hello Group,
I want to veiw table 1 data in graph when check box is true else table 2
data when check box is false.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thre
Hello Group Manager,
Currently my mail id : santoshkumar.subu...@gmail.com
is registered with this group.
Would request you to remove my above email id and add my new mail id
santoshkumar.subu...@hotmail.com
Once done please let me know above the change.
Regards
Santosh
santoshkumar.subu...@gma
Hello,
Can the graph in the attchment be modified as per the below table.
If so would request you to please help me with this
Group1 10%
Group2 20%
Group3 30%
Group4 15%
Group5 25%
Total 100%
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Join official facebook page of this forum @
Hello Group,
Do we have any group for MS access like this forum for excel.
If so plz provide me the email address of the forum.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members a
Hi Group,
I want to convert numbers into hrs and mins.
Suppose if I enter 2.5 in Cell A1 it should automatically convert it into
HH:MM:SS ie 4:10:00 in cell B1
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Join official facebook page of this forum @
https://www.facebook.com/discussexce
all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
*-
--
*From:* santosh subudhi
*To:* excel-macros
*Sent:* Fri, September 14, 2012 3:49:48 AM
*Subject:* $$Excel-Macros$$ Calculate next
Hi Group,
I want to calculate the next working day where Monday to Saturday are the
working days and it should also consider the holidays.
For example, 1-Sept (Saturday) is the 1st working day and 3-Sept(Monday) is
a holiday,so next working day is 4-Sept (tuesday)
I cannot use working day functi
Hi,
What are bullet graphs,would request to share some examples with me.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate th
Hi Group,
I would like to know how many "type num" are there which are used in
Get.cell argument and what are their functions.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread title
Hi Group,
Need another help to count and sum data between two fixed dates.
Regards
Santosh
santoshkumar.subu...@gmail.com
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Pr
Hi Group,
I want the list of all the sheet names available or to created in sheet1
automatically via formula of a workbook *without a macro.*
Thanks & Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread title
Hi Group,
I am Santosh working with TCS Eserve for last one year as a
Cash Application Specialist and prior to this I have worked with Genpact
for 4years. This is the place where I learnt MS Excel.Today I can say Excel
has become a part of my life. Without Excel I can't imagine my life which
has g
Hi Group,
Can any one help me where can I learn online MS Access.
I don't have any knowledge on MS Access
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Hi Sreejith,
Attached is another excel sheet with total region wise sales and also the
employee wise (both conditions fulfilled at same point).
Thanks & Regards
Santosh Kumar Subudhi
-- Forwarded message --
From: santosh subudhi
Date: Sun, Jul 8, 2012 at 9:43 PM
Subject
Hi Sreejith,
Since you are looking for a total sales on region wise the attached excel
sheet may solve your problem.
Regards
Santosh
santoshkumar.subu...@gmail.com
--
From: koul.ash...@gmail.com
Date: Sun, 8 Jul 2012 21:16:11 +0530
Subject: Re: $$Excel-Macros$$ Vlookup
Excel-Macros$$ Need to upgrade a formula
Date: Sat, 7 Jul 2012 08:34:54 -0500
http://www.cpearson.com/excel/Rank.aspx
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* santosh subudhi
*Sent:* Saturday, July 07, 2012 5:42 AM
*To:* excel-macros
*Subject:* $$Excel-M
Hi Group,
Would request you to please help me in upgrading the formula in the
attached excel sheet.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent
Hi Group,
Is there a formula to get the user name in a cell the way we get it in
VBA i.e application.username
My comp doesn't allow Macro hence I need a formula to do so.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use c
Hi Suyog,
I have used the name ranges in the sheet.
If function starts with logical reason, to view the name ranges press
CTRL+F3
So I have defined each logic a diffrent name like criteria 2 ,criteria3
like that
Hope I have cleared you doubt, if you still have any queries please feel
free to co
ubt send me an email.
*See if amt is "0" without any comment it should be "L".**See if the amt is
"0" with comment It should be "COMP","LOP","J","UL","M",*
based on comments i need the results in status colum.
Regards
bu...@gmail.com
From: talk2mar...@gmail.com
Date: Mon, 4 Jun 2012 02:01:14 -0700
Subject: Re: $$Excel-Macros$$ Graph with radio button
To: excel-macros@googlegroups.com
Hi,
PFA...
On Mon, Jun 4, 2012 at 1:39 AM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
Hi Group,
I want to
Hi Group,
I want to create a graph which will show the work performance of different
teams as and when they are selected.
Attached is the sample sheet for your easy reference.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use c
Hi Group,
Attached is the sample excel sheet with graph which shows the performance
of the employees for two units.
Now the problem is that I need to update the data range every time say once
in a month (in this attached sheet it is a year).
What I need is I want to link the scroll bar with the
Of *santosh subudhi
*Sent:* Apr/Sun/2012 02:02
*To:* excel-macros@googlegroups.com
*Subject:* RE: $$Excel-Macros$$ Leave tracker
** **
Hi Rajan,
** **
The pivot option is possible when the team size is very less. I have a very
big team and need a formula to fix this.
** **
Is
Hi Group,
Attached is a sample excel tracker in which the leaves taken by every
employee is entered in a single sheet (Data).
Now this is data has to split-ted in to respective months with the count
type .
Some Sample data is entered for the month of April12 for easy reference.
--
Regards
Sant
Date: Wed, 4 Apr 2012 13:59:44 +0530
Hi
Please visit the link , here a procedure to do the same
http://www.pcreview.co.uk/forums/user-form-picture-caption-t967952.html
Rajan.
*From:* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com
] *On Behalf Of *santosh subudhi
*Sent
Hi Group,
I want to prefix a picture in the userform caption in excel.
Would request to help me with that.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Hi Group,
I have added "=2+2" in cell A1 and in cell A2 I want the result to be 2
since i have added two value.
Similarly if i caulculate"=2+2-1" in Cell A1 the desired result is 3 in
CellA2
Is there any forumla to count this.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (
Hi Group,
How to use spin button with text box in a user form.
Attached is the sheet in which I need help
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Hi Group,
In the attached excel sheet the maturity value is working fine for years
and months however it not giving me the exact result when it come to days
option.
Would you request to have look into this and provide appropriate solution.
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORU
:32 +0530
Subject: Re: $$Excel-Macros$$ Running/Moving Statement
From: xlst...@gmail.com
To: excel-macros@googlegroups.com
Hi Santosh,
yes it is possible, please find the attachment
On Sat, Jan 14, 2012 at 4:56 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
Hi Group,
Hi Group,
Is it possible to show a statement moving from right to left in MS Excel
that we usually see in websites or in our system screen savers.
If yes please help me with this.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1)
Hi Noorain,
Please find attached my updated resume for your easy reference.
Regards
Santosh
santoshkumar.subu...@gmail.com
Date: Mon, 2 Jan 2012 15:47:13 +0530
Subject: $$Excel-Macros$$ JOB
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
The sender of this email is registered
have deposited 36000. If the bank only offers you a balance of
12000+, complain!!!
Asa
*From:* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com
] *On Behalf Of *santosh subudhi
*Sent:* Tuesday, December 27, 2011 2:03 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-M
Hi Group,
I am trying to calculate the interest in excel for a fixed deposit I have
done in a leading bank with
Investment Amt 30,000/-
ROI 9.6%
Period 500 days (16 months and 12 days)
Maturity value is 34,159.00/-
Compounded Quarterly
I am currently referring this link
http://www.allbankingsolu
Hi Group,
Can any one help me with the financial calculator templates or formulas,
functions to calculate Simple intrest, Compound interest and Interest on
Recurring deposit.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (934+ members already BANNED for violation)
1) Use co
Hi All,
In the user form I have coded a date validation which should take data for
current date or the previous date only with the help of *calendar only*.
However, the code is not working properly.
Moreover in the textbox3 I want it to restrict it only for numbers and no
character should be all
Hi Haseeb,
Thanks for the solution.
But I am unable to understand the formula,would request you to kindly help
me in understanding the formula and where can we use 9E300.
Regards
Santosh
--
Date: Wed, 23 Nov 2011 08:06:00 +0530
Subject: Re: $$Excel-Macros$$ need cor
Hi All,
Please look into the formula and do the necessary correction.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
Hi Group,
Please help me with the coding in the attached excel sheet.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
Hi Group,
Need a code to clear the values of all the text boxes ,comboboxes in one
click in a excel sheet with the name "calculator"
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
--
Some important links for
Hi,
http://www.rondebruin.nl/sendmail.htm
http://msdn.microsoft.com/en-us/library/aa203718(office.11).aspx
http://msdn.microsoft.com/en-us/library/aa203718(office.11).aspx#odc_thesendmail20utility
Try the other links with other options available in the sites
Regards
Santosh
On Wed, Mar 30,
Hi Friends,
Need another help.
I am trying to upload a userform using combobox but it is not working.
Sample sheet is attached.
Regards
Santosh
santoshkumar.subu...@gmail.com
--
--
Some important links for excel u
Hi Friends,
Need a small help.
Attached is a excel with a comand button which will populate a userform.
In the userform there is a comand button called use combo which should
calculate based on the combobox criteria.
This is what not calculating properly.
--
Regards
Santosh
santoshkumar.subu.
Mar 10, 2011 at 11:00 PM, santosh subudhi <
> santoshkumar.subu...@gmail.com> wrote:
>
>> Hi,
>>
>> Can anyone help me in playing a gif file in excel
>>
>> I am using excel 2003 and 2007 version.
>>
>> I want to play a gif file in worksheet and
Hi,
Can anyone help me in playing a gif file in excel
I am using excel 2003 and 2007 version.
I want to play a gif file in worksheet and in userform both.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
--
S
Hello All,
I have a folder in which every person maintains his data in the same format
and at the end of the day the data needs to be collected into a new file or
an existing file.
This collection is done in a manual way can any one help me in collating the
data from all the files via vba.
The s
Hello All,
Can any one help me where i can get free download for how do the check box
and the option buttons work with formulas and macros.
Regards
Santosh
--~--~-~--~~~---~--~~
-
Hello,
Can any one tell me how a check box can be used.
Or how does it work with or with out macros
Regards
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel
Hello All,
Please help me with below mail it is very urgent.
Regards
Santosh
On 3/1/09, santosh subudhi wrote:
>
> Hi All,
>
> I want to put some reminders in my excel sheet which we open regularly.
> Suppose a pop up message box appear on a particular date stating"
Hello,
If you are good in exce. Then record a Macro and use ALT + F11 and try to
understand what it has wrote for the steps you have perfromed.
There also lot of sites you can refer to as a beginner.
just write excel vba in google and you can find a lot of sites.
Hope this helps
Regards
Santos
Hello,
i am unable to find any attachement in the mail.
Regards
Santosh
On 3/6/09, r...@vi k...@r wrote:
>
>
> =clean(a:a & enter
> On 3/5/09, Lavprasad Kori wrote:
>>
>>
>> Dear All,
>>
>> Please help me.
>>
>> Attaching herewith the downloaded data. I want to do just text to column.
>> But
Hi All,
I want to put some reminders in my excel sheet which we open regularly.
Suppose a pop up message box appear on a particular date stating" Hello
today is the birthday of your team memeber" or " need to send a mail to some
one".
Regards
Santosh
--~--~-~--~~~---~
83 matches
Mail list logo