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 offering courses on >> Finan

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 wrote: > Dear Anil, > > I get an error "Can't find the project or library" , at the second line > "Dim Myconnec

Re: $$Excel-Macros$$ Display Vlookup dialog box with vba code

Respected Douglous, I don't know how to open or do vlookup by VBA using dialog box,but if you are using excel 2007 then you can have lookup wizard. Click the Microsoft Office Button , click Excel Options, and then click the Add-ins category. In the Manage box, click Excel Add-ins, and then cli

$$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: http://blogs.office.com/b/microsoft-excel/archive/2013/09/24/invitation-to-join-modeloff-20

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

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

there are may sites also that meet your requirement. Regards, Vijaykumar On Thu, Sep 19, 2013 at 12:57 PM, P.VIJAYKUMAR 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$$ Microsoft Excel based application that digitizes data from pictures

Respected Mog-Godiva, You can find the digitizer from the following links, http://digitizer.sourceforge.net/ http://www.mathtools.net/Excel/Graphics_and_Visualization/ Regards, Vijaykumar On Wed, Aug 21, 2013 at 5:43 AM, Mog Godiva-Man wrote: > Anyone know where I can get some Addin for digi

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. http://en.wikipedia.org

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 cod

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 wrote: > Dear Shri Satendra Kumar, > Thank you for your suggestion. However, what I wanted is "Running > Bal

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 wrote: > Join such groups on FB > > On 8/10/13, Kaushal Kumar wrote: > > Hi All, > > > > Is ther

Re: $$Excel-Macros$$ Pivot Answer

1. I'll have latest dump in the dumb sheet >>> 2. 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 Mo

Re: $$Excel-Macros$$ Text to number format while opening a file

Respected Ranjan, Start macro recording.Then select all the numbers in the form of text.you will get an evaluation or error correction symbol.Click the evaluation symbol and you will get some options one of which will be convert to number.After converting the text into numbers stop the macro recor

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 wrote: > Respected Kathirvelan, > > Pivot table sigma v

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 wrote

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

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 rev

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 http://www.you

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 wrote: > in this file, there is sheet named "Sale Summary". > > In the column labels, I have put Year and below that i put month. > but the mont

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 http://chandoo.org/wp/

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 wrote: > ** ** > > K do one th

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 c

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/ http://www.password-find.com/excel_password.html?gc

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 wrote: > Hai everyone > > I attache

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 wrote: > 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: > >> Hi, >> >> I

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 memo

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

l 18, 2013 at 4:07 PM, P.VIJAYKUMAR wrote: > >> 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

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. http://www.cpearson.com/excel/arrayformulas.aspx

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

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, अनिल नारायण गवली wrote: > Dear Rajesh, > > Pl see the a

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$$ 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: $$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 =NOT(EXP(E

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

, Muralidhar E wrote: > 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 wrote: > >> Respected Muralidhar, >> >> You can use Index,Match,Indirect functions

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 wrote: > Dear Murlidhar, > > Please visit here.. > > http://www.excelvbaclinic.com/2011/0

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$$ Pie Chart Help

gt; Rajan Sharma >> >> >> >> On Thu, Jun 27, 2013 at 12:27 PM, priti verma >> wrote: >> >>> Hi vijay, >>> Pfa for more clarification >>> >>> >>> >>> On Wed, Jun 26, 2013 at 1:57 PM, P.VIJAYKUMAR wrote: >>> &g

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 wrote: > > Hi Expert, > > how to solve international

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 wann

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

On Wed, Jun 26, 2013 at 12:39 PM, Rajan sharma wrote: > 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 wrote: > >&

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

nderstand my query. thanks sir. > > [image: Inline image 1] > > > > With warm regards, > Rajan Sharma > > > > On Wed, Jun 26, 2013 at 11:46 AM, P.VIJAYKUMAR wrote: > >> Respected Ranjan, >> >> When you select the data for the chart select t

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

Re: $$Excel-Macros$$ Charts

Hi, the legend font, axis font, titles font, etc. are linked to the body font of the active theme (see Page Layouttab). Create a workbook template with your on theme with the desired font as the body font and save it as Book.xltxin the XLStart folder. Regards,VIJAYKUMAR On Wed, Jun 26, 2013 at

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

Respected Pravin, You remove the chech box for internet under Autoformat tab and also under Auoformat as you type tab.If you remove the check mark under autoformat as you type you will not get link even if you press enter.To explain it more clearly: Turn off automatic hyperlinks To turn off aut

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 Au

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 =NOT(E

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 http://www.ehow.com/how_6240

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 wrote: > Hi, > I

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 d

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 the

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 wrote: > I have attached a sample fil

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$$ 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 wrote: > Hi Every One, > Please find the attached file, > Kindly help me with the required for

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 Faceboo

Re: $$Excel-Macros$$ Family Tree

r. Vijay.* >> >> -- Forwarded message -- >> From: P.VIJAYKUMAR >> Date: Fri, May 31, 2013 at 11:52 AM >> Subject: Re: $$Excel-Macros$$ Family Tree >> To: "excel-macros@googlegroups.com" >> >> >> Respected Pravin, >>

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=TC001021967&Application=XL,&Version=11&Result=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$$ 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 wrote: > *Thanks.* > > -- Forwarded message -- > From: xlstime > Date: Thu, May 30, 2013

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 ce

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

>> >>> >>> >>> On 23 May 2013 21:26, Prabhu Pinky wrote: >>> >>>> thanks vijay, lemme try this too. >>>> >>>> but my doubt is if already "Use all the processors on this computer" >>>> option is select

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$$ 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 wrote: > Dear Vijaykumar, > > which file u refer to..? i dont find any attachment. > > > > On 17 May 2013 10:02, P.VIJAYKUMAR wrote: > >>

$$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$$ 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 wrote: > 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 daily basis. > > i cam

Re: $$Excel-Macros$$ IF FORMULA NOT WORKING

log out times in the attachment. > > Please elaborate. > > > On Wed, May 15, 2013 at 10:59 AM, P.VIJAYKUMAR wrote: > >> 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 formul

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

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

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 a

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 fo

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

$$Excel-Macros$$ Nice Chart

Dear Rajan, Excellent work buddy.Can you please mention the steps required to create a chart like that?Does it work with Excel 2007? Regards. P.VIJAY KUMAR -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for viol

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

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

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

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

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

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

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

thread to ask a question. Instead, start > your own with a new subject line. However, can you not use > data>autofilter>custom>ends with DR? > > *From:* P.VIJAYKUMAR > *Sent:* Tuesday, October 04, 2011 8:22 PM > *To:* excel-macros@googlegroups.com > *Subject:*

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 possible

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Dear Krishna, The profile of MIS Executive changes with the type organisation.If it is a small organisation MIS Executive role would be to prepare normal reports like the work you do.If it is a big and reputed organisation your role in addition to normal report preparation would be to do fianaci

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

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

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 wrote: > Hi Experts, > > Gud morng & wishing u all a very HAPPY NEW YEAR

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 cre

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 requir

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 wrote: > Dear All, > > > I want to use New Rupee symbol and did the following; > >

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 o

Re: $$Excel-Macros$$ To avoid repetitions of figures in the same column

Hi Anubhav, You can prevent repetition of PO Numbers by Data validation.First select The PO column.Then in The Data Menu go to Data Validation.in that Select Data Validation option.You will get a dialog box with three options.Select the Settings button.you will get a drop down list under Allow.

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 opt

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

Hi, You can download an add-in called as"Ultimate 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$$ 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 w

Re: $$Excel-Macros$$ Help on Graph

Dear Srinivas, Just keep zeros whereever there are no values. Regards, Vijaykumar On Wed, Oct 20, 2010 at 12:17 PM, Shrinivas Shevde wrote: > Dear All, > Can Any one help me on graph ? > Thanks in advance. > -- > Shrini > > -- > > ---

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 wrote: > How can we copy the contents from excel to notepad. For instance the > ra

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 wrote: > How can we copy the contents from excel to notepad. For inst

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

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

Re: $$Excel-Macros$$ Query :- Copy Only Filtered Data in Excel..

Dear Ansari, After filtering the data,select the filtered data and then press Alt+;(Select Visible cells Only) the you can paste only the filtered data any were you want. Regards, Vijaykumar -- -- Some important l

  1   2   >