Re: $$Excel-Macros$$ Exporting emails in excel

Apologies for not "adding" to this thread. But could not help but smile at the image after the question by Rajan. :-) :-) Thanks Ashish Pradhan On 28-08-2012 22:48, Rajan_Verma wrote: *Where you want to export, How you want to export ?* ** *Will you please elab

Re: $$Excel-Macros$$ Urgent Required Sr Oracle DBA ,CA

Hi, This guy certainly deserves to be banned. Thanks Ashish Pradhan On 23-08-2012 21:28, karan bhatia wrote: *Please respond to **ka...@hmgamerica.com <mailto:ka...@hmgamerica.com>* *Position: Sr.Oracle DBA* *Location: Bora bank,CA* *Duration: Long Term * *Strong Knowledge of

$$Excel-Macros$$ Out of Topic -- Request

olutions provided by Noorain and many other experts. Any suggestions? Thanks Ashish Pradhan On 14-08-2012 17:57, NOORAIN ANSARI wrote: Dear Kenil, Without using ctrl+shfit+enter You can also use.. =SUMPRODUCT(MIN(($D2:$G2>0)*($D2:$G2))) =SUMPRODUCT(MAX(($D2:$G2>0)*($D2:$G2))) On Tu

Re: $$Excel-Macros$$ Re: Sorting & v-look up issue - reg.

ril". Then used the regular "Filter" to sort on the additional column created -- Month. Most likely a longer method of solving the issue. CoRe's solution works great. (And without the need to add any column). Thanks Ashish Pradhan On 13-08-2012 15:55, CoRe wrote: Hell

Re: $$Excel-Macros$$ Re: Sorting & v-look up issue - reg.

ril". Then used the regular "Filter" to sort on the additional column created -- Month. Most likely a longer method of solving the issue. CoRe's solution works great. (And without the need to add any column). Thanks Ashish Pradhan (M) 9167594244 On 13-08-2012 15:55, Co

Re: $$Excel-Macros$$ Help with Formula Destination

Dear Kantilal, Sam & Ashish All your options work and are helpful. Appreciate your help and thanks a lot (Couldn't respond earlier as I was away) Thanks Ashish Pradhan On 07-08-2012 10:56, Kantilal Badale wrote: Try CTRL+[ ] from formula cell CA Kantilal Badale E-Hall, First Fl

$$Excel-Macros$$ Help with Formula Destination

do this much earlier, but either I am mistaken or have simply forgotten. Any help / clarification would ease my work a lot and be highly appreciated. Just as an additional piece of information, I use Excel 2003 (SP3) -- Thanks Ashish Pradhan -- Join official facebook page of this forum @

Re: $$Excel-Macros$$ Re: Multiple Versions of Excel

Hello Ashish Kumar Thanks for your suggestion. I did face minor issues like the latest (licensed) version of 2010 opening up even when I needed the earlier version to open. Thanks Ashish Pradhan On 30-07-2012 22:38, kumar.ashish861 wrote: Dear Ashish Pradhan, Don't use two versio

Re: $$Excel-Macros$$ Multiple Versions of Excel

Hi Anoop, Both the version of Excel are working just fine. Not quite sure though where the idea of "theft" came in from though. Thanks Ashish Pradhan On 30-07-2012 10:12, Anoop K Sharma wrote: Hi Ashish, You won't face any version clash issue after installing Office 20

Re: $$Excel-Macros$$ Please Tell Me

What has this link to do with Excel?? Thanks Ashish Pradhan On 10-06-2012 17:31, Nazia Menaz wrote: Please Add Your Id This Link http://shorttextmassages.blogspot.com/ <http://shorttextmassages.blogspot.com/> -- FORUM RULES (986+ members already BANNED for violation) 1) Use c

Re: $$Excel-Macros$$ Chronos Twelve For Excel 2007

Hey Sam Thanks a lot for the prompt clarifications. Hope to use it soon. -:) Thanks Ashish Pradhan On 30-05-2012 00:23, Sam Mathai Chacko wrote: Ashish, Yes this can be used for Windows 7. The only reason I thought Windows 7 users may not find it too useful is because Windows 7 start menu

Re: $$Excel-Macros$$ Chronos Twelve For Excel 2007

o the very basic question of how to install in the first place. Sorry, am a decent user of Office Products, but not too advanced. This group goes a long way in enhancing my skill sets though :-) ) Thanks Ashish Pradhan On 29-05-2012 23:54, Sam Mathai Chacko wrote: Ever wished you could hav

Re: $$Excel-Macros$$ Multiple Versions of Excel

Hey Thanks Don and CoRe for the prompt replies. Am going ahead with the multiple installations. Hope all goes well. :-) Thanks Ashish Pradhan On 29-05-2012 20:25, dguillett1 wrote: Just install in a directory OTHER than the previous verion. ie: MyExcel2010 Don Guillett Microsoft MVP

$$Excel-Macros$$ Multiple Versions of Excel

y recently, someone suggested on this forum that multiple versions can be installed. Has anyone ever faced any "Version Clash" issues before? -- Thanks Ashish Pradhan -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titl

Re: $$Excel-Macros$$ Urgent Client Position ::: Java Developer - Work Location: Palo Alto, CA

Just Curious but wasn't a rule made just a few days back regarding the blocking of people sending Job Postings ? Thanks Ashish Pradhan On 24-05-2012 22:42, resp...@gmail.com wrote: Why do you keep sending this ad over and over again. Sent from my BlackBerryŽ smartphone from Airtel

Re: $$Excel-Macros$$ Apportioned of Expenses

) that I use. Can anyone help with using the same sheet with formulae for Excel 2003 (If thats why I am getting the #Name? error) Thanks Ashish Pradhan On 18-05-2012 19:07, ashish koul wrote: see if it helps On Fri, May 18, 2012 at 6:20 PM, dguillett1 <mailto:dguille...@gmail.com>&

Re: $$Excel-Macros$$ Financial Analysis Dashboard

directly to Sanjib. Thanks Ashish Pradhan On 15-05-2012 13:54, Sanjib Chatterjee wrote: The file is blocking by the antivirous for suspecting virus. regds, Sanjib On Mon, Apr 30, 2012 at 10:07 PM, hilary lomotey <mailto:resp...@gmail.com>> wrote: Hi Guys, i just com

$$Excel-Macros$$ Updates to Excel

Hello New updates to the Microsoft Office 2003 is now available from Microsoft. This is for your information only. -- Thanks Ashish Pradhan -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

$$Excel-Macros$$ Hiding Work Sheets

t to "unhide" again when I go to Format -- Sheet -- Unhide. What am I doing wrong? Is there any other way to simply password protect the feature of "hiding" a work sheet? Any help would be appreciated. -- Thanks Ashish Pradhan -- FORUM RULES (986+ members already BANNED

Re: $$Excel-Macros$$ new

What is this? ? ? ? Thanks Ashish Pradhan On 05-04-2012 11:27, جمال دغيدى wrote: *Dear valued customers * *Please send all new value of your involvement * *Greetings * * * * * *Gamal deghady * *Egypt * *تقبلوا تحياتى * *جمال دغيدى* -- FORUM RULES (986+ members already BANNED for violation

Re: $$Excel-Macros$$ Look up and Auto Update ?

Hello Maries Thanks for the express fast reply :-) This works beautifully for me and exactly as I had hoped for. Thanks a lot. Appreciate it. Thanks Ashish Pradhan On 03-04-2012 02:11, Maries wrote: Hi, PFA. Regards, MARIES. On Mon, Apr 2, 2012 at 9:27 PM, Ashish Pradhan

$$Excel-Macros$$ Look up and Auto Update ?

Hello I need a bit of a help with the attached excel file. (Formula would be best as I want to avoid the use of Macros / VBA) The attached excel file has two sheets: Cheque Entries Sheet: I shall be inserting data in Columns E, F, G, H and I on a regular basis. (Entries shall also be made in

Re: $$Excel-Macros$$ Fashion and you -- Get Enrolled and Win 1000 rs

Excel Forums now-a-days being used for marketing activities Ashish On 01/12/2011 20:39, Mr Excellent wrote: Hi, Join the Fashion Group and get 1000rs on intial enrollment and get waived off in the initial transaction Fashion Group : A Place with more discounts and less money incurred...

Re: $$Excel-Macros$$ Help with =now()

Hello Rajan Thanks a lot. It works Thanks Ashish Pradhan On 8/5/2011 5:44 PM, Rajan_Verma wrote: *Use this Format :* *-* ** *From:*excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *On Behalf Of *Venkat CV *Sent:* Friday, August 05, 2011 5:05 PM *To:* excel

Re: $$Excel-Macros$$ Help with =now()

have suggested.. Thanks Ashish Pradhan On 8/5/2011 4:41 PM, Venkat CV wrote: Hi Ashish, Select Entire row and goto format cells and Type as below *mmm *after type Now() It will show as u required... for more please attach sample worksheet... *Best Regards,* *Venkat * *Chennai* * * On Fri, Aug

$$Excel-Macros$$ Help with =now()

e obtained under Format Cells -- Date) 2. In the same cell, I would like to enter "As on =now()" with the same condition as mentioned above. Is this possible? -- Thanks Ashish Pradhan -- -- Some important l

Re: $$Excel-Macros$$ Re: Help with Budget - Formula

Behalf Of Ashish Pradhan Sent: Wednesday, May 18, 2011 2:00 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Help with Budget - Formula Hello Guys Any help? Thanks Ashish Pradhan On 5/15/2011 10:52 PM, Ashish Pradhan wrote: Hello All Please see attached an excel file. I

Re: $$Excel-Macros$$ Re: Help with Budget - Formula

, Ashish Pradhan mailto:ashlyprad...@gmail.com>> wrote: Hello Guyscell Any help? Thanks Ashish Pradhan On 5/15/2011 10:52 PM, Ashish Pradhan wrote: Hello All Please see attached an excel file. I need a formula to automatically reduce the c

$$Excel-Macros$$ Re: Help with Budget - Formula

Hello Guys Any help? Thanks Ashish Pradhan On 5/15/2011 10:52 PM, Ashish Pradhan wrote: Hello All Please see attached an excel file. I need a formula to automatically reduce the closing balance from the proper "Funds" wherever there are instances of the "funds" be

$$Excel-Macros$$ Help with Budget - Formula

Hello All Please see attached an excel file. I need a formula to automatically reduce the closing balance from the proper "Funds" wherever there are instances of the "funds" being utilised. The attached excel file will give more clarity. Please let me know if you need any more clarity. Th

Re: $$Excel-Macros$$ Rank the data

Hi You can use the formula =RANK(C5,$C$5:$C$14) I have used Rent as the Ranking Criteria. If you want to use Total Collection, simply change C5 in the above formula to E5. Copy the formula in all the required cells. Thanks Ashish On 5/13/2011 8:20 PM, Rajesh K R wrote: Hi Experts, Pls

Re: $$Excel-Macros$$ Help With UserForms

ink I would benefit in my programming by utilising Userforms but I have always shied away from them Thanks in advance Brian Scotland On Jan 27, 4:52 pm, Ashish Pradhan <mailto:ashlyprad...@gmail.com>> wrote: > Hello Ashish > > This file is amazing. Just as I had hoped for. Never ce

Re: $$Excel-Macros$$ Help With UserForms

now but there should be validations for data. e.g. in date text box if u write "jsdhg" it will accept this also and so on. there shud b data validation for this. ---- *From:* Ashish Pradhan *To:* Excel Help *Sent

Re: $$Excel-Macros$$ Help With UserForms

my programming by utilising Userforms but I have always shied away from them Thanks in advance Brian Scotland On Jan 27, 4:52 pm, Ashish Pradhan wrote: Hello Ashish This file is amazing. Just as I had hoped for. Never ceases to amaze me about the power of excel in the hands of people with

Re: $$Excel-Macros$$ Help With UserForms

brilliant stuff. Ashish On 27/01/2011 11:51 AM, ashish koul wrote: check this out On Thu, Jan 27, 2011 at 11:13 AM, Ashish Pradhan mailto:ashlyprad...@gmail.com>> wrote: Hello Ashish Excellent Stuff. One Request. Is it possible to freeze the following to accept only w

Re: $$Excel-Macros$$ Help With UserForms

e userform be closed after the data is saved? Also, am looking at the way in which the sorting of dates is done in the Details Sheet. Am not sure what is happening. Can I look at it in more detail and request more help if required? Thanks a lot Ashish Pradhan On 27/01/2011 09:36 AM, ashish k

$$Excel-Macros$$ Help with Print Preview

time. I think it is called Grouping of sheets. But the problem is that if I have many sheets (possibly 15-20 or even more), then selecting all the sheets by Ctrl+ Select is a very tedious job. Am using Excel 2003 (SP3). Any possibilities? Th

$$Excel-Macros$$ Re: Help with Print Preview

Hello Guys Got the solution to my problem described here. Simply right-click on any sheet and select "Select All Sheets" :-D A very very preliminary error on my part. Sorry for the trouble. :-[ Thanks Ashish Pradhan On 25/01/2011 16:37 PM, Ashish Pradhan wrote: Hello I was wo

Re: $$Excel-Macros$$ Fwd: Village

Hello Roberto Thanks for the link. But is there a way to get an english translation of the site? The link takes me directly to the page and to a language I do not understand :) I use Mozilla Firefox (If this is any help) :) Thanks Ashish On 11/5/2010 3:39 PM, roberto mensa wrote: little

Re: $$Excel-Macros$$ Attendance

Hi I have made and sent this file earlier. Please see if you can locate this file somewhere in the 'Files' section. The name of the file should be 'tracker.xls' or 'attendance.xls' Ashish On 5/8/10, Kantilal Badale wrote: > Hi all, > > Please suggest solution for attached sheet > > Thanks > >

Re: $$Excel-Macros$$ Export from word to excel

__ > "There are known knowns. These are things we know that we know. There are > known unknowns. That is to say, there are things that we know we don't know. > But there are also unknown unknowns. There are thin

Re: $$Excel-Macros$$ Export from word to excel

now. > But there are also unknown unknowns. There are things we don't know we don't > know." > > > -- > *From:* Ashish Pradhan > *To:* excel-macros@googlegroups.com > *Sent:* Mon, 4 January, 2010 2:03:44 PM > *Subject:* Re: $$Excel-Macros$$ Export from word to

$$Excel-Macros$$ Export from word to excel

Dear All, This may possibly not be the correct forum to ask my question. My problem is as follows: I have a word document file in the following format; Name Address1 Address2 Area City - Pincode (M) I now need to extract only the number which is mentioned after the field (M) into an excel file.

$$Excel-Macros$$ Re: Another milestone of the group : 6000 members

Dear Ayush and Ashish, Congratulations to both of you and thank you for creating this wonderful forum to learn excel from the masters in this group. Thanks Ashish On 9/6/09, Ayush wrote: > > Dear Members, > > Finally With all your support and good wishes we have completed 6000 > Members in o

$$Excel-Macros$$ Re: urgent - How to calculate sum of only positive numbers

Sirjee One additional help required on ur solved work sheet regarding the problem by Anilji. Noticed what i feel is strange behaviour. I use Excel2007. Your formula with {=SUM(IF(E4:E8>0,E4:E8,""))} work fine but the moment i click to edit on the cell where this formula is entered, the {} (bracke

$$Excel-Macros$$ Re: When searching default to workbook vs. sheet

HI JMR No need to do any configurations. Simply right-click any of the sheet and select "select all". Now do a CTRL+F and you will find your search string across all the work sheets. -- Ashish “If you enter this world knowing you are loved and you leave this world knowing the same, then every

$$Excel-Macros$$ Re: Convert number in words

Hi Vikas This request was posted earlier by one of our friends. Heres the macro to convert numbers into words. Sub SetNums() Numbers = Array("", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Sevent

$$Excel-Macros$$ Re: colour coding alternate weeks

Hello Lynn In Conditional Formatting, you can use the formula (Please select the entire column or rows where you have the dates) =MOD((1+INT(($A2-DATE(YEAR($A2+4-WEEKDAY($A2+6)),1,5) +WEEKDAY(DATE(YEAR($A2+4-WEEKDAY($A2+6)),1,3)))/7)),2)=0 However, this formula is not exactly correct because Wee

$$Excel-Macros$$ Re: Need Macros for Track Changes

his is, that whenever anyone make changes on the > worksheet(which is in shared mode) and save it, then the changes should be > highlighted in a diff. worksheet or workbook. > > Regards > Pooja > *** > > > On Thu, Jul 9, 2009 at 2:38 PM, Ashish Pradhan wrote: &g

$$Excel-Macros$$ Re: VLookup formula

Dilipji Even though the solution to this problem was not requested by me, I must tell you that just seeing the solutions you and a few others so regularly provide have helped me understand Excel a lot more. Thanks a lot for your contributions, Dilipji and many others who help us in understanding

$$Excel-Macros$$ Re: attendance sheet

Hello Yes Shafiq, you are correct. Wonder how sometimes we thing of the bigger picture but forget the basics -:) -:) Thanks for reminding me. -:) Thanks -- Ashish "Of what use is freedom if it does not include the freedom to make mistakes" -- Mahatma Gandhi On 7/15/09, shafiq online wrot

$$Excel-Macros$$ Re: Help with Combo Box and Display

; > if u make addition to the master table, you just need to run the macro once > again and the combo box will get filled with the unique values > automatically.. > > Hope this helps. > > > Regards, > Vivek Agrawal > Skype ID - vivek.agrawal83 > > GoogleMoonli

$$Excel-Macros$$ Re: Please give me a solution urgent.!!!!!!!!!!!!

Hello Amresh Kindly copy the following in a new module in VBA. After that, use the formula =wordnum() --- (Insert cell number within brackets) For eg. A1=111; use formula in B1 as =wordnum(A1) to get One Hundred and Eleven as result. Let me know if this works. Option Explicit Public Numbers As

$$Excel-Macros$$ Help with Combo Box and Display

Hi Been racking my brains for a few days but simply seem to have blanked out. I have an excel file with the following headers. Product|Version|Status|Date|Executive|Company Name|Contact| Note: All the rows under the headers can be repeated multiple times. Filter is an obvious method to get data

$$Excel-Macros$$ Re: Need Macros for Track Changes

Hello Pooja To track changes on a new work sheet kindly follow the steps given below. 1. Activate the Track Changes Feature. 2. Assume that the changes have been made and saved in the work book. After changes have been made to the workbook, you can automatically create a new worksheet that lists

$$Excel-Macros$$ Re: Urgent!!!!!!!!!!

range where the City Names are entered. This will give a count of all cities found using the countif function. Thanks Ashish Pradhan On 7/9/09, amresh kumar wrote: > > Hi Team, > > i want learn more of countif function. > > example > > City Delhi Mumbai Mahar

$$Excel-Macros$$ Re: Enable Selection to Unlocked Cells only

lo Ashish, > > Can you help me to do the same in office 2007. new to 2007 hence need help. > > Thanks and Regards > Atul Kesaria > > On Tue, Jul 7, 2009 at 11:45 AM, Ashish Pradhan wrote: > >> >> Hi All >> >> Not sending this tip in the "best

$$Excel-Macros$$ Enable Selection to Unlocked Cells only

Hi All Not sending this tip in the "best tip for the week" format as this is not my original idea but nevertheless a useful tip In a protected worksheet, a user may want to navigate only to those cells which are unlocked. i.e., Navigation should not be allowed to those cells which have formula (f

$$Excel-Macros$$ Re: Help with Attendance Tracker & Salary Calculation

ion, the int() approach in my previous mail, still needs the > 30 >> check, else it won’t work if the days worked is less than 30. >> >> >> >> Regards >> >> >> >> Ajit >> >> *From:* excel-macros@googlegroups.com [mailto: >> e

$$Excel-Macros$$ Re: Help with Attendance Tracker & Salary Calculation

ment. The if statement > simply returns 30 if the *DaysWorked* is greater than 30, if not - returns > the *DaysWorked* and then we divide it by 30, keep that /30 out of if(). > > > > Ignore the INT() stuff. That is wrong. > > > > Regards, > > > > Ajit &g

$$Excel-Macros$$ Re: Help with Attendance Tracker & Salary Calculation

ent > 30, 30, No. Of Days Present) / 30)). Other > way to put it would be – (Monthly Salary * Int(No. Of Days Present / 30)). > > > > Regards > > > > Ajit > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf

$$Excel-Macros$$ Help with Attendance Tracker & Salary Calculation

Hello I need help with some calculations in the attached excel file. What I am trying to do is to calculate the salaries of personnel depending on the total number of days worked. My problem is with the sheets which carry data for Months which have 31 days. All Salary Calculations are done on 30

$$Excel-Macros$$ Re: How?

Excel Macros to > you. > > -- > Sathyan From MADURAI > Other ID: > kainoorsath...@hotmail.com > > > > -- "I disapprove of what you say, but I will defend to the de

$$Excel-Macros$$ Re: Removing Hyperlinks

the > ribbon, click the down-arrow under the Paste tool at the left of the ribbon, > and then choose Paste Special.) > Select the Multiply radio button. > Click OK. All the hyperlinks are removed, but the text of the hyperlinks > remain. > Delete the cell you crea

$$Excel-Macros$$ Re: Removing Hyperlinks

ya > > On Fri, Jun 12, 2009 at 12:44 PM, Ashish Pradhan > wrote: > > > > > Hi > > > > I have downloaded some tables in excel using Copy/Paste Function (Not > > the "Get External Data" feature). Unfortunately, there are a lot of > > links

$$Excel-Macros$$ Removing Hyperlinks

at a time? Appreciate any help in this and thanks a lot in advance. Thanks -- "I disapprove of what you say, but I will defend to the death your right to say it&q

$$Excel-Macros$$ Re: $$Excel-2003$$

Hi See if this helps http://134.198.33.115/webworks/Excel.05.ppt Ashish On Wed, Mar 25, 2009 at 10:44 AM, lingesh p wrote: > Hi > > I'm looking for a ppt presentation on "introduction to excel 2003". is there > any one who can help me in this regard. if any one have an ppt on this can > mail

$$Excel-Macros$$ Re: Join me on Bebo

Please let us stick to topics on excel in this forum. Thanks Ashish On Mon, Jan 5, 2009 at 4:27 PM, Deepa Bharti wrote: > > > I think you will like it. > > Please accept or reject this invitation by clicking below: > > http://www.bebo.com/in/8409672181a119708434b135 > > ...