Re: $$Excel-Macros$$ urgent query on dropdown list

very very thanks sir. i want the list in dropdown list in sorted order. On Thu, Dec 15, 2011 at 9:17 AM, NOORAIN ANSARI wrote: > Dear Sourabh, > > Please see attached sheet.. > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ How to create a double click using VBA CODE without actually double clicking on the mouse

Dear Aju, Please find attached Worksheet Event Example sheet, HTH, -- Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Dec 14, 2011 at 11:54 AM, Aju Chacko wrote: > D

Re: $$Excel-Macros$$ max length for textbox control

Dear Shankar, Unbound text box: limiting entry length Access automatically prevents you entering too much text if a control is bound to a field. Unbound controls can be limited with the *Input Mask *- one "C" for each possible character. However, the input mask has side effects such as *appending

Re: $$Excel-Macros$$ Median in Pivot Table

Dear Atul, Please see below link, hope it will help to u. http://www.digdb.com/excel_add_ins/median_pivot_table_roll_up/ -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

$$Excel-Macros$$ Median in Pivot Table

Hi Experts, Is there any possible way that I can build Median formula inside the pivot table like average, sum count etc. Thanks! Regards, Atul -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Nee

RE: $$Excel-Macros$$ How to create a double click using VBA CODE without actually double clicking on the mouse

Hi Aju, This is a curious request. It sounds like perhaps you are "asking the wrong question" :) -- The purpose of an event is to start execution of VBA code when a certain triggering event occurs, such as a user action, calculation, opening of a file, etc. You are asking if you can emulate a use

Re: $$Excel-Macros$$ urgent query on dropdown list

thanks to all of you for help but in this sol name are repeating and not in sorted order On Thu, Dec 15, 2011 at 12:25 AM, Maries wrote: > Find the attachment... > > > On Wed, Dec 14, 2011 at 10:00 PM, Haseeb Avarakkan < > haseeb.avarak...@gmail.com> wrote: > >> Hi Sourabh, >> >> Used a dif

$$Excel-Macros$$ Re: VBA code automatic typesetting and show code row number

Rohan, that's solution, thanks your help. Best regards Garcia On 12月15日, 上午2时24分, Rohan wrote: > So if i get you correctly this time, your question is more related to > formatting the vba code and geeting the row number for the code, > specifically and total wise. > > I think you can use a soft

Re: $$Excel-Macros$$ Inventory management

Hi Sushil I cannot get the link to open. Are you able to email to me a xl file ? Thanks Charlie On Wed, Dec 14, 2011 at 8:26 PM, sushil kumar wrote: > Hi Manhar, > > Please see this link http://31.222.142.10:8080/openerp/login?db=&user= > > Database:ManufacturingM > User: admin > password:adm

$$Excel-Macros$$ Opening All excel workbook one by one hen running the code

Hello Ashish, i need a help regarding the open all the excel file one by one and then running the macro. regarding macro i will take care so please suggest me any code for opening the all fiel please dont suggest application.file search becouse i m using 2010 as its wont work in that. i dont kno

$$Excel-Macros$$ Re: VBA code automatic typesetting and show code row number

So if i get you correctly this time, your question is more related to formatting the vba code and geeting the row number for the code, specifically and total wise. I think you can use a software named Notepad ++. This has a option of formatting the vba codes and also gives you the count of lines o

Re: $$Excel-Macros$$ Plz help urgent

Make a pivot - Right click - Value Field settings - Show values as - Select % of grand total. Thanks, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Proble

$$Excel-Macros$$ Re: Rename and search files.....need some extra help

Cant open the vba file...its password protected. Send the password to the group plz and we can try to add additional functionalities. Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please He

Re: $$Excel-Macros$$ Macro work

Plz share the details and the requirement and the details...will give it a try Regards, Rohan. -- FORUM RULES (934+ 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 Adv

Re: $$Excel-Macros$$ Cell editing VBA

Try this... !! Sub Test() Range("B2").Select Do If ActiveCell.Value = "" Then Exit Do ActiveCell.Offset(0, 3).Activate Loop End Sub -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, For

Re: $$Excel-Macros$$ How to create a double click using VBA CODE without actually double clicking on the mouse

hi what do you want instead of Double Click.. when event will be fire? Rajan On 12/14/11, dguillett1 wrote: > I do not understand what you want. Send a file with a full explanation and > examples. > > Don Guillett > SalesAid Software > dguille...@gmail.com > > From: Aju Chacko > Sent: Wednesday,

Re: $$Excel-Macros$$ Cell editing VBA

Try this : Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 And Target.Cells.Count = 1 Then If Target.Value <> "" Then Target.Offset(, 3).Activate End If End Sub On 12/14/11, dguillett1 wrote: > right click sheet tab>view code>copy/paste this>save fil

Re: $$Excel-Macros$$ COUNT Unique using Frequency

hi use this Function to Count only Unique value in a List {=SUM(IF(COUNTIF(A1:A24,A1:A24)=1,1,0))} On 12/14/11, NOORAIN ANSARI wrote: > PFA > > On Wed, Dec 14, 2011 at 10:32 PM, NOORAIN ANSARI > wrote: > >> Dear Darwin, >> >> Please find attached sheet...hope it will help to u... >> >> On We

Re: $$Excel-Macros$$ COUNT Unique using Frequency

Assume Bill ID's are numeric. Use this *ARRAY FORMULA *(must hit * CTRL+SHIFT+ENTER*, rather than just ENTER). then copy down. =SUM(SIGN(FREQUENCY(IF(Customer=E2,Billid),Billid))) If you want to count the total unique ID's regardless of customers, use this with just ENTER. =SUM(SIGN(FREQUENCY(B

Re: $$Excel-Macros$$ COUNT Unique using Frequency

PFA On Wed, Dec 14, 2011 at 10:32 PM, NOORAIN ANSARI wrote: > Dear Darwin, > > Please find attached sheet...hope it will help to u... > > On Wed, Dec 14, 2011 at 9:10 PM, Darwin Chan > wrote: > >> Dear all, >> >> I have a excel table with duplicate bill id, i want to get the unique >> count

Re: $$Excel-Macros$$ COUNT Unique using Frequency

Dear Darwin, Please find attached sheet...hope it will help to u... On Wed, Dec 14, 2011 at 9:10 PM, Darwin Chan wrote: > Dear all, > > I have a excel table with duplicate bill id, i want to get the unique > count. However, it should also consider another criteria, which is > customer. Shoul

Re: $$Excel-Macros$$ Cell editing VBA

right click sheet tab>view code>copy/paste this>save file as .xls or .xlsm to allow macros. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Or Target.Column <> 2 Then Exit Sub Target.Offset(, 3).Select End Sub Don Guillett SalesAid Software dguille...@gmail.com From: he

Re: $$Excel-Macros$$ Macro work

Attach your file as a reply to this message with a complete explanation or send to me Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Ronak Hindocha Sent: Wednesday, December 14, 2011 3:17 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Macro wor

Re: $$Excel-Macros$$ How to create a double click using VBA CODE without actually double clicking on the mouse

I do not understand what you want. Send a file with a full explanation and examples. Don Guillett SalesAid Software dguille...@gmail.com From: Aju Chacko Sent: Wednesday, December 14, 2011 12:24 AM To: excel macro forum Subject: $$Excel-Macros$$ How to create a double click using VBA CODE with

Re: $$Excel-Macros$$ COUNT Unique using Frequency

Hi Darwin if your bill ids are in ascending order then check the attachment see if it helps formula cells in red color On Wed, Dec 14, 2011 at 9:10 PM, Darwin Chan wrote: > Dear all, > > I have a excel table with duplicate bill id, i want to get the unique > count. However, it should also con

$$Excel-Macros$$ COUNT Unique using Frequency

Dear all, I have a excel table with duplicate bill id, i want to get the unique count. However, it should also consider another criteria, which is customer. Should I use advanced filter instead? How should the advanced filter be set? -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.

$$Excel-Macros$$ plz explain the working of fourmula

*in the following formula plz explain the marked section how it become * > > {11;9;5;9;3;13;5;3;11;2;5;0;0;5}+1 > > * > * > > *Convert text to numbers* > > =INDEX(List, MATCH(0, IF(MAX(NOT(COUNTIF($B$1:B1, List))*(*COUNTIF(List, > ">"&List)+1*))=(COUNTIF(List, ">"&List)+1), 0, 1), 0)) > > COUNTIF(r

Re: $$Excel-Macros$$ Macro work

Hi ronak.. you can mail your query on group . Rajan On Wed, Dec 14, 2011 at 2:47 PM, Ronak Hindocha < ronak.hindo...@futurewise.co.in> wrote: > Hi, > > I have a small macro work. We already have a macro but requires some > editing. Can some one please help? I can share more details. > > My cont

RE: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

Can you please provide code for that? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of sunil jagtap Sent: 14 December 2011 18:05 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Perfor

Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

Hi Amit, This situation, I have to give suggestion. you have to write VBA script for below mention point. 1) In Sheet 1, wherever formulas are there you have to write macro 2) create new sheet, Copy data from sheet 1 and paste it to new sheet. I hope your formulas in sheet 1 still there, and al

$$Excel-Macros$$ Cell editing VBA

Question : In attached excel sheet, there are columns named "GRN" and "Recd Qty"". I want VBA code for Reced Qty column's cell .. as soon as GRN cell is filled Recd Qty's cell is activatied, else no.. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Help in preparing the column automatically

Dear Dguilett I dont know to apply it in excel.Plz apply it in file. Regards, Ankit On Tue, Dec 13, 2011 at 7:46 PM, dguillett1 wrote: > What happened to this code that I had offered? You can certainly add a > provision to automatically mark your column. > > > Private Sub Worksheet_Change(ByVa

RE: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

Correct...it will work. The issue is, from this sheet I have linked 5 other sheet a file. So if I changed delete the sheet & copy paste them to other sheet, I will lose all the formula. Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of

Re: $$Excel-Macros$$

-Original Message- From: Shankar Bheema Sender: excel-macros@googlegroups.com Date: Wed, 14 Dec 2011 13:37:34 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dear Experts How to assign max length for a textbox control in MSAccess 2003. In pr

$$Excel-Macros$$ Macro work

Hi, I have a small macro work. We already have a macro but requires some editing. Can some one please help? I can share more details. My contact details are: 99874 12342/ ronak.hindo...@futurewise.co.in Ronak Hindocha CEO & Founder Futurewise Financial Planners http://www.futurewise.co.in --

Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

Hi Amit, I have copy the data and pasted the data in a new excel sheet. It was working fine for me. Please try. Regards, Kiran. Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: "Amit Desai (MERU)" Sender: excel-macros@googlegroups.com Date: Wed, 1

$$Excel-Macros$$ accessing pdf files

Dear Experts For example, One folder contains some pdf files. Folder is named as "file number" If I supplied the particular file number to a textbox created in EXCEL VBA Form and after clicking OK command button, the list of pdf's in a folder to be opened in a separate list with the hyperlink fa

$$Excel-Macros$$

Dear Experts How to assign max length for a textbox control in MSAccess 2003. In properties, no such facility is available. How can it be assigned through Code. regards shankar sb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread t