Re: $$Excel-Macros$$ Re: Financial Modelling / Economic Modelling using Excel/VBA

Do not know any institutes.But check the website www.exinfm.com On 3 Sep 2016 16:54, "nageswara rao Moyya" wrote: > no thanks > > On Wednesday, September 30, 2009 at 2:48:47 PM UTC+5:30, Sivakumar wrote: >> >> Dear all >> >> Would like to know any university/institute

Re: $$Excel-Macros$$ Autofill while typing in a cell

Respected Pavan, Excel 2013 does provide the function of auto-fill which may be suitable for your requirements. Regards, Vijaykumar On Fri, Oct 11, 2013 at 10:08 AM, Eugene Bernard eugene.bern...@gmail.comwrote: Dear Anil, I get an error Can't find the project or library , at the second

$$Excel-Macros$$ Excel Financial Modeling World Championship

Respected Experts, I think many of our experts would like to participate in Excel Financial Modeling world championship to be held in October 2013.for details go in to Microsoft website or go the the link:

Re: $$Excel-Macros$$ UNPROTECT EXCEL WORK BOOK

Respected Prabhakar, Install the addin a new excel work book.To install the addin go to the excel options button and go to the add-in tab,in the rightside down part you will have a go button .Click it and you will have a dialog box with brose and three other buttons.Click brose and select the

Re: $$Excel-Macros$$ Auto Filter too short

Respected Waseem, Just Select the entire sheet and go to any row or column intersection such as Column A B or Row 1 2 etc.Just double click when your cursor turns into a double arrow.Now the whole sheet is adjusted accordingly and you need not drag it everytime. Regards, Vijaykumar On Fri,

Re: $$Excel-Macros$$ Stock prices data fetching through VBA

and there are may sites also that meet your requirement. Regards, Vijaykumar On Thu, Sep 19, 2013 at 12:57 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Murali, To fetch Indian stocks you need indian companies indexes that is like IBM for IBM etc.Please find the atthment to get indian

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

Respected Chaya, Unfortunately macros or VBA interface is not available with Excel 2008 for MAC.You must upgrade to Excel 2011 of chane to windows operating system to use Excel 2007,2010 or Excel 2013.The shortcoming or limitations of Excel 2008 are given in the below link.

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

Respected Chaya Cooper, Please check the following link and see whether it helps. http://excelsemipro.com/2011/05/create-a-list-in-excel-2008/ To view code you can also open the VBA window by pressing ALT+F11 and go to project explorer window and go to the module folder to open it and see the

Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total

Respected GopiNath, Please check the following youtube video for your answer http://www.youtube.com/watch?v=Rr9dK5bDWcE Regards, Vijaykumar On Wed, Aug 14, 2013 at 3:09 PM, Gopinath nath@gmail.com wrote: Dear Shri Satendra Kumar, Thank you for your suggestion. However, what I wanted

Re: $$Excel-Macros$$ MS Access Group

Respected Anoop Sharma, There are plenty of Access groups.Just google for MS ACCESS groups and u will find a whole lot of them. Regards, VijayKumar On Sat, Aug 10, 2013 at 1:27 PM, Anoop K Sharma aks.sharm...@gmail.comwrote: Join such groups on FB On 8/10/13, Kaushal Kumar

Re: $$Excel-Macros$$ Pivot Answer

. In the output sheet i'll feed the few employees names as per my boss need 3. The output should be in the given format Thanks Kathir On Mon, Aug 5, 2013 at 3:01 PM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Respected Kathirvelan, What exactly is ur requirement.For example, To sort the data

Re: $$Excel-Macros$$ Pivot Answer

Respected Kathirvelan, What exactly is ur requirement.For example, To sort the data or to get the approved or not approved status on a particular date etc.if your reuiqrement is not clear then members will not be able to help you. Regards, Vijaykumar On Mon, Aug 5, 2013 at 2:21 PM, KATHIRVELAN

Re: $$Excel-Macros$$ Pivot Answer

Respected Kathirvelan, Pivot table sigma values box should contain only numerical data and not text data.you can use a normal table instead and use Vlookup or the INDEX and MATCH functions to get the desired results. Regards, Vijaykumar On Mon, Aug 5, 2013 at 3:01 PM, P.VIJAYKUMAR vijay.4

Re: $$Excel-Macros$$ Pivot Answer

Respected Kathirvelan, Please check the following link for your solution. http://chandoo.org/wp/2012/05/07/displaying-text-values-in-pivot-tables-without-vba/ Regards, Vijaykumar On Mon, Aug 5, 2013 at 3:11 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Kathirvelan, Pivot table

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

Respected Vikas, Select the sheet and go to the format tab then protection tab of the dialiog box and remove the checkmarks for locked and hidden boxes.T hen select the cell for which that contain the formulas,then go gain to the format tab and recheck the locked and hidden boxes.Now,go to the

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

Respected Suyog, Enabling macros functionality is provided to stop unwanted macros or virus running and corrupting the data.You can open the excel file and work on the contents.If you want the macro to run and the code be executed then one should enable macros.Expiry macro is a type of macro

Re: $$Excel-Macros$$ month wise seq in pivot

Respected Hemal, You can also group dates in a pivot table.Please see the following links for a detailed example. http://chandoo.org/wp/2009/11/17/group-dates-in-pivot-tables/ http://office.microsoft.com/en-in/excel-help/group-or-ungroup-data-in-a-pivottable-report-HA102840048.aspx

Re: $$Excel-Macros$$ month wise seq in pivot

Respected Hemal, Create a custom List and sort moths according to that custom list. Regards, Vijaykumar On Fri, Aug 2, 2013 at 10:33 AM, hemal shah hemali...@gmail.com wrote: in this file, there is sheet named Sale Summary. In the column labels, I have put Year and below that i put month.

Re: $$Excel-Macros$$ Need help

Respected Cute Awsome, You can find cracks and activation keys for download.Just google for windows 7 activation keys or download a cracked version and install.Then you will not receive the message. Regards, Vijaykumar On Sat, Jul 27, 2013 at 4:38 PM, Excel Learn excellearn2...@gmail.comwrote:

Re: $$Excel-Macros$$ Re: I appreciate your help :-)

Respected Sonu, Please look into the following links for explanation.There are also other links on the net, but these may help you undersatnd OFFSET function better. http://www.myonlinetraininghub.com/excel-offset-function-explained http://www.youtube.com/watch?v=kvXToxeiS6Y

Re: $$Excel-Macros$$ urgent help

Respected Devanand, I think you have exported the same from tally.In tally you have the option to sort the details before exporting.You can do the same in excel also.First sort the data according to the TIN NO.The select the data and apply subtotal.In subtotal column select TIN NO and select the

Re: $$Excel-Macros$$ Un protect the excel file

Respected Prafull, There are password removing or breaking software.You Can use them.Here are some links for their download.Password recovery software are also there. http://www.straxx.com/ http://asunsoft-excel-password-remover.en.softonic.com/

Re: $$Excel-Macros$$ Query - How to make reversal string.

Respected Ashish, Simply use the attached add-in. On Mon, Jul 22, 2013 at 12:00 PM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Seniors, Thank to all of you. Your help means a lot for me. thanks. thanks, Ashish On Monday, July 22, 2013 11:44:56 AM UTC+5:30, Vabz wrote:

Re: $$Excel-Macros$$ doubt with regard to change event of the combo

Respected Bheema Shakar, Please check the links which will help with your problem. http://www.contextures.com/exceluserformdependentcomboboxes.html http://www.youtube.com/watch?v=eJslb49T0Bk Regards, VIjaykuar On Mon, Jul 22, 2013 at 12:20 PM, Shankar Bheema shankar.n...@gmail.comwrote: Hai

Re: $$Excel-Macros$$ Re: Whole Sheet is Hidden, But actually not Hidden!

Respected Paul, Lot of Sheets and formulas and queries within them do slow excel considerably.Set no the processors to all in advanced tab of excel options.this may improve your condition a little bit.But if you want to improve the situation you have to increase the processor spy eed and also

Re: $$Excel-Macros$$ How to lock / Protect Cell, Column Row in excel.

Respected Prabhakar, First select all the sheet and go to format tab and go to the protection tab and uncheck the locked and hidden chechmarks.Then Select the Cells,Rows or Columns which you want to lock,the go to the format tab and then the protection tab in the dialog box then check the locked

Re: $$Excel-Macros$$ Total of values

Respected Smitha, The braces appear by pressing Ctrl+Shift+Enter.This converts the normal formal in to an array formula.Array formulas have a great and extensive use in excel.For more information on Array Formulas you can check the following links.

Re: $$Excel-Macros$$ Total of values

:07 PM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Respected Smitha, The braces appear by pressing Ctrl+Shift+Enter.This converts the normal formal in to an array formula.Array formulas have a great and extensive use in excel.For more information on Array Formulas you can check the following

Re: $$Excel-Macros$$ Help need on attached Excel

Respected Vikas, There is no problem with the tracker.Just enable the macros of excel.For inputting any new data do not type manually but use the button given and type the data into the dialogue box you get after pressing the button. ** Regards, VijayKumar -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Time Format

Respected Neeraj, Excel stores all dates as integers and all times as decimal fractions. With this system, Excel can add, subtract, or compare dates and times just like any other numbers, and all dates are manipulated by using this system.Times are stored as decimal numbers between .0 and .9,

Re: Fwd: $$Excel-Macros$$ Un hide a workbook

Respected Kaushal, I think that the file is saved as read only and modifications and editing are prohibited.The procedure of saving the excel file or any office file as read only is as per the following link http://support.microsoft.com/kb/214094.You can see the file but hen you open the file the

Re: $$Excel-Macros$$

Respected Anil, The dashboard is wonderful and fabulous.If you have designed it yourself you are a top class excel genius and a excel expert. Thanking you once again for the Dashboard. Regards, VijayKumar On Wed, Jul 17, 2013 at 2:10 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear

Re: Fwd: $$Excel-Macros$$ Un hide a workbook

Respected Kaushal, If the file is hidden through a standard windows query you can go to the properties tab and uncheck the hide button to unhide the sheet.Sometimes it may be encrypted or user permissions to open or modify the file may be restricted by the system administrator or the owner of the

Re: $$Excel-Macros$$ Extract the data from one sheet to multiple sheets

Respected Pravin, Create a sheet and remove the Totals rows.This you can selecting and deleting them using filter.Then Create a Pivot table with Head quarter in the Report Filter Field and all your required fields as per your required layout.Now go to the Pivot table Options and select the Create

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

Respected Muralidhar, You can use Index,Match,Indirect functions for accomplishing some look up tasks which are not possible by VLookup. Regards, VijayKumar On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Murlidhar, Please visit here..

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

, Muralidhar E emuralidha...@gmail.comwrote: Hi, ThanksVijay. can u present me with an example,it is better to understand me. Thanks in advance. On 16 July 2013 15:07, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Muralidhar, You can use Index,Match,Indirect functions for accomplishing

Re: $$Excel-Macros$$ Pie Chart Help

for more clarification On Wed, Jun 26, 2013 at 1:57 PM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Respected priti, I tried to paste the donought chart on the pie chart,but only a single chart is showing not both charts,how should we make both charts show at a time like the one you did

Re: $$Excel-Macros$$ how to solve international decimal and comma separator issue,

Respected Divakar, You can check the following link.It might be of some help to you. http://www.yogeshguptaonline.com/2009/10/excel-number-format-indian-style-comma.html Regards, VIJAYKUMAR On Thu, Jun 27, 2013 at 4:16 PM, Divaker Pandey divake...@gmail.com wrote: Hi Expert, how to solve

Re: $$Excel-Macros$$ Pie Chart Help

Respected Ranjan, When you select the data for the chart select the complete table along with C also.You have selected in the data upto B only and plotted the Pie Chart.Select C data also and plot the Chart and you will get the chart as per your requirement. Regards, VIJAYKUMAR On Wed, Jun

Re: $$Excel-Macros$$ Pie Chart Help

query. thanks sir. [image: Inline image 1] With warm regards, Rajan Sharma On Wed, Jun 26, 2013 at 11:46 AM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Respected Ranjan, When you select the data for the chart select the complete table along with C also.You have selected in the data upto B

Re: $$Excel-Macros$$ Pie Chart Help

On Wed, Jun 26, 2013 at 12:39 PM, Rajan sharma rajansharma9...@gmail.comwrote: Thanks Priti and Vijay and to all, yes it will help me to figure out my solution. thanks a ton champs. With warm regards, Rajan Sharma On Wed, Jun 26, 2013 at 12:30 PM, P.VIJAYKUMAR vijay.4...@gmail.comwrote

Re: $$Excel-Macros$$ Pie Chart Help

Respected priti, I tried to paste the donought chart on the pie chart,but only a single chart is showing not both charts,how should we make both charts show at a time like the one you did in the attachment. Regards, VIJAYKUMAR -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Web links in word - reg.

Respected Pravin, How do I turn off automatic hyperlinks? To turn off automatic hyperlinks, follow these steps, as appropriate for the version of Word that you are running: In Microsoft Office Word 2010and 2013, follow these steps: On the File menu, click Options. Click Proofing, and then click

Re: $$Excel-Macros$$ CAPTURE ATTENDENCE FROM MULTIPLE SHEET

Respected Preethiji, Where and how did u learn these advanced excel formulas and also VBA.How to get to Intermediate or to expert level like you in Excel and VBA.Is it through regular practice or should be take coaching or classes for that. Regards, P.VIJAY KUMAR -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Need information about MOS Certificate

Respected Prabhakar, You can find information from the following links, http://www.microsoft.com/learning/en/us/mos-certification.aspx#fbid=x8BGjYz2g2o http://www.onlc.com/excel-certification-mos.html http://www.excelprodigy.in/microsoft-certification.html#.UbxVsT4isRA

Re: $$Excel-Macros$$ Excel Training Material (PPT)

Respected Prabhakar, Go to google docs through the link provided at the bottom of the mail i.e Learn Exceel with Fun.pptx.Then go to the file menu in google doc and go to the download tab to download the file. Regards, VIJAYKUMAR On Wed, Jun 12, 2013 at 1:08 PM, Prabhakar S H

Re: $$Excel-Macros$$ Re: List in Userform

Respected Chandrashekar, View the following link.Hope it helps you to create a List User form Control. http://mindkid.blogspot.in/2011/10/adding-listview-additional-activex.html Regards, VIJAYKUMAR On Tue, Jun 11, 2013 at 4:30 PM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Why

Re: $$Excel-Macros$$ help needed

Respected Thameem, After inserting the graph you get the chart tools in the menu bar. In the chart tools menu go to the formatting tab. In the last tab (to the right) you will find size munu.Click the small arrow down the tab and you will get sizing message box with size and properties tabs.In

Re: $$Excel-Macros$$ Insert Logo in Excel

Respected Pravin, Check the following link http://www.techrepublic.com/blog/msoffice/quickly-add-a-header-or-footer-to-every-sheet-in-an-excel-workbook/6601. it might be of some help to you Regards, VIJAYKUMAR On Fri, Jun 7, 2013 at 6:42 PM, Pravin Gunjal isk1...@gmail.com wrote: I have

Re: $$Excel-Macros$$ Re: Formula require

Respected Eugene Bernard, The double negative is used to coerce, as we say, a non-number type into a number type. Since only a number (not text, boolean, error value, etc.) can follow a minus sign, one minus sign forces the coercion to a number. The other just reverses the sign change caused by

Re: $$Excel-Macros$$ Marge Data from Different workssheet.

Respected Tariq, You can also download the add-in called Kutools from the following link : http://www.extendoffice.com/download/kutools-for-excel.html Regards, VIJAY KUMAR -- 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

Re: $$Excel-Macros$$ Please help Excel Gurus

Respected Harish, On what ratio do you want to distribute the amount based on the date.what are the specific criteria for distributing. Regards, VIJAYKUMAR On Tue, Jun 4, 2013 at 9:22 AM, Harish P Y py.har...@gmail.com wrote: Hi Every One, Please find the attached file, Kindly help me with

Re: $$Excel-Macros$$ Family Tree

.* -- Forwarded message -- From: P.VIJAYKUMAR vijay.4...@gmail.com Date: Fri, May 31, 2013 at 11:52 AM Subject: Re: $$Excel-Macros$$ Family Tree To: excel-macros@googlegroups.com excel-macros@googlegroups.com Respected Pravin, Please find the attached format of a family tree

Re: $$Excel-Macros$$ Video in Word File

Respected Pravin, I downloaded the file and played the video.It is a nice animation about traffic rules or road ethics. Regards, VIJAYKUMAR On Thu, May 30, 2013 at 6:10 PM, Pravin Gunjal isk1...@gmail.com wrote: *Thanks.* -- Forwarded message -- From: xlstime

Re: $$Excel-Macros$$ Family Tree

Respected Pravin, You can download the file from the following addresses http://office.microsoft.com/en-us/ctndirectdownload.aspx?AssetID=TC001021967Application=XL,Version=11Result=2 and also you have a youu tube video for that in this link http://www.youtube.com/watch?v=4Xymxie4beg. Regards,

Re: $$Excel-Macros$$ Urgent help plss..

Respected Prabhu, Verify that the other cells linked to it are not hidden.Remove any formulas or links(hyper links or other links) that the cell contains with other sheets.Also verify that whether multiple cell which are hidden around the cell are not selected when you select the cell.If the

Re: $$Excel-Macros$$ Problem in file..?

Respected Prabhu, Please go to excel options button and from there go to the advanced tab and under that go to the formulas section.The third point will contain how many processors are used for excel calculations.check the radio button to use all the processors for calculations.This may boost up

Re: $$Excel-Macros$$ Problem in file..?

option is selected. then..? Regards, Prabhu R On 23 May 2013 16:48, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected Prabhu, Please go to excel options button and from there go to the advanced tab and under that go to the formulas section.The third point will contain how many

Re: $$Excel-Macros$$ Am new to VBA - help me to became expert.

Respected Prabhu, It think the file didn't get attached.Please find them, On Fri, May 17, 2013 at 7:15 PM, Prabhu Pinky prabhupin...@gmail.comwrote: Dear Vijaykumar, which file u refer to..? i dont find any attachment. On 17 May 2013 10:02, P.VIJAYKUMAR vijay.4...@gmail.com wrote

Re: $$Excel-Macros$$ Am new to VBA - help me to became expert.

Respected Prabhu, Hope this file will be of little help to u. Regards, VIJAYKUMAR On Tue, May 14, 2013 at 9:08 PM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi all, I am very new to VBA working in MNC as a WFM specialist. we are working lots of reports on a monthly, weekly as well as

$$Excel-Macros$$ PIVOT TABLE FROM MULTIPLE SHEETS

Respected Experts, Is it possible to create a pivot table taking data (or fields) from different sheets of the workbook. Regards, P.VIJAY KUMAR -- 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$$ IF FORMULA NOT WORKING

. There are no log out times in the attachment. Please elaborate. On Wed, May 15, 2013 at 10:59 AM, P.VIJAYKUMAR vijay.4...@gmail.comwrote: Respected Experts, I Have an excel sheet which is used for getting the log-in and log-out times of employees.I have used if formulas as is seen

$$Excel-Macros$$ IF FORMULA NOT WORKING

don't understand what is the reason behind that.I hope the experts will clear and solve the matter or suggest alternative methods for achieving the goal. Regards, P.VIJAYKUMAR P.VIJAY KUMAR -- 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

Re: $$Excel-Macros$$ All Sheet Name in a Column wise.........

Respected Chaya, There is also an add-in called Ultimate add-in,Which has features like sort sheets and a lot of very useful features.It is available for 2007 and earlier excel version also.Please find the attachment and install the add-in. Regards, Vijaykumar

Re: $$Excel-Macros$$ Need help on Graph

Dear Praful, There is plenty of difference between Data Validation and a drop down box from the developer tab. The list box in the data validation or data validation in general is used for validating an entry which adheres to specified condition or not.For example when a cell or range of cells

Re: $$Excel-Macros$$ Merge entry cell

Respected Champs, Can you explain why the exponential function 10^10 is used in the formula =LOOKUP(10^10,E7:H7,E7:H7) i.e 10 to the power of 10 would yield a quite large number and how can it be useful in the look up function. Regards, P.VIJAY KUMAR -- Join official Facebook page of this

$$Excel-Macros$$ Pie Charts

Respected Guru's, I have a curious question i.e why cannot pie chart represent two sets of values.For Example if I Take a table with Employee Name ,Salaries ,PF. I can get Pie Chart for only for only two sets of values only like Name Salaries,Name PF etc.Why do not we get a pie chart for more

$$Excel-Macros$$ Calculated Field

Dear SG, Calculated field works well in table.Try Creating a table for the data than a pivot table. If you want a calculated field in Pivot Table go to formulas tab then select a calculated field and select the required function and the feils which you want to make a calculated field.

$$Excel-Macros$$ Basic and advanced VBA

Dear All, How can I Learn Basic and advanced VBA. Is any material available with the group members.Are there any websites for videos tutorials available.Please provide details and materials as they would be immensely helpful to me. Thanks for all the help and support in answering everyone's

$$Excel-Macros$$ Embed Video in Excel

Hello Hilary, To Get the video Loaded in in Excel 2007. First Save the file in Excel 97-2003 Version. Then in the properties of the embedded video you will get a custom tab in which you specify the URL or the path of the video.Then exit the design mode.Now you will have your video playing in

$$Excel-Macros$$ Finacial Excel Work Books

Hi, Roopesh, For Financial excel sheets you can visit www.exinfm.com which has about 100 free excel sheets catering fianancial topics. Regards, P.VIJAY KUMAR -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for

$$Excel-Macros$$ Embed video in excel

Hi Hillary, The main mistake you are doing is trying to play video from the site.First save the required video or game to your PC. Then try embedding the videos in Excel 97-2003 as explained earlier and it definitely works. I have embedded many videos in excel. Regards, P.VIJAY KUMAR -- Join

$$Excel-Macros$$ Excel Finacial Dash Boards

Hello Pankaj, To get more financial Dashboards and templates visit www.exinfm.com. Regards, P.VIJAY KUMAR -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

$$Excel-Macros$$ converting excel file into xml file

Dear Gurus, Is there any method to convert Excel file into XML format.In some specific software for impotring data .the data should be in xml format only,then only we can import the data.I need any macro method or any thing which converts excel data into XML FILE FORMAT Thanking you all ,

Re: $$Excel-Macros$$ Thanks everyone.

“hijack” a thread to ask a question. Instead, start your own with a new subject line. However, can you not use dataautofiltercustomends with DR? *From:* P.VIJAYKUMAR vijay.4...@gmail.com *Sent:* Tuesday, October 04, 2011 8:22 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel

Re: $$Excel-Macros$$ Thanks everyone.

Dear Ayush , Congrats on your second achievement, I have a problem with excel.Generally I work with Tally and Excel.When I export accounting Data into excel, I am getting the data with debit and credit along with the number i.e I am getting the data in custom format ( 0.00 Dr). It is not

$$Excel-Macros$$ EXCEL VBA

Dear All, I am Completely new to VBA.I don't know its terminology and how to write programs to execute specific action in Excel.I want to learn Excel VBA in an easy way.Any E book would be of immense help to me and other people would like to learn VBA.Please upload any VBA material .

$$Excel-Macros$$ Problem with Nested IF formula

Dear Ashish, In our company we give cash discounts for the dealers who pay cash within the stipulated time period. The conditions are as in the following table CD POLICY FOR THE MONTH OF OCTOBER SlNo. CD PolicyCategory 2 Lakhs 1 Lakh 1 Lakh 1 Advance 10% 9% 8% 2 30 Days 8%

Re: $$Excel-Macros$$ How to use a drop down list to select data from another sheet

Dear Steve, If you want to get a drop down list for data that is in Other sheet, First set the cursor or ur position where u want the list to appear then go to the sheet which you have the data then select all the Data and give a name to the range of cells you have selected or in other words

Re: $$Excel-Macros$$ Change / Arrange no. of order of Sheets - Help

Dear Rohan, You can download and install an add-in called Ultimate Add-in which contains many useful features along with a feature to sort work sheets. Regards, VijayKumar On Fri, Dec 31, 2010 at 11:31 AM, Rohan Young rohan.j...@gmail.com wrote: Hi Experts, Gud morng wishing u all a

Re: $$Excel-Macros$$ new que - help required for large range of data filteration

Hi, When you use filter excel only arranges the data according to the user specified criteria whereas the original data remains the same.When you do delete entire rows the original data gets effected and gets deleted.If you want to delete rows given by the filter after filtering select the

Re: $$Excel-Macros$$ New Rupee Symbol

Dear Kumar, After installing the font the Rupee Symbol appears only if Rupee Foradian font is selected and ~ is pressed you can have the rupee symbol. Regards, Vijay On Sat, Dec 18, 2010 at 10:38 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Dear All, I want to use New Rupee symbol and

Re: $$Excel-Macros$$ How can i enable all macros when start excel?

Hi, If you are using Excel 2007 ,then go to the Ribbon button ,Then Click the Excel Options button .You will get a box with all the settings.In that select Trust Center Settings. again a new box will appear with Settings for Active X control and Macro settings etc.Select macro settings..In the

Re: $$Excel-Macros$$ Excel Date format dd/mm/yyyy hh:mm:ss

Hi, Forst Select your dat then go to format in the Home Menu(if your using Excel 2007) or format if you are using older versions.In the format menus dialog box you can select date formats as you like.At the last the is Customs format. If you select that and specify what ever type of format you

Re: $$Excel-Macros$$ data cleaning in excel

Hi, You can download an add-in called asUltimate add-in which is available for Excel @007 and for older versions also(Excel 2000.2003,2005 etc). It contains a tool called Duplicate remover. There are also mainy other very useful tool in that add-in which will be very useful to you.But make sure

Re: $$Excel-Macros$$ manage lengthy database

Hi Rakesh, You can also change gridline colour or give colours to the cells in which you want to see your Cursor.To change thecoulour of gridline(if you are using excel 2007) Go to the Excel ribbon Button then go to the Excel option Button In that go to that advanced option. In that advanced

Re: $$Excel-Macros$$ vba to notepad

Dear krishna, It is possible to copy the contents of Excel to note pad.But, the only problem is the pasted content will not maintain the same format as in Excel. Regards, Vijaykumar On Mon, Oct 18, 2010 at 12:47 AM, Krishna krishnaja...@gmail.com wrote: How can we copy the contents from

Re: $$Excel-Macros$$ vba to notepad

Dear Krishna, I mean we can copy the range of cells A1:B5 from excel to note pad. But , it is very difficult to copy the whole workbook to notepad. Regards, Vijaykumar On Mon, Oct 18, 2010 at 12:47 AM, Krishna krishnaja...@gmail.com wrote: How can we copy the contents from excel to notepad.

Re: $$Excel-Macros$$ Time in Decimal format

Dear Vijay After slecting your required data go to Format menu in that there are a number of formats.In the last there is Custom Format,By selecting that you can specify your own format.In that specify the format you want to have your data,Your data will be changed to the format you wanted.

Re: $$Excel-Macros$$ Quick help needed to Find duplicate by formula

Dear Ansari, You can use Data Validation for the duplicates, Regards, Vijay On Wed, Oct 13, 2010 at 8:43 PM, vinod rao vinod.ma...@gmail.com wrote: HI I have multipal duplicate numbers and excluding one for others it should say duplicate. how do i enter formula in 2003/2007 Thanks

Re: $$Excel-Macros$$ Games in excel

Dear Vijay, How to Embed Flash Game in Excel Spreadsheet Intructions Things You'll Need: - Microsoft Excel(this how-to is based on the 2007 version) - A downloaded flash game - internet connection 1. Download free flash game online or use one you already have 2. Open Excel

Re: $$Excel-Macros$$ Add-In

Dear Friend, Add-in in Excel is any tool (other than the normal available) ones which does a specified activity i.e detecting and eliminating duplicates,finding difference between dates etc, .it is a sfecfically written Macro or VBA which performs specific tasks in an easy manner. you can get

Re: $$Excel-Macros$$ DATA VALIDATION AND HYPERLINK

Dear Arif, No file is attached, Regards, Vijaykumar On Thu, Oct 7, 2010 at 5:34 PM, arif massani arifmass...@gmail.com wrote: THERE IS NO FILE ATTACHED On Thu, Oct 7, 2010 at 5:08 PM, santanu_ca santanu...@gmail.com wrote: HI I HYPERLINKES A SHEET WITH ANOTHER SHEET IN SAME WORK BOOK BUT

Re: $$Excel-Macros$$ write to end of page to foot total

Hello, You can link the total of the first page to the following page by keeping = and selecting the previous page total to next page opening balance total. this is Explained by the attached sheet. Regards, VIJAY KUMAR --

Re: $$Excel-Macros$$ Numer To Text

Dear Ankit , There is also an add-in called Ultimate add-in which contains a lot of other features like finding and removing duplicates, transposing cell contents between two cells etc, along with text to numbers conversion feature. But,unfortunately some features of them are not working.But it

Re: $$Excel-Macros$$ Numer To Text

for deteil knowledge but again same problem *how we can use add-in? plz tell me * ** Thnanks Regards Ankit On Tue, Oct 5, 2010 at 8:30 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Dear Ankit, There is no Direct formula to convert numbers into text.But there are some add-ins available

Re: $$Excel-Macros$$ Help in sending the salary slip

Hello Ankit, I did not understand you question properly. Why do use mail merge .You can create single sheet work book as you salary ship and give password to it and also mail the password to the concerned person through a text file attached along with the salary sheet. Regards, P.VIJAY KUMAR

Re: $$Excel-Macros$$ Numer To Text

Dear Ankit, Here is a code that might help you. It is didvided into prts depending upon your requirement copy and pate the required part in Visual basic. '' Main Function *' Function SpellNumbers(ByVal MyNumber) Dim Rupees, Paise, Temp Dim DecimalPlace, Count

Re: $$Excel-Macros$$ Numer To Text

Hello Ankit , There are also add-ins which will be able to install in 2003.Download Ultimate add-in. There are two versions of That New one will be in 2007 but the old one can be installed in old versions also.For installing add-ins in old versions of Excel the process is different.The add-ins

Re: $$Excel-Macros$$ Numer To Text

Dear Ankit, There is no Direct formula to convert numbers into text.But there are some add-ins available in the websites. just google for text to numbers converter in excel add-in. Once you download the add-in to install the add-in to excel go to the excel ribbon Button, the from there open

  1   2   >