Re: $$Excel-Macros$$ VBA to return to Previous Sheet used

Hi Noorain & Viper The code Viper has posted works like magic. Thanks guys. I can now go to sleep. Charlie On Thu, Feb 16, 2012 at 8:18 PM, The Viper wrote: > try this > > Sub GetColumnRef() > Dim mSht > mSht = ActiveSheet.Name > Dim MyInput > MyInput = InputBox("Enter Column to Search eg

Re: $$Excel-Macros$$ VBA to return to Previous Sheet used

try this Sub GetColumnRef() Dim mSht mSht = ActiveSheet.Name Dim MyInput MyInput = InputBox("Enter Column to Search eg D:5") Sheets.Add.Name = MyInput Sheets(mSht).Activate End Sub On Thu, Feb 16, 2012 at 12:09 PM, NOORAIN ANSARI wrote: > Dear Cab, > > Please try it.. > > Sub GetColumnRef() >

Re: $$Excel-Macros$$ VBA to return to Previous Sheet used

Hi Noorain Thanks for the code. I need to put athe code in again for the new worksheet, have trieed some different places but still not working. Your comments would be appreciated. Charlie On Thu, Feb 16, 2012 at 7:39 PM, NOORAIN ANSARI wrote: > Dear Cab, > > Please try it.. > > Sub GetColumn

$$Excel-Macros$$ Need HR MIS Report format

Dear Group, I need HR MIS Report format Daily/Monthly/Yearly bases.. Thnx Sunny -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will n

Re: $$Excel-Macros$$ VBA to return to Previous Sheet used

Dear Cab, Please try it.. Sub GetColumnRef() Dim CurrentIndex As Long Dim MyInput MyInput = InputBox("Enter Column to Search eg D5") CurrentIndex = ActiveSheet.Index If CurrentIndex > 1 Then Sheets(CurrentIndex - 1).Activate Range(MyInput).Select End If End Sub On Thu, F

$$Excel-Macros$$ VBA to return to Previous Sheet used

HI Have this code: Sub GetColumnRef() Dim MyInput MyInput = InputBox("Enter Column to Search eg D:5") Sheets.Add.Name = MyInput End Sub Works well, but leaves the active sheet as the new sheet. That is the newly created sheet. How do I get it to return to the the sheet prevously used. May

Re: $$Excel-Macros$$ Highest No with Colour, Need Vba Code

On Wed, Feb 15, 2012 at 8:58 PM, Seraj Alam wrote: > >1. Select the whole table with data >2. Choose the command Format | Conditional Formatting >3. Choose Formula is >4. Write in following formula: =MAX($A$1:$A$13)=A4 where A4 is the >first cell with data >5. Create the w

Re: $$Excel-Macros$$ Highest No with Colour, Need Vba Code

1. Select the whole table with data 2. Choose the command Format | Conditional Formatting 3. Choose Formula is 4. Write in following formula: =MAX($A$1:$A$13)=A4 where B4 is the first cell with data 5. Create the wanted format 6. Close the form On Fri, Feb 10, 2012 at 6:02 AM

Re: $$Excel-Macros$$ Needle Gauge Chart Calculation

Because the graduations on the dial are non linear (and not even logarithmic) you cannot automatically calculate the values. You have to do it by trial and error. I have made a new column with my suggestions. You could fine tune this if you wanted to by using more fractional numbers but for prac

Re: $$Excel-Macros$$ Round of numbers

Thanks sam for so quick solution. I will use it and get back to you. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Sam Mathai Chacko Sender: excel-macros@googlegroups.com Date: Wed, 15 Feb 2012 23:53:53 To: Reply-To: excel-macros@googlegroups.com Subjec

Re: $$Excel-Macros$$ bom explosion help needed

Don,   >From beginning, what I'm up to, I'm woking for production site, and from time >to time we launching and delisting product from our current range. On this >point I need to know what should I order or what I should stop ordering. >Ordering is no issue but delisting is different kind of sto

Re: $$Excel-Macros$$ Round of numbers

Sub FormulaRound() Dim rng As Range For Each rng In ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas) rng.Formula = "=ROUND(" & Right(rng.Formula, Len(rng.Formula) - 1) & ",2)" Next rng End Sub Regards, Sam Mathai Chacko On Wed, Feb 15, 2012 at 11:40 PM, wrote: > Dea

$$Excel-Macros$$ Round of numbers

Dear Excel Expert, I have a worksheet which is linked with a base file. Now I want a macro to automatically round up to 2 decimal all the formulas of worksheets. That is if a link is now showing +'sheet1!$C$9 or +sum(a1:b2)the macro will automatically convert it +round('sheet1!$C$9,2) or +

Re: $$Excel-Macros$$ Need help on sumproduct function

http://www.meadinkent.co.uk/xlwtdavg.htm On Wed, Feb 15, 2012 at 9:04 PM, Sam Mathai Chacko wrote: > You have to be a little more clear. '"Average" columns values using > remaining column values' doesn't ring a bell. > > Maybe post an expected output to make your requirement clear. > > Sam > > >

Re: $$Excel-Macros$$ Need help on sumproduct function

You have to be a little more clear. '"Average" columns values using remaining column values' doesn't ring a bell. Maybe post an expected output to make your requirement clear. Sam On Wed, Feb 15, 2012 at 1:40 AM, KAMASANI RAJESH BABU < kamasaniraj...@gmail.com> wrote: > Hi Team, > > Need help o

Re: $$Excel-Macros$$ Drill Down in Embedded Charts(Not Pivot Charts) in MS Excel

Maybe explaining with a picture or a sample file might help. Otherwise, you are not clear. The sample file could contain what you are trying to explain. Sam On Wed, Feb 15, 2012 at 5:09 PM, Vikash Singh Negi < negi.vikassi...@gmail.com> wrote: > Hi, > > Is it possible to show drill down of a Emb

$$Excel-Macros$$ Drill Down in Embedded Charts(Not Pivot Charts) in MS Excel

Hi, Is it possible to show drill down of a Embedded Pie chart on a column chart below. and column chart will change on the click of Pie slice. Please let me know if it is possible by VBA. Thanks, -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles

$$Excel-Macros$$ Need help on sumproduct function

Hi Team, Need help on "Sumproduct" funtion. Below is the description., A b c d e f g Average Q4 12% 54% 55% 20% 19% 53% 68% 37% Q1 5% 22% 67% 20% 39% 21% 62% 37% Q2 7% 31

Re: $$Excel-Macros$$ bom explosion help needed

You are going to have to tell me which item and give examples. Look for _ in col_ in column_, why__ Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Wednesday, February 15, 2012 8:43 AM To: excel-macros@googlegroups.com Subj

Re: $$Excel-Macros$$ Paid basis help for customer followup using excel& lotus

Dear Chandra, You can try it... http://www.excelvbamacros.com/search/label/Send%20%20emails%20and%20attach%20filtered%20data%20from%20workbook%20%20in%20excel%20Using%20Lotus%20Notes On Wed, Feb 15, 2012 at 8:22 AM, Chandra Gupt Kumar < kumar.bemlmum...@gmail.com> wrote: > Hi, > > I am follower

$$Excel-Macros$$ Needle Gauge Chart Calculation

Dear Experts, i have created a speedometer chart, however i am trying to calculate the needle or indicator using the parameters as attached but having difficulty in doing so, i would be grateful if i get some suggestions.thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Us

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

Glad to hep Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: renuka chari Sent: Wednesday, February 15, 2012 12:27 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA Hi dguillett1 Its w

Re: $$Excel-Macros$$ Paid basis help for customer followup using excel& lotus

Please send sample template. Clearly indicates that you need Regards, Chilexcel 2012/2/15 Chandra Gupt Kumar > Hi, > > I am follower of the group but not have much knowledge of macro etc...i m > a small businessman & Now, I intend to use help of the intelligent people > to get my task acc

Re: $$Excel-Macros$$ Pivot Table data range update

Hi, Please use below codes for updates last used row & last used column in Pivot Tables. Sheets("Sheet1").Select ActiveWorkbook.Names.Add Name:="Sheet1", RefersToR1C1:= _ "=OFFSET(Sheet1!C1,0,0,COUNTA(Sheet1!C1),COUNTA(Sheet1!R1))" ActiveWorkbook.Names("AfterEntry").Comment = "" Rega

$$Excel-Macros$$ Convert to Value

Dear All Please tell me formula for Converting Text to Value and remove commas(like following). 2,32,674.82 3,20,460.82 3,20,405.82 3,70,405.82 3,55,221.82 3,37,818.82 2,87,818.82 3,17,818.82 3,67,818.82 3,64,548.82 Thanks&Regards _ Sudhir Verma

RE: $$Excel-Macros$$ plz, check how many categories are there in the column A totally by formula that is applied in single cell to display the result?

Thank You, Mr. Noorain for u r help, praises to u r full presence of mind and salute to knowledge.. Regards, Muneer, CC... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Wednesday, Febru

Re: $$Excel-Macros$$ plz, check how many categories are there in the column A totally by formula that is applied in single cell to display the result?

in addition to noorain formula you can use =sumproduct(1/COUNTIF(A1:A356,A1:A356) without ctrl+shift+enter On Wed, Feb 15, 2012 at 1:56 PM, NOORAIN ANSARI wrote: > Dear Muneer, > > Please use.. > > =SUM(1/COUNTIF(A1:A356,A1:A356) > with ctrl+shift+ENter. > > See attached sheet. > On Wed, Feb 1

Re: $$Excel-Macros$$ plz, check how many categories are there in the column A totally by formula that is applied in single cell to display the result?

Dear Muneer, Please use.. =SUM(1/COUNTIF(A1:A356,A1:A356) with ctrl+shift+ENter. See attached sheet. On Wed, Feb 15, 2012 at 1:23 PM, Mohammed Muneer wrote: > -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blog

Re: $$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

Hi Don Guillett is there any way to keep subject line also while opening that link thanks for every one On Feb 14, 8:44 pm, "dguillett1" wrote: > Don Guillett > SalesAid Software > dguille...@gmail.com > > From: Renukachari Kasee > Sent: Tuesday, February 14, 2012 6:21 AM > To: excel-macros@g