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

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

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

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 wrote: > Maybe this will work for you? >

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 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? It’s >

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

$$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 * 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) !

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 @

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

$$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 * Data validation for Stativ range: *https://youtu.be/A8wq_FjaMZE * Thanks & Regards, Prabhu R -- Are you

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

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

; +919953736776 >>>> >>>> On Fri, Sep 2, 2016 at 5:49 PM, Prashant Pednekar <prash...@gmail.com> >>>> wrote: >>>> >>>>> please add me 8308800600 >>>>> >>>>> On Mon, Aug 8, 2016 at 9:43 PM, Rajeev Ranjan <06r

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

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

Application.CutCopyMode = False > Selection.End(xlUp).Select > Range("O4").Select > End Sub > > Also attaching Excel for your reference. > > Regards > Pankaj k Pandey > > > On Tue, Feb 9, 2016 at 11:28 PM, Prabhu Pinky <prabhupin...@gmail.com&g

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,

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.

want that I can look into some. 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

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.

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 id and pwd. there we have many tabs for many reports. am just selecting my required report and

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

(lngLastRow, lngLastCol).FillRight End Sub On Wed, Mar 19, 2014 at 11:21 AM, Prabhu Pinky prabhupin...@gmail.comwrote: any experts here..??? Please help with my query. its very urgent. Thanks Regards, Prabhu R -- Forwarded message -- From: Prabhu Pinky prabhupin...@gmail.com

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.

Hi experts, Please find the attached file. i almost complete my project. But struck up in sumifs part. i used formula in sheet2. but i need to have it in VBA code. i tried it but the cell reference is not changing. whatever the result i get for AAA, same value i get for other agents. most

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

-- *From: * Prabhu Pinky prabhupin...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Mon, 17 Mar 2014 15:48:28 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Very urgent . i need to submit my project

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

:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Prabhu Pinky *Sent:* Tuesday, March 18, 2014 3:14 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Lock only column in vba Experts How to lock only columns in vba...row reference should

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

Re: $$Excel-Macros$$ query2

= Sheets(Sheet2).Range(C65356).End(xlUp).Row Sheets(Sheet2).Range(C j :c j + 3).Value = cl.Value Next End Sub On Sun, Mar 16, 2014 at 12:21 PM, Prabhu Pinky prabhupin...@gmail.comwrote: hi experts, PFA, i have few names in sheet 1, my requirements in sheet 2. please help me with macro

$$Excel-Macros$$ query need help

Hi experts, please find the attached file. my query is. i want to fill dates in sheet2 from sheer1. only weekdays, except sat and sun.. in sheet1 dates will be in vertical, but in sheet2 i want to fill in vertical(except sat and sunday) no alteration should be done in sheet1. please help.

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.

@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ashish koul *Sent:* Saturday, January 25, 2014 12:39 PM *To:* excel-macros *Subject:* Re: $$Excel-Macros$$ Extract data from mail attachment. why you need a macro just for five files On Sat, Jan 25, 2014 at 1:11 AM, Prabhu

$$Excel-Macros$$ copy data from attachment

Hi Experts, i need code to extract data from html file which is attached in mail.Mail i saved it in local folder. on a daily basis i receive many mails. am copying it in local folder. all mails will have html attachment. i need to copy the data from html to excel file. please help with code.

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

, Prabhu Pinky prabhupin...@gmail.comwrote: 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

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.

MsgBox Application.WorksheetFunction.VLookup(4AC, Sheets(2).Range(A:B), 2, 0) On Sun, Nov 24, 2013 at 11:32 AM, Prabhu Pinky prabhupin...@gmail.comwrote: 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

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

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

$$Excel-Macros$$ am getting compile error

Hi experts, Please find below simple codes, while i run the macro am getting compile error. Please help to know what is the mistake i have done with this code. Sub sample() Sheets(sheet2).Range(A10).Value = 1000 Sheets(sheet2).Activate Sheets(sheet2).Range(A10).Select MsgBox Task Completed

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

Hi frog, First of all many thanks for your time to explain with valuable points. Really what you said is really useful for me. Reason behind my post is, all the methods is working with some formula and giving a result even if we use any tools available in markets. I just wants to apply this

$$Excel-Macros$$ Forecasting Methods using Excel

Hi Experts, Please share if you have any file for calls forecasting. Below are some methods in Forecasting which we use in daily basis. 1. Single Exponentioal method 2. Double Exponential Method 3. Winters Additive method 4. Winters Multiplicative method Am working in WFM Team, currently we do

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

Hi Chaya, You no need to cut and paste the each cells. Simply u just copy the data which u need to be in row. then right click-paste special-values (and select transpose). Now you data will be pasted in single row. Note the same method u can use to copy the data in single column if it is in

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

- is there a way to split it up into several rows (for example 5 rows, with 3 columns per row)? On Monday, August 19, 2013 6:21:59 PM UTC-4, Prabhu Pinky wrote: Hi Chaya, You no need to cut and paste the each cells. Simply u just copy the data which u need to be in row. then right click

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

, Prabhu Pinky prabhupin...@gmail.comwrote: 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

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

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

Hi Kausal, This is not possible to hide all sheets in excel. atleast one file should be visible. i hope the rows and colums are hidden. just check u can see the sheet names in that file. if so then just try to unhide the rows and columns. To unhide the rows and columns: in 2007 verson : Goto

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

Hi Sharma, if the file size is big and if u use many formula in your excel then this kind of problem you may face often if you didnt close the file properly. To avoid this kind of issue in future, you can save your file as *.xlsb ( which will save your file as binary format) your file size also

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 but

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

Re: $$Excel-Macros$$ Formula require

Hi Prabhakar, Please find the attached file with solution. Thanks Regards, Prabhu R On 4 June 2013 16:49, Prabhakar S H prabakar.k...@gmail.com wrote: Hi Team, i want to get formula to find Total value of cars with black color only. pls help. Rgds, Prabhakar -- Are you =EXP(E:RT)

Re: $$Excel-Macros$$ Family Tree

to an organisation chart which shown the authority and responsibility flow from the top(MD or Chairman) and to the floor level executives. Regards, VIJAYKUMAR On Fri, May 31, 2013 at 5:01 PM, Prabhu Pinky prabhupin...@gmail.comwrote: can anyone pls tellme how this family tree works.. and what

  1   2   >