$$Excel-Macros$$ Bell curve in excel 2010 and above

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

$$Excel-Macros$$ Image size increases automatically

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

$$Excel-Macros$$ MS Access classes in Gurgaon

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

$$Excel-Macros$$ RE: [XL-VBA Clinic] URGENT OPENING WITH SERCO - MIS

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:

$$Excel-Macros$$ Address of a value with in the workbook.

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

$$Excel-Macros$$ Calculate break time Production time after removing break time

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

RE: $$Excel-Macros$$ Extract Names which are not common

, santosh subudhi santoshkumar.subu...@gmail.com wrote: 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

$$Excel-Macros$$ Extract Names which are not common

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

$$Excel-Macros$$ 9e+307

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) !

$$Excel-Macros$$ Still image even we scroll

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. --

$$Excel-Macros$$ Attrition Tracker

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

RE: $$Excel-Macros$$ Vlookup value with comments

. Regards David Grugeon On 15 May 2013 13:51, Prabhu Pinky prabhupin...@gmail.com wrote: Nope. it is not possible.. On 15 May 2013 01:14, santosh subudhi santoshkumar.subu...@gmail.comwrote: Hi Group, Is it possible in excel to lookup the comments along with the value. -- Regards Santosh

$$Excel-Macros$$ Vlookup value with comments

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 @

RE: $$Excel-Macros$$ copy the active worksheet and paste it to another workbook in a given path.

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

RE: $$Excel-Macros$$ copy the active worksheet and paste it to another workbook in a given path.

) Sheets(Sheet1).Select Sheets(Sheet1).Copy ActiveWorkbook.SaveAs Path \ book2, FileFormat:=56 ActiveSheet.Name = sheetname ActiveWorkbook.Sheets(sheetname).Range(a15:a16) = ActiveWorkbook.Save ActiveWorkbook.Close End Sub --- On *Tue, 4/30/13, santosh subudhi

RE: $$Excel-Macros$$ How to create hyperlink within workbook

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;

RE: $$Excel-Macros$$ Hyperlink by Sheets Name.........

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

RE: $$Excel-Macros$$ print current file to pdf

) rng.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ flname, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _ True End Sub On 4/19/13, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hi Vabs The solution provided by you is working

Re: $$Excel-Macros$$ print current file to pdf

+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 santoshkumar.subu...@gmail.com wrote

RE: $$Excel-Macros$$ print current file to pdf

+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 santoshkumar.subu...@gmail.com wrote

RE: $$Excel-Macros$$ print current file to pdf

@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 contains

$$Excel-Macros$$ print current file to pdf

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

RE: $$Excel-Macros$$ conditional formating to find amts to offset

gawlianil8...@gmail.comwrote: 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

$$Excel-Macros$$ conditional formating to find amts to offset

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

$$Excel-Macros$$ vlookup cell comments along with data

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

$$Excel-Macros$$ Getting an error when inserting a new row is inserted

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

$$Excel-Macros$$ Re: Chart stuff

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 @

$$Excel-Macros$$ Plz update my new mail id in this group and remove my old(current)id

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

$$Excel-Macros$$ Email address for ms access 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

$$Excel-Macros$$ Calculate next working day

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

RE: $$Excel-Macros$$ Calculate next working day

, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* santosh subudhi santoshkumar.subu...@gmail.com *To:* excel-macros excel-macros@googlegroups.com *Sent:* Fri, September 14, 2012

$$Excel-Macros$$ Bullet graphs

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

$$Excel-Macros$$ Help needed to count and sum data between two fixed dates.

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

$$Excel-Macros$$ All the sheet names in one sheet

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

$$Excel-Macros$$ MS access link

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

$$Excel-Macros$$ Introduction

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

RE: $$Excel-Macros$$ Vlookup or Match formula - regionwise

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$$

Fwd: $$Excel-Macros$$ Vlookup or Match formula - regionwise

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 santoshkumar.subu...@gmail.com Date: Sun, Jul 8

$$Excel-Macros$$ Need to upgrade a formula

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,

RE: $$Excel-Macros$$ Need to upgrade a formula

-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 santoshkumar.subu...@gmail.com *Sent:* Saturday, July 07, 2012 5:42 AM *To:* excel

$$Excel-Macros$$ Formula for Username in a cell

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

RE: $$Excel-Macros$$ Please help : Use of Criteria Rule1-2

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

$$Excel-Macros$$ Graph with radio button

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

RE: $$Excel-Macros$$ Graph with radio button

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 create a graph which

$$Excel-Macros$$ Scroll Bar charts with Name ranges

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

$$Excel-Macros$$ Leave tracker

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

RE: $$Excel-Macros$$ Leave tracker

@googlegroups.com ] *On Behalf 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

RE: $$Excel-Macros$$ Prefix a pic in the userform caption

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

$$Excel-Macros$$ Prefix a pic in the userform caption

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

$$Excel-Macros$$ Count function needed

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

$$Excel-Macros$$ Using spin button with textbox in userform

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

$$Excel-Macros$$ Formula correction needed in FD calculation

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 --

RE: $$Excel-Macros$$ Running/Moving Statement

: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, Is it possible

$$Excel-Macros$$ Running/Moving Statement

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)

Re: $$Excel-Macros$$ Formula correction needed for Recurring deposit‏

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-Macros

$$Excel-Macros$$ Need assistance in calculating FD intrest in excel

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

$$Excel-Macros$$ Need assistance in Functions related to Financial Calculation

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

$$Excel-Macros$$ Code in the userform for date validation not working properly

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

RE: $$Excel-Macros$$ need correction in the formula

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

$$Excel-Macros$$ need correction in the formula

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

$$Excel-Macros$$ Macro-coding required

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

$$Excel-Macros$$ code to clear all the values at a one go

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

Re: $$Excel-Macros$$ How to send mail with excel

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,

$$Excel-Macros$$ userform is not opening

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

$$Excel-Macros$$ combobox criteria not working

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

Re: $$Excel-Macros$$ Playing Gif files in excel

On Thu, 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 in userform both. -- Regards Santosh santoshkumar.subu

$$Excel-Macros$$ help needed

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

$$Excel-Macros$$ help needed

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 --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ help me for check box

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

$$Excel-Macros$$ Re: Reminder workbook

Hello All, Please help me with below mail it is very urgent. Regards Santosh On 3/1/09, santosh subudhi santoshkumar.subu...@gmail.com 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

$$Excel-Macros$$ Re: How to use VBA

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

$$Excel-Macros$$ Reminder workbook

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