Re: $$Excel-Macros$$ inventory sheet

Hi I have opened the file for webandmacros workbook posted here. The first sheet for stock management is blank. No buttons/forms etc. The other sheets are ok and show the information. If I go to VBA to check the code for the VBA Project it asks for a password, which I do not know. Shoulod I nee

Re: $$Excel-Macros$$ inventory sheet

sir, Thank you, its good one. with regards raghu On Sun, Feb 26, 2012 at 12:56 AM, Maries wrote: > Hi, > > Check this link, > > http://www.webandmacros.com/macro_excel_gestion_stocks.htm > > Regards, > > MARIES. > On Sat, Feb 25, 2012 at 7:27 PM, xlstime wrote: > >> please fine the below link

Re: $$Excel-Macros$$ how to find a text in a folder

hi, In folder "xyz" in "abc.xls" i typed 123456, then in agent ransack in "containing search" i typed 123456, but it is not seaching the file abc.xls thanks a lot sir with regards raghu On Sat, Feb 25, 2012 at 11:29 PM, xlstime wrote: > Hi raghu, > > can you share the some data > > > On Sa

Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function

Thanks you so much Asa for your help, it's great value! On Feb 25, 12:05 am, "Asa Rossoff" wrote: > Hi Johann, > > That is another example usage of a boolean expression as a criterion.  In > your example you could actually omit the -- since you are multiplying the > expression already.  The multi

Re: $$Excel-Macros$$ Toolbar

Hi Sam Wow that worked in getting onto toolbar. I would like to have several 'run macroxx' on the toolbar. Each one a different macro to run. I would need an input box to give caption for each entry on toolbar and a listbox to select the macro from a list of available macro (from Macro dialog

Re: $$Excel-Macros$$ how to find a text in a folder

Hi raghu, can you share the some data On Sat, Feb 25, 2012 at 9:44 PM, Sam Mathai Chacko wrote: > Well, then it shouldn't work, should it. You are looking for a number, but > the number is a text. so change all your number texts to actual > numbers. > > Sam > > > On Sat, Feb 25, 2012

Re: $$Excel-Macros$$ add-in creation in excel

Dear Raj, I think best way to create add-in is here.. http://www.ozgrid.com/VBA/excel-add-in-create.htm On Sat, Feb 25, 2012 at 11:00 PM, Raj Mahapatra wrote: > hi group, > > advice me, how to create add-ins in excel. i have tried it by creating a > macro in a workbook and saving it in .xla fo

$$Excel-Macros$$ add-in creation in excel

hi group, advice me, how to create add-ins in excel. i have tried it by creating a macro in a workbook and saving it in .xla format. but its not working. Thanks & Regards -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, li

Re: $$Excel-Macros$$ Extract last digit number

My Try: =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1) On Sat, Feb 25, 2012 at 8:31 PM, Lokesh Loki wrote: > Hi Sam, > > Thank you very much for sending the formula. > > Regards > Lokesh.M > > > On Sat, Feb 25, 2012 at 9:59 PM, Sam Mathai Chacko wrote: > >> =SUBSTITUTE(REPLACE(A1,1,FIND("("

Re: $$Excel-Macros$$ Extract last digit number

Hi Sam, Thank you very much for sending the formula. Regards Lokesh.M On Sat, Feb 25, 2012 at 9:59 PM, Sam Mathai Chacko wrote: > =SUBSTITUTE(REPLACE(A1,1,FIND("(",A1),""),")","") > > Regards, > > Sam Mathai Chacko > > > On Sat, Feb 25, 2012 at 9:49 PM, Lokesh Loki wrote: > >> Hi All, >> >> I n

Re: $$Excel-Macros$$ Extract last digit number

=SUBSTITUTE(REPLACE(A1,1,FIND("(",A1),""),")","") Regards, Sam Mathai Chacko On Sat, Feb 25, 2012 at 9:49 PM, Lokesh Loki wrote: > Hi All, > > I need a formula to extract 20 only form the below text and fix the same > in to next cell. > > > Canada_20120223_E002_E001(20) > > regards > Lokesh.M >

$$Excel-Macros$$ Extract last digit number

Hi All, I need a formula to extract 20 only form the below text and fix the same in to next cell. Canada_20120223_E002_E001(20) regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, N

Re: $$Excel-Macros$$ how to find a text in a folder

Well, then it shouldn't work, should it. You are looking for a number, but the number is a text. so change all your number texts to actual numbers. Sam On Sat, Feb 25, 2012 at 9:32 PM, raghu gr wrote: > hi, > > i am using excel 2003 and number is stored in text only sir > > thank you >

Re: $$Excel-Macros$$ how to find a text in a folder

hi, i am using excel 2003 and number is stored in text only sir thank you On Sat, Feb 25, 2012 at 9:04 PM, xlstime wrote: > which version you are using ? > > > On Sat, Feb 25, 2012 at 7:00 PM, raghu gr wrote: > >> Hi xlstime, >> its working for text only, but for numbers it is not working pls

$$Excel-Macros$$ Need a small MACRO to SPLIT Double Looping

Sir, Basically I Have rows of info. in 6/7 colm. depending upon the colm 1 and colm 2 entries i would like to make colm1 no of files with colm 2 no of sheets in them. I also need to introduce a S No. in each of the sheets. thats it. the data of say 100 rows * 7 Colm in a single XL file/sheet

Re: $$Excel-Macros$$ how to find a text in a folder

If your numbers are stored as text, it will not work... Sam On Sat, Feb 25, 2012 at 9:04 PM, xlstime wrote: > which version you are using ? > > > On Sat, Feb 25, 2012 at 7:00 PM, raghu gr wrote: > >> Hi xlstime, >> its working for text only, but for numbers it is not working pls help. >> >> wi

Re: $$Excel-Macros$$ Formula for bucket

Great sam... very simple and easy On Sat, Feb 25, 2012 at 3:24 PM, Sam Mathai Chacko wrote: > If you have a pretty long range, you could use another range to do the > lookup. I have also added the below suggestion to the attachment. > > Regards, > > Sam Mathai Chacko > > > On Sat, Feb 25, 2012

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Validate text and number in PAN

I believe the OP was asking for a data validation Regards, Sam Mathai Chacko On Sat, Feb 25, 2012 at 8:54 PM, Maries wrote: > Hi, > > Please find the attachment. > > Regards, > > MARIES. > > > On Sat, Feb 25, 2012 at 5:59 PM, Vijayendra Rao > wrote: > >> Dear All, >> >> I want to validate text

Re: $$Excel-Macros$$ how to find a text in a folder

which version you are using ? On Sat, Feb 25, 2012 at 7:00 PM, raghu gr wrote: > Hi xlstime, > its working for text only, but for numbers it is not working pls help. > > with regards > raghu > > > On Wed, Feb 22, 2012 at 9:02 PM, xlstime wrote: > >> please use same software for any data type..

Re: $$Excel-Macros$$ inventory sheet

please fine the below link for excel inventory http://www.excelmagic.com/inventorymagic.html On Sat, Feb 25, 2012 at 7:31 PM, raghu gr wrote: > > > Hi, > > How to maintain inventory in excel sheet, is there any excel sheet / > template / macro. > > with regards > raghu > > -- > FORUM RULES (986

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Validate text and number in PAN

Hi, Please find the attachment. Regards, MARIES. On Sat, Feb 25, 2012 at 5:59 PM, Vijayendra Rao wrote: > Dear All, > > I want to validate text and numbers in PAN number. Validation required as > per below conditions. > > > · Length should be 10 > > · First 5 character should b

Fwd: Fwd: $$Excel-Macros$$ instead of formula need macros

Hi Don, Thanks for your suggestion, I have to prepare some reports based on user name/working days, in that the data is too large and it almost cover the 25000 rows and 25 users. Hence i need a small macros for the required, if it is possible please provide the macro. Regards Lokesh.M On Sat,

Re: $$Excel-Macros$$ plz check and help on the attached sheet the Call Macro to combine the macros is not working...

Could it be because you do NOT have any macros with those names? Don Guillett SalesAid Software dguille...@gmail.com From: Mohammed Muneer Sent: Saturday, February 25, 2012 1:00 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ plz check and help on the attached sheet the Call Mac

$$Excel-Macros$$ inventory sheet

Hi, How to maintain inventory in excel sheet, is there any excel sheet / template / macro. with regards raghu -- 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 Probl

Re: $$Excel-Macros$$ Date Problem

Hi, Try this code, Sub datecorrection() On Error Resume Next Dim MyCell As Range For Each MyCell In Selection.Cells If IsDate(MyCell) Then Selection.NumberFormat = "m/d/" Else MyCell.Value = DateValue(Mid(MyCell, 5, 2) & "/"

$$Excel-Macros$$ $$Excel-Ma​cros$$ Validate text and number in PAN

Dear All, I want to validate text and numbers in PAN number. Validation required as per below conditions. · Length should be 10 · First 5 character should be text · Next 4 should be number · Last character should be text Attached excvel file for your referenc

Re: $$Excel-Macros$$ how to find a text in a folder

Hi xlstime, its working for text only, but for numbers it is not working pls help. with regards raghu On Wed, Feb 22, 2012 at 9:02 PM, xlstime wrote: > please use same software for any data type.. > > > On Wed, Feb 22, 2012 at 12:21 AM, raghu gr wrote: > >> hi, >> >> This is working fine for se

Re: $$Excel-Macros$$ Find Distance and Time between two cities using Google Map In excel

*Great!!! Thanks Ashish...* On Sat, Feb 25, 2012 at 5:01 PM, ashish koul wrote: > Hi Group > > Try this udf it will help you in finding the time and distance between two > cities using Google Map > > > > -- > *Regards* > * * > *Ashish Koul* > *http://www.excelvbamacros.com/* > *http://www.access

$$Excel-Macros$$ Find Distance and Time between two cities using Google Map In excel

Hi Group Try this udf it will help you in finding the time and distance between two cities using Google Map -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. --

Re: $$Excel-Macros$$ List Box Like Tally Software

Dear Maries & SAM & Abi Here with Attached List Box like tally .xlxm what i expected it comes almost 90% which i attached only thing its take time & E1 cell activate then my Listbox screen open Left cornor of window Point No. 2 This list Box should come Under Mydata E1 cell then , Li

RE: $$Excel-Macros$$ Time capture (NOW)

Hi Krishnan, The problem is that formulas do calculations, and you want them to store values. I posted a VBA user-defined function the other day for a similar request. The requestor wanted a formula that would calculate the current date and then retain it without change in the future. I

Re: $$Excel-Macros$$ Toolbar

Yes this can be done Just a quick scrap here with bare minimum requirements... Sub AddMacroToToolBar() Dim lngLoop As Long Const strMacroNames = "Macro,Delete" For lngLoop = 1 To 2 With Application.CommandBars("Worksheet Menu Bar").Controls("&Tools") On Error

Re: $$Excel-Macros$$ Formula for bucket

If you have a pretty long range, you could use another range to do the lookup. I have also added the below suggestion to the attachment. Regards, Sam Mathai Chacko On Sat, Feb 25, 2012 at 10:15 AM, Maries wrote: > Hi, > > Try it.. > > *=VLOOKUP(A1,{0,"0-2";3,"2-4";5,"4-6";7,"6+"},2,TRUE)* > **

Re: $$Excel-Macros$$ Removing zero value from pivot

Thank your very much, I got it in your attachment. On Sat, Feb 25, 2012 at 3:17 PM, Ashish Bhalara wrote: > I don't find your attachment. > > > On Sat, Feb 25, 2012 at 3:10 PM, Sam Mathai Chacko wrote: > >> Ashish, please check my attachment before commenting >> >> Sam >> >> >> On Sat, Feb 25, 2

Re: $$Excel-Macros$$ Removing zero value from pivot

I don't find your attachment. On Sat, Feb 25, 2012 at 3:10 PM, Sam Mathai Chacko wrote: > Ashish, please check my attachment before commenting > > Sam > > > On Sat, Feb 25, 2012 at 3:09 PM, Ashish Bhalara > wrote: > >> Dear Sam, >> >> Thanks for reply but filter is not enable on value in pivot,

Re: $$Excel-Macros$$ Removing zero value from pivot

Ashish, please check my attachment before commenting Sam On Sat, Feb 25, 2012 at 3:09 PM, Ashish Bhalara wrote: > Dear Sam, > > Thanks for reply but filter is not enable on value in pivot, is there any > other way ? > > Ashish > > > On Sat, Feb 25, 2012 at 3:04 PM, Sam Mathai Chacko wrote: > >>

Re: $$Excel-Macros$$ Removing zero value from pivot

Dear Sam, Thanks for reply but filter is not enable on value in pivot, is there any other way ? Ashish On Sat, Feb 25, 2012 at 3:04 PM, Sam Mathai Chacko wrote: > Add an extra column in the pivot and use as filter > > Regards, > > Sam Mathai Chacko > > > On Sat, Feb 25, 2012 at 2:17 PM, Ash

Re: $$Excel-Macros$$ Removing zero value from pivot

Add an extra column in the pivot and use as filter Regards, Sam Mathai Chacko On Sat, Feb 25, 2012 at 2:17 PM, Ashish Bhalara wrote: > Dear expert, > > Is there possible to remove zero value raw from pivot? Please find the > attachment data of pivot file. > > Thanks & regards > > Ashish Bha

RE: $$Excel-Macros$$ plz check and help on the attached sheet the Call Macro to combine the macros is not working...

Hi, thanx for the reply , I did as u r saying but it still fails to execute in the manner I like. Regards, Muneer, CC From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Cab Boose Sent: Saturday, February 25, 201