$$Excel-Macros$$ Pivot Table and Slicer in Excel

Hi Friends, Feels like worth sharing the video about Pivot Table and Slicer in Excel. *https://youtu.be/jGUEkgtmATw <https://youtu.be/jGUEkgtmATw>* ​ Thanks & Regards, Prabhu R -- 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) ! Joi

$$Excel-Macros$$ Password Remove Read only Excel File

Hi Friends, Feels like work sharing the below video. This will show how to remove password from Read only Excel File. https://youtu.be/RiB-UA1wihE Thanks & Regards, Prabhu R -- 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 offi

$$Excel-Macros$$ Time Variation Calculation and challenges in excel.

Hi Friends, Feels like worth sharing the video on challenges in Time variation calculation in excel. https://youtu.be/7TMo9L3X2rM Thanks & Regards, Prabhu R -- 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$$ Re: Need Help in IF formula

Put the below formula in D1. =IF(A1>B1,"Buy","Sell") Since you have only two checks to be done, no need of nesting loop here. ( i mean if within if). Thanks & Regards, Prabhu R On 17 February 2018 at 06:08, who <david.lanm...@gmail.com> wrote: > Maybe

Re: $$Excel-Macros$$ Macro for Auto delete workbook

can u share sample worksheet Thanks & Regards, Prabhu R On 9 February 2018 at 11:17, Rajesh kumar <sonuraj1...@gmail.com> wrote: > Need macro for auto delete workbook after given expiration date. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be

$$Excel-Macros$$ VBA Macro - Do While Loop

Hi Friends, Feels like worth sharing the knowledge. Do while loop in Excel VBA. https://youtu.be/JIpu6vOe9Vo Thanks & Regards, Prabhu R -- 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 @ h

$$Excel-Macros$$ Pivot Chart using Pivot Table

Hi Friends, I feel worth sharing the knowledge. How to create pivot chart using pivot table data. *https://youtu.be/7nANB80DH50 <https://youtu.be/7nANB80DH50>* Thanks & Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,

Re: $$Excel-Macros$$ concatenate in one cell

If you have those values in A1,B1,C1. Then put formula in D1 as =A1 On 23-Dec-2017 3:09 PM, "Aamir Shahzad" wrote: > Friends, > > I want to concatenate all below data in one cell without any space. > Formula please. > > data > 148351, 183776, 032290, > > result >

$$Excel-Macros$$ Learn VBA Macro

Hi Friends, Feels worth sharing. Learn VBA Macro Part 3 https://youtu.be/gS3S2o0r-8g Thanks & Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook

$$Excel-Macros$$ Goal Seek in Excel

Hi Friends, Feels worth sharing this to you. How to use Goal Seak in Excel https://youtu.be/X-MnANROaiQ Thanks & Regards, Prabhu R -- 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 @ h

$$Excel-Macros$$ Data Validation for Dynamic Range.

Hi Friends, I feel worth sharing this to you. Data validation for dynamic range : *https://youtu.be/sSAMz3kPcMA <https://youtu.be/sSAMz3kPcMA>* Data validation for Stativ range: *https://youtu.be/A8wq_FjaMZE <https://youtu.be/A8wq_FjaMZE>* Thanks & Regards, Prabhu R -- A

$$Excel-Macros$$ Search data using VBA

Hi friends, Useful VBA for ur reference Feels worth to sharing https://youtu.be/3Dbd-AsUIf4 Regards, Prabhu.R -- 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 @

$$Excel-Macros$$ Important Excel VBA Questions with Answers

Hi friends, Sharing with you for your information. Very useful... https://youtu.be/UsmZcTclXWk Regards, Prabhu.R -- 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 @

$$Excel-Macros$$ Vlookup with multiple lookup value

Hi friends, Please find the below video to learn how to use multiple lookup value in single vlookup formula. https://youtu.be/SpmnZmfJSVo Regards Prabhu.R -- 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

$$Excel-Macros$$ Index match function

Hi guys, Please find index match function simply explained in below video. https://youtu.be/QtwRnz8-BP8 Regards, Prabhu.r -- 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$$ RE: Help Req.

Please clarify below: 1. You wants to show all indus id with last two entry Or 2. You want to see last two entry of any one indus id you choose (by drop down option...) Regards, Prabhu.R On 18-Sep-2017 7:16 PM, "Neeraj Gmail" wrote: Dear experts, Kindly find the

$$Excel-Macros$$ VBA Macro - Whatsapp Group

Hi Friends, Since i have created Whatsapp group for VBA Macro learners/experts. And i have added many peoples in this group. Please Msg me to 9500087194 in whatsapp to get added in this group. if anyone missed or not yet added even you requested earlier. Thanks & Regards, Prabhu R -- Are

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

i have created this whatsapp group. Prabhu - 9500087194 Thanks & Regards, Prabhu R On 10 September 2016 at 11:10, Learner Excel <xlst...@gmail.com> wrote: > Who's making this group, please reply? else I can take initiave to do the > same. > > -- > > On Sat, Sep 10

$$Excel-Macros$$ VBA macro - WhatsApp group.

Creating WhatsApp group for VBA macro... Pls msg me your contact, if you wants to join. Add me in WhatsApp and Msg me to - 9500087194 Regards, Prabhu.R -- 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

$$Excel-Macros$$ Copy Formula from different cells and Past in the active column

etween 1 to 22 cells in row. Regards, Prabhu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor threa

Re: $$Excel-Macros$$ Need macro for Vlookup

Hi pankaj, Thanks a ton for the coding... It's working very fine as I expected.. Thanks again. Regards, Prabhu.R On Feb 10, 2016 12:03 AM, "Secret Shot" <secrets...@gmail.com> wrote: > Hay Prabhu, > > You can use this code to do your required task. . follow the ste

Re: $$Excel-Macros$$ Need macro for Vlookup

Hi Pankaj, I just noticed, that in output "Start" and "End" time seems same. Regards, Prabhu.R Thanks & Regards, Prabhu R On 10 February 2016 at 01:26, Prabhu Pinky <prabhupin...@gmail.com> wrote: > Hi pankaj, > > Thanks a ton for the coding... &

Re: $$Excel-Macros$$ Company name based on maximum occurrence

Use vlookup. On 15-Sep-2015 5:31 PM, "Suman" wrote: > Dear All, > If we have list of company id & Name in excel cell then how can I find > maximum occurrence of company name against that company ID. > > Example: > Co ID Name Required Output 1 A A 1 A A 1 A A 1 A A 1 A A 1 A

Re: $$Excel-Macros$$ Forecast template required

the ways you can,In all the places you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - -- *From:* Prabhu Pinky prabhupin...@gmail.com *To:* excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Forecast template required

Experts, any body can help me on this?? On 23-Jul-2015 11:23 PM, Prabhu Pinky prabhupin...@gmail.com wrote: Hi experts.. I have day wise actual offered volume for last 6 months..I need to find the forecast for next 7 days.. Based on previous weeks actual volume.. Anyone please share any

$$Excel-Macros$$ Forecast template required

Hi experts.. I have day wise actual offered volume for last 6 months..I need to find the forecast for next 7 days.. Based on previous weeks actual volume.. Anyone please share any forecast working template for the same.. Need it bit urgent pls. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ freshser exel traning

Hi. Please visit www.w3schools.com Very useful website for beginers. On 21-Apr-2015 1:16 PM, yadramharsana yadramhars...@gmail.com wrote: Dear, all of my freds are the list .I ma a fresher of exel i know the basic of exel but i want to know about mis executive report and full

Re: $$Excel-Macros$$ Macro to copy outlook mail

Experts, Any update on my below query.. On 31-Mar-2015 5:45 PM, Prabhu Pinky prabhupin...@gmail.com wrote: Hi experts, Please share vba code to copy outlook mails subject name, sender name, Date into excel sheet. Code has to copy the above fields from entire mail from the selected folder

$$Excel-Macros$$ Macro to copy outlook mail

Hi experts, Please share vba code to copy outlook mails subject name, sender name, Date into excel sheet. Code has to copy the above fields from entire mail from the selected folder in outlook. Folder selection should be user option. For ex: if i run the code it has to ask the folder from which

$$Excel-Macros$$ Re: Do you want to marry? View Similar Profiles.

Why this kind of mails in this group??? On 30-Mar-2015 1:00 PM, Sajini join.m...@gmail.com wrote: * Do you want to marry? View Similar Profiles. http://www.witness.in/smgroups* http://www.witness.in/smgroups -- You received this message because you are subscribed to the Google Groups

Re: $$Excel-Macros$$ Find Second Highest value from data

Hi amit, You can use the below formula to get 2nd highest number. =large(range,2) Note : range can be continues cells or selected cells like - A1:A5 or A1, A4,A5. On 27-Mar-2015 1:46 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi, Check this one too.. for auto Highlight Second

$$Excel-Macros$$ Unrelated mails in this group.

Hi ayush, It seems nowadays some ppls are posting unrelated mails in this group..for ex: some mail with sub Do you want to marry.. Am receiving atleast 4-5 mails daily... Is it possible to block those mails or warn ppls to stop posting this kind of unwanted mails in this excellent group..

$$Excel-Macros$$ Who is admin for this group?

Hi, anyone please let me know who is the admin for this group. Thanks Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

Re: $$Excel-Macros$$ multiple files to single file

what is the password to view the macro code. Thanks Regards, Prabhu R On 12 March 2015 at 11:43, Mahesh Patil zmpa...@gmail.com wrote: Hi, Collect all excel files under one folder. Use attached file to merge all excel files. Regards, Mahesh Patil On Mar 11, 2015 6:32 PM, myxlg

Re: $$Excel-Macros$$ Need macro help

* - *From:* Prabhu Pinky prabhupin...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, March 5, 2015 10:08 AM *Subject:* $$Excel-Macros$$ Need macro help Hi experts, I have around 10-15 excel file in a folder and updated every week. I need macro in master file which

$$Excel-Macros$$ Need macro help

Hi experts, I have around 10-15 excel file in a folder and updated every week. I need macro in master file which will open each file from folder and copy in master file. Please help me on this. -- 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$$ Need macro to extract data from outlook mail

Hi Vaibhav, Really awesome.. thank you so much. Regards Prabhu Thanks Regards, Prabhu R On 6 January 2015 at 21:37, Vaibhav Joshi v...@vabs.in wrote: Hi Pl check my pervious email in this thread. Cheers!! On Jan 6, 2015 9:10 PM, Prabhu Pinky prabhupin...@gmail.com wrote: Anything

Re: $$Excel-Macros$$ Need macro to extract data from outlook mail

for you.* On Tue, Jan 6, 2015 at 12:33 PM, Prabhu Pinky prabhupin...@gmail.com wrote: Hi xperts, Please help me with vba macro which extracts subject, mail date and mail body from outlook to excel. Its very urgent please help. Prabhu. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

$$Excel-Macros$$ Need macro to extract data from outlook mail

Hi xperts, Please help me with vba macro which extracts subject, mail date and mail body from outlook to excel. Its very urgent please help. Prabhu. -- 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$$ Need suggestion.

. Regards, Abhishek On Wed, Mar 26, 2014 at 3:17 PM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi experts, i need your suggestions on my new project. *Here is my scenario:* in our office, we have a ftp link for one application. on a daily bases i am opening that link and entering my login

Re: $$Excel-Macros$$ Need suggestion.

No abhi...since its official... Am unable to share... On 27-Mar-2014 6:00 PM, Abhishek Jain abhishek@gmail.com wrote: Please provide more info or screenshot of the screen where you have to input the date generating the report. Regards, Abhishek On Thu, Mar 27, 2014 at 5:41 PM, Prabhu

Re: $$Excel-Macros$$ Need suggestion.

Yea sure...please let me know your feasible time to contact. On 27-Mar-2014 11:32 PM, Abhishek Jain abhishek@gmail.com wrote: You may please contact me via chat. Thanks On Thu, Mar 27, 2014 at 10:30 PM, Prabhu Pinky prabhupin...@gmail.comwrote: No abhi...since its official... Am

$$Excel-Macros$$ Need suggestion.

and entering date range and pulling report. is it possible to do this action using vba code?. daily at particular time this macro should automatically run and save the file in particular folder. please help with your suggestions and ideas to complete this project. Thanks Regards, Prabhu R

$$Excel-Macros$$ Need Macro ---- urgent

hi experts, Pls find the attached file. if any cell has refers WTD then it should calculate WTD status. or if any cell has refers MTD then it should calculate sum of WTD and its status. pls help. note : month on month date and WTD/MTD cell will vary. Thanks Regards, Prabhu R -- Are you

Re: $$Excel-Macros$$ Need VBA code for Sumifs function.

great...thanks priti.. but the range you mentioned I3:I54... it could be vary.. its not dynamic. Thanks Regards, Prabhu R On 19 March 2014 13:08, priti verma pritiverma1...@gmail.com wrote: HI, If you want to put formula by vba please try this Sub fillformula() Dim lngLastRow As Long

Re: $$Excel-Macros$$ Need VBA code for Sumifs function.

moreover priti.. its working if C3 is Countsame way i need to calculate for Error. Thanks Regards, Prabhu R On 19 March 2014 14:35, Prabhu Pinky prabhupin...@gmail.com wrote: great...thanks priti.. but the range you mentioned I3:I54... it could be vary.. its not dynamic. Thanks

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

nice, thanks ravinder Thanks Regards, Prabhu R On 18 March 2014 11:16, Ravinder ravindervbacli...@gmail.com wrote: pfa *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Prabhu Pinky *Sent:* Sunday, March 16, 2014 8:02 AM *To:* excel-macros

$$Excel-Macros$$ Need VBA code for Sumifs function.

importantly i need only values should past here in sheet. due to file size problem. if formulas are pasted here then i am unable to open the file. it takes too long. Thanks Regards, Prabhu R -- 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

Fwd: $$Excel-Macros$$ Need VBA code for Sumifs function.

any experts here..??? Please help with my query. its very urgent. Thanks Regards, Prabhu R -- Forwarded message -- From: Prabhu Pinky prabhupin...@gmail.com Date: 19 March 2014 10:41 Subject: $$Excel-Macros$$ Need VBA code for Sumifs function. To: excel-macros

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

Guys...pls help with my query On 17-Mar-2014 9:22 AM, Prabhu Pinky prabhupin...@gmail.com wrote: Hi Experts, Please find the attached file. there i used many SUMPRODUCT formula. it slow down my excel. please help with macro or any simplified formula. *am doing this on a daily basis

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

Am using excel 2007. On 17-Mar-2014 12:24 PM, ashish koul koul.ash...@gmail.com wrote: which version of excel r u using On Mon, Mar 17, 2014 at 12:22 PM, Prabhu Pinky prabhupin...@gmail.comwrote: Guys...pls help with my query On 17-Mar-2014 9:22 AM, Prabhu Pinky prabhupin...@gmail.com

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

can you workout and send me..i did tried.. but am not getting result. if you provide VBA code.. it would be so great. Thanks Regards, Prabhu R On 17 March 2014 15:51, koul.ash...@gmail.com wrote: Y don't u use sumifs or countifs Sent on my BlackBerry(R) from Vodafone

$$Excel-Macros$$ Lock only column in vba

Experts How to lock only columns in vba...row reference should be change... I want to lock only column range -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Lock only column in vba

the same value gives for BBB and so on, But if run the macro it should change as B6 for the agent BBB. B9 for CCC agents. the cell reference is not properly working in my macro. please help me on this. am struggling to proceed further.[?] [image: Inline images 1] Thanks Regards, Prabhu R

$$Excel-Macros$$ query2

hi experts, PFA, i have few names in sheet 1, my requirements in sheet 2. please help me with macro coding. Thanks Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ query2

thanks asish, but in second sheet, names should start from 3rd row only. i mean from B3 onwards only. Thanks Regards, Prabhu R On 16 March 2014 12:50, ashish koul koul.ash...@gmail.com wrote: Sub test() Dim cl As Range Dim j As Long For Each cl In Sheets(Sheet1).Range(b3:b7) j

$$Excel-Macros$$ query need help

. Thanks Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please

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

sorry, in sheet 1 dates will be in vertical, but in sheet 2 i want to fill in horizontal. Thanks Regards, Prabhu R On 16 March 2014 08:02, Prabhu Pinky prabhupin...@gmail.com wrote: Hi experts, please find the attached file. my query is. i want to fill dates in sheet2 from sheer1

Re: $$Excel-Macros$$ copy data from attachment

hi experts, anyone working on my request. its bit urgent. i need your assistance please. Thanks Regards, Prabhu R On 26 January 2014 10:51, Prabhu Pinky prabhupin...@gmail.com wrote: Hi Experts, i need code to extract data from html file which is attached in mail.Mail i saved

Re: $$Excel-Macros$$ Extract data from mail attachment.

to check mails one by one and copy data from html attachment and the same needs to be saved in excel file. Thanks Regards, Prabhu R On 25 January 2014 16:01, Ravinder ravinderexcelgr...@gmail.com wrote: Could you pls provide an example mail with HTML attachment. *From:* excel-macros

$$Excel-Macros$$ copy data from attachment

. its very urgent. thanks in advance Thanks Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles

$$Excel-Macros$$ Extract data from mail attachment.

Hi experts, I have 5 outlook mails saved in local folder, which has html attachment.. How to copy data from those html attachment from each mail in excel sheet. Please help with immediate. -- 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

Re: $$Excel-Macros$$ vlookup help.

Hi Ashish, I have attached the sample sheets. assume Master sheet is saved in D folder. and Consolidated sheet is saved in E folder Thanks Regards, Prabhu R On 24 November 2013 13:07, ashish koul koul.ash...@gmail.com wrote: share some sample workbooks On Sun, Nov 24, 2013 at 1:06 PM

Re: $$Excel-Macros$$ VBA basic concept

Hi Dharm, You can refer the belwo website to learn VBA basic. its so simple and understandable. http://www.excel-pratique.com Thanks Regards, Prabhu R On 24 November 2013 10:12, Dharm Pd dhar...@gmail.com wrote: Dear All, I work in Excel from last 8 years and understand almost all

$$Excel-Macros$$ vlookup help.

Hi Experts, How to do vlookup in VBA. i have two sheets saved in different locations. i need to do vlookup in sheet1 by referring another sheet saved in different location. please help. Thanks Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ vlookup help.

saved in different workbook and in different location. can you help with any example sheets. Thanks Regards, Prabhu R On 24 November 2013 12:35, ashish koul koul.ash...@gmail.com wrote: saved in different workbook or in same workbook you can use application.worksheetfunction.vlookup

Re: $$Excel-Macros$$ data cleansing

You can use =trim() formula to remove the blanks in end of the word or starting of the word. On 30-Oct-2013 4:37 AM, Pehrson, Dave dpehr...@walbro.com wrote: I have a situation where I down load data and delineate results leaving a name with blanks behind the number making a Vlookup

$$Excel-Macros$$ Send Excel sheet thur mail.

will be as attachment and Sheet summary need to pasted in the body of the mail. Kindly do the needful. Prabhu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

$$Excel-Macros$$ Capacity planning template required

Experts, If anyone have capacity planning template,please share to me. Thanks Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

$$Excel-Macros$$ how to unhide multiple sheets at once in excel 2007

Hi Experts, Is there any way to unhide multiple worksheets at once in excel 2007. Please share your inputs. Thanks Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https

$$Excel-Macros$$ Need help in forecast

Hi Experts, i have historical pattern of last few month daywise daily offered. is there possible to calculate the next month overall volume by using excel. if anyone have this kind of template please share. Thanks Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

$$Excel-Macros$$ Need Formula

Hi Experts, Please find the attached file, please revert with appropriate formula for my requirement Thanks Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https

$$Excel-Macros$$ am getting compile error

if msgbox(Do you want to Clear the data ?,vbYesNo,Confirm)= vbYes then Range(A:A).ClearContents MsgBox Data has been cleared Else MsgBox Data has not been cleared End If End Sub Thanks Regards, Prabhu R -- 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$$ Re: PDF to txt by vba code

Hi Basole, i copied one file into the folder and tried converting. i received the success msg. but i dont find the file in that folder. will it saved in same folder or any other folder..? Thanks Regards, Prabhu R On 4 September 2013 00:07, Basole ricardo...@gmail.com wrote: Hi, I adapted

Re: $$Excel-Macros$$ Re: Forecasting Methods using Excel

this formula in excel. Is it possible..? On 26-Aug-2013 7:16 PM, The Frog mr.frog.to@googlemail.com wrote: Hello Prabhu, I dont comment on this forum much as I generally dont have the time. I saw your topic and thought it worth a response because it it quite a tricky one to get right

$$Excel-Macros$$ Forecasting Methods using Excel

forecast using Smart forecast tool. But i want to do it manually by using excel. Thanks Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

if it is in single row. Thanks Regards, Prabhu R On 20 August 2013 02:55, Chaya Cooper chayacoo...@gmail.com wrote: I often have to move cells in order to have them in a row (going across) instead of in a column (going down). Is there a way to simplify this so that I don't have to manually cut paste

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

you mean same data in each row..?.. or can you share me your file with requirement..? like below.. [image: Inline images 1] Thanks Regards, Prabhu R On 20 August 2013 04:02, Chaya Cooper chayacoo...@gmail.com wrote: That's amazing :-D I'm sorry I waited this long to ask ;-) One question

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

hi chaya, hope if u share the file.. it will be so fine to work. Thanks Regards, Prabhu R On 20 August 2013 04:35, Chaya Cooper chayacoo...@gmail.com wrote: Unfortunately, the data in each row is different I've attached an image with an example :-) On Mon, Aug 19, 2013 at 6:36 PM

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

Am just asking you to share the excel file. On 20-Aug-2013 5:50 AM, Chaya Cooper chayacoo...@gmail.com wrote: I'm sorry, I'm not sure I understand what you're saying :-( On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote: hi chaya, hope if u share the file.. it will be so fine

Re: $$Excel-Macros$$ Screen Updating

Hi Hilary, can u share the file..? Thanks Regards, Prabhu R On 13 August 2013 21:51, Hilary Lomotey resp...@gmail.com wrote: Hello Experts, i have a sheet am working in, when i press enter in the sheet, the screen sort of updates and flickers, how do i stop this. it is not VBA that i

$$Excel-Macros$$ how to clear all values and properties in a sheet

hi experts, pls gimme the macro for clear all the contents, values, properties in a excel sheet. (for ex: sheet1 entire cells) Thanks Regards, Prabhu R -- 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$$ how to clear all values and properties in a sheet

wow great.. thanks ashish.. Thanks Regards, Prabhu R On 11 August 2013 11:23, ashish koul koul.ash...@gmail.com wrote: Sub tes() Sheets(1).UsedRange.Clear End Sub On Sun, Aug 11, 2013 at 11:16 AM, Prabhu Pinky prabhupin...@gmail.comwrote: hi experts, pls gimme the macro for clear

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

Sumif - used to sum the range by checking single condition. Sumifs - used to sum the range by checking multiple conditions. Countif - used to count the range by checking single condiyion. Countifs - used to count the range by checking multiple conditions. On Jul 29, 2013 8:28 PM, Ashish Kumar

$$Excel-Macros$$ Hours difference formula

Hi experts, Pls help with formula to find difference between two hours. Below are the examples. 1. Diff between : 08:00 15:00 2. Diff between : 10:00 21:00 3. Diff between : 22:00 07:00 4. Diff between : 00:00 09:00 5. Diff between : 23:00 08:00 I need single formula to obtain the result. --

Re: $$Excel-Macros$$ Re: Hours difference formula

Hi.. Am getting 0:00 as result for all examples... On Jul 26, 2013 10:15 PM, Basole ricardo...@gmail.com wrote: Use =HOUR(B1-A1) Em sexta-feira, 26 de julho de 2013 13h30min08s UTC-3, Prabhu Pinky escreveu: Hi experts, Pls help with formula to find difference between two hours. Below

Re: $$Excel-Macros$$ Hours difference formula

time from lower time. Thanks On Fri, Jul 26, 2013 at 10:00 PM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi experts, Pls help with formula to find difference between two hours. Below are the examples. 1. Diff between : 08:00 15:00 2. Diff between : 10:00 21:00 3. Diff between : 22:00 07

Re: $$Excel-Macros$$ Re: Hours difference formula

Hi pls find the examples 1. Diff between : 08:00 15:00 2. Diff between : 10:00 21:00 3. Diff between : 22:00 07:00 4. Diff between : 00:00 09:00 5. Diff between : 23:00 08:00 On Jul 26, 2013 11:31 PM, Ricardo® ricardo...@gmail.com wrote: Hi, you can post example? 2013/7/26 Prabhu Pinky

Re: $$Excel-Macros$$ Re: Hours difference formula

13h30min08s UTC-3, Prabhu Pinky escreveu: Hi experts, Pls help with formula to find difference between two hours. Below are the examples. 1. Diff between : 08:00 15:00 2. Diff between : 10:00 21:00 3. Diff between : 22:00 07:00 4. Diff between : 00:00 09:00 5. Diff between : 23:00 08:00 I

Re: $$Excel-Macros$$ urgent help

Hi nayak..pls share the file.. On Jul 23, 2013 12:02 PM, devanand nayak devnayak_...@hotmail.com wrote: hi i have one sheet which consists of data on daily basis for whole year e.g. datecustomer name tin no net 12.5% vat 12.5% net 5% vat 5% oms tranpsort total i need

$$Excel-Macros$$ Need MP file templates

Hi experts pls help me with manpower planning file templates. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Need Ramp up Plan Template.

Thanks a lot Vijay. Thanks Regards, Prabhu R On 20 July 2013 13:34, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Repected Prabhu, Please find the attached templates. Regards, Vijaykumar On Sat, Jul 20, 2013 at 8:06 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi Experts

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

hi priti, very nice formula.. very useful. thank you. Thanks Regards, Prabhu R On 16 July 2013 14:57, priti verma pritiverma1...@gmail.com wrote: PFA On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E emuralidha...@gmail.comwrote: Dear Friends good afternoon, I need help reg. lookup

$$Excel-Macros$$ Need Ramp up Plan Template.

Hi Experts, if anyone have template for Ramp Up plan which is used for staffing forecast. pls share. if possible i need explanation for the terms which is used in that file. Thanks Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT

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

Home tab-- Cells option -- Format -- change the column with from 0 to any value.. now ur sheet will be visible. Thanks Regards, Prabhu R On 17 July 2013 18:00, Kaushal Kumar kaushal.anal...@live.com wrote: Apologies, I can not share that file Rgds, Kaushal -Original Message- From

Re: $$Excel-Macros$$ I want to merge two text cell

Hi Dhaval Pls find attached file with solution. Thanks Regards, Prabhu R *From:* Dhaval Shah todhavals...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wednesday, 6 March 2013 5:21 PM *Subject:* $$Excel-Macros$$ I want to merge two text cell dear friends i want to merge two

Re: $$Excel-Macros$$ Unable to Open Excel File... How to repair it..

will be small and you can easily handle the file even if there is many formula in it. Thanks Regards, Prabhu R On 1 July 2013 11:27, B Sharma sharma@gmail.com wrote: Dear Friends and excel experts,,, I am facing this problem 3-4 time and now I want a remedy / solution

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

hi pravin, am also using the same version of MS Word. But its working fine even if i press enter. better you can re install the MS. it may work. Thanks Regards, Prabhu R On 22 June 2013 13:23, Pravin Gunjal isk1...@gmail.com wrote: Dear Mr Vijay, Thanks for it. I tried the same

Re: $$Excel-Macros$$ Horizontal to Vertical in One colume

hi priti..this is really nice work...if you dont mind..can you gimme training in macro..pls..i can follow your classes as you teach me... On Jun 21, 2013 11:48 AM, priti verma pritiverma1...@gmail.com wrote: Yes you can do it with macro, See pfa On Fri, Jun 21, 2013 at 11:29 AM, Prafull

Re: $$Excel-Macros$$ Help to create transport Cab roster

Hi asish..i can give inputs for you. Gimme some till will prepare a document and share to you..hope it may help you... On Jun 14, 2013 10:57 AM, Ashish Kumar kumar.ashish...@gmail.com wrote: Dear Seniors, How to create a transport Cab roster. If, any one have an these type of roster data or

  1   2   >