Re: $$Excel-Macros$$ Help Required

2013-04-30 Thread Rakesh kumar
Hi Priti Great work, Thanku so much. Thank Raeksh k On Wed, May 1, 2013 at 9:56 AM, priti verma wrote: > Hi Rakes, > Yes you can do this without using another column.Please see the > attachement. > Regards, > Priti verma > > > On Tue, Apr 30, 2013 at 6:12 PM, Rakesh kumar wrote: > >> Hi priti,

Re: $$Excel-Macros$$ Help Required

2013-04-30 Thread priti verma
Hi Rakes, Yes you can do this without using another column.Please see the attachement. Regards, Priti verma On Tue, Apr 30, 2013 at 6:12 PM, Rakesh kumar wrote: > Hi priti, > thanks for the help, > Is it possible without using another column. > > > > On Tue, Apr 30, 2013 at 5:49 PM, priti verma

Re: $$Excel-Macros$$ Advanced Pivot Table Question

2013-04-30 Thread xlstime
Hi Nyc, 1st filed it is not possible in pivot table (need to create another column and put condition then add in pivot table ) 2nd field is possible in pivot table (just right and client Value field setting then Show values as tab then change drop down normal to "% of row" or "% of column") ...

Re: $$Excel-Macros$$ Loop issue

2013-04-30 Thread David Grugeon
Well, that bit works OK for me. The questions I would ask are what sheet is active at the time? What is the value of k immediately before the rows... select is run? What is the macro selecting? There are a number of issues with your code. One which concerns me in particular is the line Dim i,

$$Excel-Macros$$ Advanced Pivot Table Question

2013-04-30 Thread nyc . actuary
Thank you for taking a look at this question. See the attached database of data about units of an apartment building. I created a Pivot Table summarizing [Total Units] and [Average Rent] for each combination of [Unit Type] and [Unit Size/ sq ft]. I still need two more fields for 1) Number of

Re: $$Excel-Macros$$ copy the active worksheet and paste it to another workbook in a given path.

2013-04-30 Thread Paul Schreiner
Are you familiar with macros? This is pretty straight-forward. Try recording a macro in which you perform the steps as you've described. Then, edit the macro and replace the specific names with the cell values.   Paul - “Do all the good you can, By all th

$$Excel-Macros$$ copy the active worksheet and paste it to another workbook in a given path.

2013-04-30 Thread santosh subudhi
Hello Team, I need a code that will copy the active worksheet and paste it to another workbook in a given path. The path will be in one of the cells of the active worksheet. For example my active workbook name is book1 and I want the sheet 1 of book 1 to be copied and save it in another workbook

Re: $$Excel-Macros$$ Help Required

2013-04-30 Thread Rakesh kumar
Hi priti, thanks for the help, Is it possible without using another column. On Tue, Apr 30, 2013 at 5:49 PM, priti verma wrote: > Hi Rakesh, > Please see the attachment. > Regards, > Priti verma > > > On Tue, Apr 30, 2013 at 5:22 PM, Rakesh kumar wrote: > >> Thanks Prafull >> >> >> >> >> On Tue

Re: $$Excel-Macros$$ Help Required

2013-04-30 Thread priti verma
Hi Rakesh, Please see the attachment. Regards, Priti verma On Tue, Apr 30, 2013 at 5:22 PM, Rakesh kumar wrote: > Thanks Prafull > > > > > On Tue, Apr 30, 2013 at 4:47 PM, Prafull Jadhav > wrote: > >> Dear Rakesh, >> >> find the same. >> >> Regards, >> Prafull jadhav. >> >> >> On Tue, Apr 30, 2

Re: $$Excel-Macros$$ Help Required

2013-04-30 Thread Rakesh kumar
Thanks Prafull On Tue, Apr 30, 2013 at 4:47 PM, Prafull Jadhav wrote: > Dear Rakesh, > > find the same. > > Regards, > Prafull jadhav. > > > On Tue, Apr 30, 2013 at 4:37 PM, Ahmed Honest wrote: > >> Rakesh: >> >> Run Pivot table, if no Idea just google it to learn Pivot tables / go to >> youtub

Re: $$Excel-Macros$$ new workbook saving with defined names

2013-04-30 Thread xlstime
File save location is current file location \ savefile . Enjoy Team XLS On Tue, Apr 30, 2013 at 5:07 PM, xlstime wrote: > Hi Ram, > > Please find attached file... i hope it's fulfill your requirement > > > . > > Enjoy > Team XLS > > > > On Tu

Re: $$Excel-Macros$$ new workbook saving with defined names

2013-04-30 Thread xlstime
Hi Ram, Please find attached file... i hope it's fulfill your requirement . Enjoy Team XLS On Tue, Apr 30, 2013 at 9:34 AM, excel learner wrote: > hi All, > > please guide me how to declare variable to save the new worbook with > Names listed in A column. > > i am t

Re: $$Excel-Macros$$ Help Required

2013-04-30 Thread Prafull Jadhav
Dear Rakesh, find the same. Regards, Prafull jadhav. On Tue, Apr 30, 2013 at 4:37 PM, Ahmed Honest wrote: > Rakesh: > > Run Pivot table, if no Idea just google it to learn Pivot tables / go to > youtube to learn pivot table. You will learn less time. > > Start exploring. > > Thanks, > > > > >

Re: $$Excel-Macros$$ Help Required

2013-04-30 Thread Ahmed Honest
Rakesh: Run Pivot table, if no Idea just google it to learn Pivot tables / go to youtube to learn pivot table. You will learn less time. Start exploring. Thanks, On Tue, Apr 30, 2013 at 2:04 PM, Rakesh kumar wrote: > Hi Friends, > > I have some problem in excel, please help me. > > column A

$$Excel-Macros$$ Help Required

2013-04-30 Thread Rakesh kumar
Hi Friends, I have some problem in excel, please help me. column A is having list of company and column B having a name of seals Representative.some company name are repeated by some seals representative. so i want find out no of unique company name by each seals representative. -- Thanks £ R

Re: $$Excel-Macros$$ Future Growth Calculation

2013-04-30 Thread Chaya
Dear Hilary Sir, I am very new to excel. Please elabrote with my previous attached excel. And please tell me what is CAGR * * Regards, Chaya Regards, Chaya On Tue, Apr 30, 2013 at 4:04 PM, Hilary Lomotey wrote: > =value for current year * (1+assumed rate of growth) > assumed rate of

Re: $$Excel-Macros$$ Future Growth Calculation

2013-04-30 Thread Hilary Lomotey
=value for current year * (1+assumed rate of growth) assumed rate of growth could be CAGR assume your period spans from 2005 to 2011 the n it will be the value for 2011 divided by the value of 2005 all raised to the power 1/number of periods b/n 2011 and 2005 then you subtract the resultant answer

$$Excel-Macros$$ Future Growth Calculation

2013-04-30 Thread Chaya
Dear All experts, Please provide me formula for future growth calculation and growth rate. i tried a lot but couldn't able to find the accurate. i tried Growth Function but not working. I have attached my file. please find the attachment. Thanking a lot in advance !! Regards, Chaya -

Re: $$Excel-Macros$$ How to create hyperlink within workbook

2013-04-30 Thread अनिल नारायण गवली
Dear Abdulgani, See the attached sheet Manually done by hyperlink formula or funtion. Warm Regards, Gawli Anil On Tue, Apr 30, 2013 at 3:23 PM, अनिल नारायण गवली wrote: > Dear Abdulgani, > > Pl see the attached sheet. > > Warm Regards, > Gawli Anil > > > On Tue, Apr 30, 2013 at 3:14 PM, ITP Abd

Re: $$Excel-Macros$$ How to create hyperlink within workbook

2013-04-30 Thread अनिल नारायण गवली
Dear Abdulgani, Pl see the attached sheet. Warm Regards, Gawli Anil On Tue, Apr 30, 2013 at 3:14 PM, ITP Abdulgani Shaikh < itpabdulg...@gmail.com> wrote: > I have created hyperlink, using formula but it is not working, whats going > wrong ? I want to create hyperlink within workbook, that wo

$$Excel-Macros$$ How to create hyperlink within workbook

2013-04-30 Thread ITP Abdulgani Shaikh
I have created hyperlink, using formula but it is not working, whats going wrong ? I want to create hyperlink within workbook, that workbook will be used by different people on different server. Please guide. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =