Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-24 Thread Mathan
Hi, Can we do this using VBA macro? I understand that excel will struggle while searching. But is it possible? If yes, could anyone help me out? Thanks On Wed, Apr 24, 2013 at 2:45 PM, Kanwaljit Singh wrote: > Hello Sir, > > What I understand that is > --You are using a Validation List > --You

$$Excel-Macros$$ copy formula down

2013-04-24 Thread David H
I am using an excel spreadsheet in conjunction with Loftware. which requires headers in cells A1 and B1. I have formulas in A2 and B2 calculating data from C2 and D2. I'll enter data in columns C & D and then copy the formula down in columns A and B. My problem is when I reset the worksh

Re: $$Excel-Macros$$ $$How to FillDown using offset-macro required

2013-04-24 Thread Amit Basra
hi R.Karunanith, You can simply use the concatenate function to do the concatenation i have tried doing it seems to work fine for me, hope this solution works for you, i just tried helping, it it does'nt work please forgive me. Thanks & Regards Amit Basra On Wed, Apr 24, 2013 at 10:42 PM, karu

$$Excel-Macros$$ $$How to FillDown using offset-macro required

2013-04-24 Thread karunanithi ramaswamy
Sirs,    I want to fill down Sim card numbers around 5 lacs each contain 19 digits and the sims have numbers from one value to another, in sequence for 5 to 10,000. I split this to 3 or 4 columns and then idea to concatenate.  The numbers in sequence is highlighted in yellow.Using a macro i can m

Re: $$Excel-Macros$$ HELP TO RESTRICT TO ENTER THE MORE THAN THE ACTUAL VALUE

2013-04-24 Thread GRKRISHNA NAIDU
HI PRITI THNK U ONCE AGAIN BUT IF THE actual value is more than sum OF ( H5,J5) it shoud not allow to enter the column neither h5 nor j5) regardS On Wed, Apr 24, 2013 at 7:48 PM, priti verma wrote: > Hi GRKRISHNA, > Please find the attachment. > Thanks > Priti verma > > > On Wed, Apr 24,

Re: $$Excel-Macros$$ HELP TO RESTRICT TO ENTER THE MORE THAN THE ACTUAL VALUE

2013-04-24 Thread priti verma
Hi GRKRISHNA, Please find the attachment. Thanks Priti verma On Wed, Apr 24, 2013 at 7:36 PM, GRKRISHNA NAIDU wrote: > dear PRITI VERMA > > THNKS FOR YOUR HELP > > WILL YOU PLEASE SHOW ME IN WORK SHEET > > > > > On Wed, Apr 24, 2013 at 7:27 PM, priti verma wrote: > >> Hi GRKRISHNA, >> >> Pleas

Re: $$Excel-Macros$$ HELP TO RESTRICT TO ENTER THE MORE THAN THE ACTUAL VALUE

2013-04-24 Thread GRKRISHNA NAIDU
dear PRITI VERMA THNKS FOR YOUR HELP WILL YOU PLEASE SHOW ME IN WORK SHEET On Wed, Apr 24, 2013 at 7:27 PM, priti verma wrote: > Hi GRKRISHNA, > > Please use this formula in your data validation. > > =IF(SUM(H5+J5)-F5<=F5,"true","false") > > Regards; > > Priti verma > > > On Wed, Apr 24, 20

Re: $$Excel-Macros$$ Dcount funtion

2013-04-24 Thread Sant Ram
Hi Amar, If you are using Database function ..please ensure that all header name are same i.e.. database,field, and criteria... Your formula is working fine.. but you have changed header name see cell H11 Regard, Santy On Wed, Apr 24, 2013 at 3:29 PM, अनिल नारायण गवली wrote: > Dear Amar, >

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-24 Thread Kanwaljit Singh
Hello Sir, What I understand that is --You are using a Validation List --You want that When you start typing in the cell, the entries in validation list start reducing to those matching the words, like a wild-card search. It that is true, I don't think there is any Excel Add-in for such purpose.

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-24 Thread Mathan
Hi, Thanks for taking time out and helping. Does auto correct work even for names? Example, in column A, I have names as following Mathan Raja Ravi if I type 'M' in column B. It should auto fill 'Mathan'. Pls let me know if its not clear. Plz see my first post for more details. Thanks On 22/04