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

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? > =IF

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 > =TIME(2,DO:IT,N:

$$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&B1&C1. 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 > 148351,183776,032290 > >

$$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 @ https://www.facebook.com/discus

$$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 @ https://www.facebook.com/discussexc

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

$$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 @ https://www.facebook.com/di

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 sheet I want to put last two

$$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 wrote: > Who's making this group, please reply? else I can take initiave to do the > same. > > -- > > On Sat, Sep 10, 2016 at 11:07

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

een 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, 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 wrote: > Hi pankaj, > > Thanks a ton for the coding... > > It's working very fi

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" wrote: > Hay Prabhu, > > You can use this code to do your required task. . follow the steps > > Go to visua

$$Excel-Macros$$ ***Object -defined error rectification ***

Else d(r, c) = "=" & d(r, c) & "/" & ColA(r, 1) End If Next Next Dest.Resize(UBound(d, 1), UBound(d, 2)).Value2 = d End If End If End Sub Regards, Prabhu -- Are you =EX

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 A 1 B A 1 B A > 1 B A

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

> > > > > > > > *“Do all the good you can,By all the means you can,In all 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* > -

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

Experts, any body can help me on this?? On 23-Jul-2015 11:23 PM, "Prabhu Pinky" 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 shar

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

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" 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 > knowledge of ms exc

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

Experts, Any update on my below query.. On 31-Mar-2015 5:45 PM, "Prabhu Pinky" 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

$$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" wrote: > * Do you want to marry? View Similar Profiles. > * > > > > -- > You received this message because you are subscribed to the Google Groups > "Importan

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" wrote: > Hi, > > Check this one too.. for auto Highlight Second Highest Value. > > > >

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

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

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

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

imes you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Prabhu Pinky > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, March 5, 2015 10:08 AM > *Subject:* $$Excel-Macros$$ Need macro help > > Hi experts, > I have

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

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 wrote: > Hi > > Pl check my pervious email in this thread. > > Cheers!! > On Jan 6, 2015 9:10 PM, "Prabhu Pinky" wrote: >

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

is here working through me for you.* > > On Tue, Jan 6, 2015 at 12:33 PM, Prabhu Pinky > 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. >

$$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 a help in Pivot

Once you done the pivot...you can unselect the OFF from list...so that you will get the count excluding OFF... On 29-Jun-2014 12:18 PM, "Ganesh N" wrote: > Hi, > > Thank. But there is any way to get the details without changing the > structural ? > > Because the initial one is the format which us

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" wrote: > You may please contact me via chat. > > Thanks > > > On Thu, Mar 27, 2014 at 10:30 PM, Prabhu Pinky wrote: > >> No abhi...since its official... Am u

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

No abhi...since its official... Am unable to share... On 27-Mar-2014 6:00 PM, "Abhishek Jain" 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, 2

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

into some. > > Regards, > > Abhishek > > > On Wed, Mar 26, 2014 at 3:17 PM, Prabhu Pinky wrote: > >> Hi experts, >> >> i need your suggestions on my new project. >> >> >> *Here is my scenario:* >> >> in our office, we have a ftp link fo

$$Excel-Macros$$ Need suggestion.

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

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 wrote: > great...thanks priti.. > > > but the range you mentioned I3:I54... it could be vary.. its not dynamic. > &

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 wrote: > HI, > If you want to put formula by vba please try this > > Sub fillformula() > Dim lngLastRow As Lo

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 Date: 19 March 2014 10:41 Subject: $$Excel-Macros$$ Need VBA code for Sumifs function. To: "excel-macros@googlegroups.com"

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

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

nice, thanks ravinder Thanks & Regards, Prabhu R On 18 March 2014 11:16, Ravinder 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:* e

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

ell refers the agent AAA, when i run the macro 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: Inlin

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

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, wrote: > Y don't u use sumifs or countifs > Sent on my BlackBerry(R

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" wrote: > which version of excel r u using > > > On Mon, Mar 17, 2014 at 12:22 PM, Prabhu Pinky wrote: > >> Guys...pls help with my query.... >> On 17-Mar-2014 9:22 AM, "Prabhu Pinky" wr

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" 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 d

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 wrote: > > Sub test() > Dim cl As Range > Dim j As Long > For Each cl In Sheets("Sheet1").Range(

$$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$$ 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 wrote: > Hi experts, > > please find the attached file. my query is. > > i want to fill dates in sheet2 from sh

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

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 wrote: > Hi Experts, > > > i need code to extract data from html file which is attached in mail.Mail > i saved

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

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

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 wrote: > Could you pls provide an example mail with HTML attachment. > > > > *From:* excel-macros@googl

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

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 wrote: > share some sample workbooks > > > On Sun, Nov 24, 2013 at 1:06 PM, Pr

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 wrote: > saved in different workbook or in same workbook > > you can use application.worksheetfunction.vlook

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

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 wrote: > > > Dear All, > > I work in Excel from last 8 years and understand alm

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" wrote: > I have a situation where I down load data and delineate results leaving > a name with blanks behind the number making a Vlookup difficult. > > ** ** >

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

bit" 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

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

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

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

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

$$Excel-Macros$$ am getting compile error

").Range("A10").Select MsgBox "Task Completed" 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

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

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

formula in excel. Is it possible..? On 26-Aug-2013 7:16 PM, "The Frog" 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 (there are

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

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

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 wrote: > Unfortunately, the data in each row is different > > I've attached an image with an example :-) > > > On Mon, Aug 19, 20

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 wrote: > That's amazing :-D I'm sorry I waited this long to ask ;-) > > One qu

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

is in single row. Thanks & Regards, Prabhu R On 20 August 2013 02:55, Chaya Cooper 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 man

Re: $$Excel-Macros$$ Screen Updating

Hi Hilary, can u share the file..? Thanks & Regards, Prabhu R On 13 August 2013 21:51, Hilary Lomotey 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

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 wrote: > Sub tes() > Sheets(1).UsedRange.Clear > End Sub > > > > On Sun, Aug 11, 2013 at 11:16 AM, Prabhu Pinky wrote: > >> hi experts, >> >> pls gimm

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

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" w

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

ta-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 are the >> examples. >> 1. Diff between : 08:00 &15:00 >> 2. Diff between : 10:00 &am

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®" wrote: > Hi, you can post example? > &

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

ing higher time from lower > time. > > Thanks > > > On Fri, Jul 26, 2013 at 10:00 PM, Prabhu Pinky wrote: > >> Hi experts, >> >> Pls help with formula to find difference between two hours. Below are the >> examples. >> 1. Diff between : 08:00 &am

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

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

Hi nayak..pls share the file.. On Jul 23, 2013 12:02 PM, "devanand nayak" 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 this with tinwise t

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

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 wrote: > PFA > > > On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E wrote: > >> >> Dear Friends good afternoon, >> >> I need help r

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

Thanks a lot Vijay. Thanks & Regards, Prabhu R On 20 July 2013 13:34, P.VIJAYKUMAR wrote: > Repected Prabhu, > > Please find the attached templates. > > > Regards, > Vijaykumar > > > On Sat, Jul 20, 2013 at 8:06 AM, Prabhu Pinky wrote: > >> Hi Expe

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

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 wrote: > Apologies, I can not share that file > > Rgds, Kaushal >

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

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 wrote: > > > Dear Friends and excel experts,,, > I am facing this problem 3-4 time and now I want a remedy / solution of it >

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 wrote: > Dear Mr Vijay, > > Thanks for it. I tried the same

  1   2   >