Re: $$Excel-Macros$$ URGENT NEED Data Analyst

2016-06-28 Thread BNS kumar
Hi, Is that salary per month or per annum? Regards Kumar BNS On 23 Jun 2016 9:34 p.m., "Excel Guru" wrote: > Position: Backend (audit analyst /data analyst) > > Location: Gurgaon > > Duration: Long Term > > EXP : 0-3 years > > Salarys 15- 25 Salary per annum > > > Looking for 3-4 candid

Re: $$Excel-Macros$$ build me a database that can work with Excel/Word

2015-11-30 Thread BNS kumar
Linking various excel sheets and generating word doc is not a big issue. Brief out your scenario, we can look into it. Regards Kumar BNS On 1 Dec 2015 7:40 am, "Michael K Taylor" wrote: > I need a database that can pull data from multiple Excel pages, and then > be used to populate sections of

Re: $$Excel-Macros$$ EXTRACT ONLY TEXT

2012-09-17 Thread BNS kumar
Hi, The below formula is a generalized version. Hope it works. Even the string starts with numbers, this formula works. * =IF(ISNUMBER(VALUE(LEFT(A1,LEN(A1)-SUMPRODUCT(NOT(ISERR(SEARCH({"1","2","3","4","5","6","7","8","9","0"},A1)))*{1,1,1,1,1,1,1,1,1,1},RIGHT(A1,LEN(A1)-SUMPRODUCT(NOT(ISERR

$$Excel-Macros$$ VBA Libraries

2012-05-14 Thread BNS kumar
Hi Guyz, I want to learn about VBA libraries (For Eg: linking VBA to other programming languages like C/C++, writing/editing library functions etc). I have search a lot online, but couldn't find the exact source. Can any one share notes (if they have) or any online links? Regards Kumar -- FORU

Re: $$Excel-Macros$$ Problems Comparing New Line Character in Strings

2012-05-05 Thread BNS kumar
Can u send a sample file. Regards Kumar On Mon, Apr 30, 2012 at 3:32 AM, Alan wrote: > I have two sets of Excel worksheets I am trying to compare. The cells > contained multiple lines of text. Some identical-looking lines do not > compare with string1 = string2 syntax. It appears the compari

Re: $$Excel-Macros$$ need a macro

2012-03-26 Thread BNS kumar
Hope this file serve your needs Regards Kumar On Mon, Mar 26, 2012 at 5:32 PM, Amresh Maurya wrote: > Hi Friends, > > We have 77 campaign and 77 city lists , now what i need , each campaign > has 77 cities. > > We have attached file for reference. kindly check > > Regards > Amresh > > > -- > FO

Re: $$Excel-Macros$$ Need Vba code to count no.of values in a column

2012-03-15 Thread BNS kumar
Why not you use excel-count function. It will be easier than code. Anyway the same thing is used in code. check out. Sub counts() MsgBox Application.WorksheetFunction.Count(Range("A:A")) End Sub Regards Kumar On Thu, Mar 15, 2012 at 4:25 PM, Naresh V wrote: > Group, > > Can you please pr

Re: $$Excel-Macros$$ Help Needed

2012-03-13 Thread BNS kumar
Hi, Please find the attached text file. Copy and paste in that excel file and run. Regards Kumar On Tue, Mar 13, 2012 at 2:08 PM, Patil MG wrote: > Hi All > > can any one help me pl..its very urgent,,, > > > On Mon, Mar 12, 2012 at 12:52 PM, Patil MG wrote: > >> Dear Exper

Re: $$Excel-Macros$$ Help Needed

2012-03-13 Thread BNS kumar
Hi, check this out Sub CreateWordDocs() ' add a reference to the Word-library ' this is for creating number word Documents and renaming them with file names mentioned in 'C' column ' this code doesn't write any content, it just creates word documents and saves them Dim newapp As