Re: $$Excel-Macros$$ Help req - sumif sumifs or countif countifs

Hi Ashish, Just go through this link... you have good examples... http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/ Thanks, Raj On Mon, Jul 29, 2013 at 8:41 PM, Prabhu Pinky prabhupin...@gmail.comwrote: Sumif - used to sum the range by checking single condition. Sumifs -

Re: $$Excel-Macros$$ autofilter issue

Rekha, Just try this code instead of or change it to And With ThisWorkbook.Worksheets(Bex File) Set rng = .Range(A1).CurrentRegion rng.AutoFilter 15, *Chief Technology Office*, xlAnd, *Desktop Platform* rng.AutoFilter Field:=25, Criteria1:==*AF*

Re: $$Excel-Macros$$ Advance filter issue

hi Experts, Need your help , as i could not club both sheets in new workbook. Thanks, Raj On Sun, Apr 14, 2013 at 12:02 PM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Hi friends, Please assist with Advance filter issue, i have created a macro which will be taking unique

Re: $$Excel-Macros$$ Happy b'day Noorain Ansari

Happy birthday Noor have a delightful nd colourful moments a head. On Jan 2, 2013 12:25 AM, Umesh Soni soniume...@gmail.com wrote: Happy birthday Noorain.. May All u r wishes comes true have a great Year Ahead. Regards, Umesh Soni On Tue, Jan 1, 2013 at 7:43 PM,

Re: $$Excel-Macros$$ discussexcel formula quiz 1

done On Sat, Nov 10, 2012 at 12:47 PM, vijayajith VA vijayajith...@gmail.comwrote: done On Sat, Nov 10, 2012 at 12:43 PM, Pravin Gunjal isk1...@gmail.com wrote: Done. On Sat, Nov 10, 2012 at 11:40 AM, Ayush Jain jainayus...@gmail.comwrote: Dear group, I have created a small formula

$$Excel-Macros$$ Accoount payable excel templates

Hi friends, Please share the excel template of accounts payable if any one of u is having. basically i am planning to build up a template on accounts payable data in excel for forecasting and analysis. and need your experts advise. Please do share if any of you are having such stuff. Thanks in

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012

Congrats rajan for your threshold efforts.. On Wed, Oct 3, 2012 at 2:19 AM, Asa Rossoff a...@lovetour.info wrote: I'm happy to see you recognized and honored for your continued great contribution Rajan. Asa ** ** *From:* excel-macros@googlegroups.com [mailto:

Re: $$Excel-Macros$$ Marquee text in Powerpoint

Ashish, any idea in this regards as already you have created in excel. Thanks for your help in advance!! On Sat, Aug 4, 2012 at 3:46 AM, David Grugeon da...@grugeon.com.au wrote: You might do better asking PowerPoint questions on a Powerpoint forum. As its name indicates this forum

$$Excel-Macros$$

hi experts, Need your expert advise. please provide a vba code which copiesText frame box copied from excel and then pastes it to ppt slide in bottom. -- -- Thanks Regards, Rajasekhar.P -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ Need if formula

thanks one and all for your help.. On Wed, Mar 7, 2012 at 7:14 PM, dguillett1 dguille...@gmail.com wrote: You didn’t show us your situation but, depending on your need you could use LOOKUP, vLookup Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com

Re: $$Excel-Macros$$ Need if formula

i just used this formula however how can i add iserror formula to this.. On Thu, Mar 8, 2012 at 12:29 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: thanks one and all for your help.. On Wed, Mar 7, 2012 at 7:14 PM, dguillett1 dguille...@gmail.com wrote: You

$$Excel-Macros$$ Need help

Good evening experts, Please assist me in this concern i am looking for a excel macro which can give details of folders and their respective size. for example i have Main folder with name Excel with in the folder i have many other sub folders, so i am looking for a macro which can list the

Re: $$Excel-Macros$$ Need help

the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Rajasekhar Praharaju rajasekhar.prahar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Fri, October 14, 2011 11

Re: $$Excel-Macros$$ Need help

:* Rajasekhar Praharaju rajasekhar.prahar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Fri, October 14, 2011 11:31:34 AM *Subject:* Re: $$Excel-Macros$$ Need help hi Paul, i am getting bug here, ub List_Folder_Size() Dim fso, fldr, sfldr, FolderName Dim Sht, R

Re: $$Excel-Macros$$ Speech Recognition software for excel

Thanks for sharing this mahesh and rajan On Wed, Aug 31, 2011 at 11:36 PM, rajan verma rajanverma1...@gmail.comwrote: Hi, I just use this Sub speak() Application.Speech.speak Hellow EveryOne, Look I M speaking End Sub On Wed, Aug 31, 2011 at 11:05 PM, Mahesh parab mahes...@gmail.com

Re: $$Excel-Macros$$ to find particular column and insert one column and perform Vlookup using vba

Thanks a ton to one all really helped me alot in this concern. On Mon, Jul 18, 2011 at 11:30 PM, Mahesh parab mahes...@gmail.com wrote: Hi For Vlookup you can use static Name range which is predetermined RANGE =SBUMapping!$A$1:$D$789 OR dynamic Name range range which resize dynamically

$$Excel-Macros$$ Fwd: FW: Leave planner tracker1.xlsx

hi, I will be preparing the leaveplanner tracker report frequently . i will colour the specific day when i am absent on particular day.finallyon the end of the month i will count the different colours and place the number. Please provide the formula or vba macro to perform this activity.

Re: $$Excel-Macros$$ Nos. of Sundays between two days

, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: hi ashish, Can you please help to find out how many mondays and saturdays are present for the same above query. 01/16/2011 to 02/16/20111 Thanks, Raj On Tue, Feb 15, 2011 at 12:46 PM, N Pradhan nalini.pradha

Re: $$Excel-Macros$$ Nos. of Sundays between two days

hi ashish, Can you please help to find out how many mondays and saturdays are present for the same above query. 01/16/2011 to 02/16/20111 Thanks, Raj On Tue, Feb 15, 2011 at 12:46 PM, N Pradhan nalini.pradha...@gmail.comwrote: Thank you very much for the prompt reply Sir. -

Re: $$Excel-Macros$$ data in horizontal row

hi please use this simple procedure Excel Text to Column Command The Text to Column command allows you to break text in one column into several columns. For example, if you have LastName, FirstName in a column, you can break the text into two columns—one containing LastName and the other

$$Excel-Macros$$ ashish koul koul.ash...@gmail.com,

Hi, I have an excel sheet and I want to filter for BLANKS in multiple columns and provide comment of the other column. Can some one help me writing a macro/add-on? expand » Here each time the columns will not be the same, so it would be good if the macro asks for the range and perform the

$$Excel-Macros$$ Fwd: Excel 2003 vs 2007

Hi Friends, I just wanted to share this differences between Excel 2003 and 2007. Number of Rows and Columns One of the main developments in Excel 2007 is that it allows more columns and rows. For many users this may not be an issue - after all, the 65,536 rows and 256 columns provided by

$$Excel-Macros$$ Fwd: need help

Hi , In this sheet i am trying to place vlookup for multiple fields yaar it should through the description and date in AG column basing on list of activities. but i should get this in horizontal basis.. can anyone plz help me in this concern. for example if one activity is performed twice

Fwd: $$Excel-Macros$$ Fwd: need help

Hi , Please help me in this concern, In this sheet i am trying to place vlookup for multiple fields yaar it should through the description and date in AG column basing on list of activities. but i should get this in horizontal basis.. can anyone plz help me in this concern. for example if

Re: $$Excel-Macros$$ Fwd: need help

:49 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Hi , Please help me in this concern, In this sheet i am trying to place vlookup for multiple fields yaar it should through the description and date in AG column basing on list of activities. but i should get

Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey

Congratts dilip On Tue, Jan 4, 2011 at 12:34 AM, Vinod N nvino...@gmail.com wrote: Congratulations!! Dilipji... On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am very very very very happy to share a good news with you. One

Re: $$Excel-Macros$$ Top poster of the Month- Dec'10 : Ashish Koul

Congratulations Ashish, we wish you flamboyant future. On Sat, Jan 1, 2011 at 4:40 PM, ashish koul koul.ash...@gmail.com wrote: welcome ayush, happy new year to you and everyone in the group... On Sat, Jan 1, 2011 at 1:37 PM, Ayush jainayus...@gmail.com wrote: Dear Group,

Re: $$Excel-Macros$$ How to extract characters from right

hi Kalyan, Use substitute function. Please find the attached solution hope it helps you. Thanks, Raj On Fri, Nov 26, 2010 at 10:55 AM, Kal xcel kalx...@gmail.com wrote: Dear Experts, I am facing a problem to extract characters from right of string. Please help. Thanks in advance.

Re: $$Excel-Macros$$ Vlookup

Hi Muralidhar, did u check the attached pivot solution let me know if it is not apt then i will do v-lookup fucntion as u sent. Thanks, Raj On Thu, Nov 11, 2010 at 12:49 PM, muralidhar e emuralidha...@gmail.comwrote: Dear all, This is urgent to me, plz suggest solution as early as possible.

Re: $$Excel-Macros$$ Vlookup

Hello Muralidhar, Instead of Vlookup you can use Pivot table it depicts good results. Please find Attached is the solved sheet.. Let me know if you are looking for the same or anything else. Thanks, Raj On Thu, Nov 11, 2010 at 11:02 AM, muralidhar e emuralidha...@gmail.comwrote: Dear all

Re: $$Excel-Macros$$ Help Required

hello rakesh, Only for this attached sheet do you have query or Prior chain mails as well, then i think u can just use this formula for the attached sheet replacing date =A2+30 By adding 30days u are getting the answer...Please let me know if this resolves your query or not. Thanks,

$$Excel-Macros$$ Conditional Formatting

Conditional Formatting You can use something called Conditional Formatting in your spreadsheets. Conditional Formatting allows you to change the appearance of a cell, depending on certain conditions. What we'll do is to colour the Overall Averages on our Student Exam spreadsheet, depending on

Re: $$Excel-Macros$$ Help: Using SUMIF(S) Function

hi, Check this website hope you will find the resolution http://www.homeandlearn.co.uk/excel2007/excel2007s6p4.html Thanks, Raj On Tue, Nov 9, 2010 at 11:19 PM, janet dickson janetdicks...@gmail.comwrote: Hello Excel Gurus, I encountered a challenge on using SUMIF FUNCTION. Help

Re: $$Excel-Macros$$ Please help

that much time. :( Best Regards, DILIPandey On Tue, Oct 12, 2010 at 6:13 PM, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: -- Forwarded message -- From: rajasekhar praharaju rajasekhar.prahar...@gmail.com Date: Tue, Oct 12, 2010 at 5:49 PM Subject: Re

Re: $$Excel-Macros$$ Please help

you can assign the tasks to different individuals. Please explain further if you need some other solution. Best Regards, DILIPandey On 10/9/10, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: could you please assist me in this concern .please actually if any batch is pending

Re: $$Excel-Macros$$ Please help

Sumif Formulas. Regards Sumit Vyas On Thu, Oct 7, 2010 at 10:25 PM, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: hi Excel Guru, Please assist me in this concern . Attached are two sheets Task distribution orginal and other sheet with task distribution My daily

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

hello friend, Go to top left hand corner of excel click on office button-- excel options--- then select the add ins by double clicking on it. then click on manage option --- go Thanks, Raj On Thu, Oct 7, 2010 at 10:55 PM, SAJID MEMON sajidwi...@hotmail.com wrote: Hi Experts, I want to

Re: $$Excel-Macros$$ Hi Experts, Urgent

hi Pankaj, Can you please tell what formula you are looking for. Could you please express your query in brief. Thanks, Raj On Tue, Oct 5, 2010 at 8:23 PM, Pankaj Kumar rajputpanka...@gmail.comwrote: Hi, Experts Its urgent basis i need u r help, i have a Name list A-Z, I have

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

hearty congratulations ayush, you really deserve it Infact you are good encyclopedia for us. Have a flamboyant future and delightful moments for ur future endeavors. Regards, Raj On Sun, Oct 3, 2010 at 3:47 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am proud to

$$Excel-Macros$$ Need Help

Hi friends, Dear Adorable group... please share if any one of us are having excel addin's . Moreover i am having query regarding the excel addin's. Can any one suggest how to create the excel addins i just tried creating this addins . but could not use properly. Thanks for your help in

Re: $$Excel-Macros$$ help needed

Hi Santosh, Send Your sample excel work book attachment for review. i can help you in this concern, i recently got good solution in regards to this concern. my id is rajasekhar.prahar...@gmail.com copy even the group as well. Thanks Regards, Raj On Sun, Sep 12, 2010 at 6:50 PM, santosh

$$Excel-Macros$$ help needed

Hi Santosh, Send Your sample excel work book attachment for review. i can help you in this concern, i recently got good solution in regards to this concern. my id is rajasekhar.prahar...@gmail.com copy even the group as well. Thanks Regards, Raj On Sun, Sep 12, 2010 at 6:50 PM, santosh

$$Excel-Macros$$ Re: pivot data

, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group

Re: $$Excel-Macros$$ I have a problem for following worksheet

hello, Pankaj attached is the solution for your query, the formula u depicted or used in that cell is accurate where as all you need to do is to give a space as shown below 9:00 AM Give space like this for both intime and out time then as per attached sheet u will have error free result.

$$Excel-Macros$$ Need help in consolidating different excel workbooks in to one work book

Hi All, Please assist in this concern i wanted to prepare excel macro where in i can consolidate different excel workbooks data into one excel workbook. so please send me if it is possible through vba macros.if any one of the group is having the script or macro for performing this activity

$$Excel-Macros$$ Need advise

Hi All, Myself rajasekher just require your valuable suggestion in this concern, please advise the excel formular where in i can use and the words for the value specified in excel. for example if the value in excel is 80 (numerical) ... i need this 80(numerical) towords as

Re: $$Excel-Macros$$ Excel 2007 Power Programming with VBA by John Walkenbach.

On Fri, Mar 26, 2010 at 1:26 PM, amitabhbo...@hotmail.com wrote: Hi I have this book but will have to find the cd. I will try and send it this weekend Thanks Amitabh -- -Original Message- From: anandydr anand...@gmail.com Date: Thu, 25 Mar 2010 21:19:13 To:

Re: $$Excel-Macros$$ Excel 2007 Power Programming with VBA by John Walkenbach.

hi friends, i do have certain vba books will send you shortly. Regards, Raj On Fri, Mar 26, 2010 at 2:37 PM, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: On Fri, Mar 26, 2010 at 1:26 PM, amitabhbo...@hotmail.com wrote: Hi I have this book but will have to find the cd. I

$$Excel-Macros$$ Re: How to convert the first letter of every cell in a colum to caps (upper case) and rest to lower case

hi all please advise the how to find the row or coloum coloured cell . using excell formula i need to find the cell which is in colour. cell colour should be known . please help me out in this concern Thanks in advance. Raj 9966353510 On 6/26/09, Saravanan Anna sarvananar...@gmail.com wrote: