Re: $$Excel-Macros$$ Please help on Excel.

see if it helps On Tue, Mar 8, 2011 at 8:51 PM, Rabindra Thapa wrote: > Dear all, > > > > I have one attach file where I am keeping the serial pipe number but the > problem is I am getting the same pipe number many times and it’s hard to > search whether provide pipe number are reported or not

Re: $$Excel-Macros$$ Re: Urgent help required in vba coding!!!!!!!!!!!!!!!!!!!!!

*Thanks Milindthanks a lot.* On Mon, Mar 7, 2011 at 10:05 AM, mkarnik wrote: > Quick reply for 2nd point: > IN VBE, > Select: > Tools / VBA Project Propoerties / Protection > Now enable "Lock Project for Viewing", enter password twice and click > on OK. > Most Imp: Do not forget the passowr

$$Excel-Macros$$ Please help on Excel.

Dear all, I have one attach file where I am keeping the serial pipe number but the problem is I am getting the same pipe number many times and it's hard to search whether provide pipe number are reported or not. Can u have any formula/validation i.e. when I type the reported pipe number its

$$Excel-Macros$$ Re: Rename of files in specific format

Dear Ashish, Thanks alot for the help. One thing more to add. Lets say Main Folder: Jan 2011>>> Sub Folder: 10 sub folder >>> 20 files each sub folder Can I rename all 200 files in one go. On Mar 7, 8:13 am, "OpenExcel.com" wrote: > *Replace* Characters in the Filenames of a > Directory

RE: $$Excel-Macros$$ OT

Hi Paul, Well said. I tried to let it go unchallenged, but since I had nothing better to do at the time... :) Dave. Date: Tue, 8 Mar 2011 19:12:46 +0530 Subject: Re: $$Excel-Macros$$ OT From: svyas0...@gmail.com To: excel-macros@googlegroups.com very nice speech Mr. Paul Sir. Regards Sumi

$$Excel-Macros$$ Profit and Loss analysis on project - Excel presentation

Dear All, I need to do profit and loss analysis through excel presentation for different project for month, problem is our client billing cycles are different to different to all the projects, example: AOC (project) billing cycle every month 15th to next month 14th for NCR every month 24th to next

Re: $$Excel-Macros$$ Calculate Time

Your substitute command is REMOVING the "." completely. You should be REPLACING the "." with a colon (":") Next... is there always a "."? If not, then we're going to have to look at alternatives. Paul From: Rajesh K R To: excel-macros@googlegroups.com Sent:

Re: $$Excel-Macros$$ Calculate Time

Hi Paul You give me excellent answer thank you very much, but when I give the formula timevalue(substitute(d2,".","")) it shows error value #value!. pls check it. Regards Rajesh kainikkar On 3/7/11, Paul Schreiner wrote: > Excel has it's own internal date/time functionality. > A "date" is the

Re: $$Excel-Macros$$ Re: need help in excel - data merge acorrs columns

=A2&" "&B2&" "&C2 = FSD COM com On Tue, Mar 8, 2011 at 7:17 PM, Paul Schreiner wrote: > another alternative actually reduces the wear on the ol' keyboard. > > =A2&" "&B2&" "&C2 > > accomplishes the same thing! > > Paul > > -- > *From:* "davidpk...@verizon.net" > *To:

Re: $$Excel-Macros$$ OT

very nice speech Mr. Paul Sir. Regards Sumit Vyas On Tue, Mar 8, 2011 at 7:07 PM, Paul Schreiner wrote: > Dave, > Hey! I'm an ENGINEER, not an ENGLISH major! > Or a veterinarian for that matter! > What kind of dog would jump over a fox anyway... > Always seemed (seems?) suspicious (spurious?)

Re: $$Excel-Macros$$ how to increse rows in excel 2007 from 65 k to more

you can do it from registry On Mon, Mar 7, 2011 at 4:06 PM, dpk wrote: > how to increse rows in excel 2007 from 65 k to more > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ need help in excel - data merge acorrs columns

use concatenate function or & operator like =A1 & B1 & C1 etc On Tue, Mar 8, 2011 at 3:02 PM, sudhir kumar wrote: > Hi, > > Can u send Excel Sheet of this example. > > thanx > > > On 7 March 2011 12:17, Krish wrote: > >> Hi , >> >> I have data in row and column 1-3, and needs to club the

Re: $$Excel-Macros$$ Re: need help in excel - data merge acorrs columns

another alternative actually reduces the wear on the ol' keyboard. =A2&" "&B2&" "&C2 accomplishes the same thing! Paul From: "davidpk...@verizon.net" To: excel-macros@googlegroups.com; kandy.kr...@gmail.com Sent: Mon, March 7, 2011 1:32:54 PM Subject: Re: $$

Re: $$Excel-Macros$$ OT

BTW, I realize the pangram is "actually": "The quick brown fox jumps over the lazy dog" I simply allowed my twisted sense of humor to distort the true purpose of the phrase... Paul From: Dave Bonallack To: "excel-macros@googlegroups.com" Sent: Mon, March 7

Re: $$Excel-Macros$$ OT

Dave, Hey! I'm an ENGINEER, not an ENGLISH major! Or a veterinarian for that matter! What kind of dog would jump over a fox anyway... Always seemed (seems?) suspicious (spurious?), if you ask me... lol. Paul From: Dave Bonallack To: "excel-macros@googlegroups.

Re: $$Excel-Macros$$ need help in excel - data merge acorrs columns

Hi, Can u send Excel Sheet of this example. thanx On 7 March 2011 12:17, Krish wrote: > Hi , > > I have data in row and column 1-3, and needs to club the data in > single row and column since the data acorss three columns, > > Pls help me. > > Regards, > Krish Kandy. > > -- > > ---

$$Excel-Macros$$ Job opening in naukri

Hi All, There is requirement of a candidate in naukri.com which is master in 1. Excel, advanced Excel, VBA 2. problem solving skill 3. Mental Aptitude 4. Communication Skill Salary Range : 14 K if u found all aptitude in yourself mail your resume divaker.pan...@naukri.com Divaker -- ---