$$Excel-Macros$$ Re: Condition Checking

Hi, Following formula will solve your problem: =IF(INT(LEFT(RC[-1], FIND("M", RC[-1])-2))<1000,1,"NA") I am also attaching file herewith. Regards, Swapnil. On Mon, Jun 29, 2009 at 6:52 AM, TERTIUS KOSHY THOMAS < tert...@hees.hitachi.com.sg> wrote: > > Hi all, > Can you help me with a small quer

$$Excel-Macros$$ Re: Urgent help

Thanks bala it working. Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of bala Sent:

$$Excel-Macros$$ Re: Password recovery

Tri Diz,http://rapidshare.com/files/56909443/915LBPT.v10.1.rar or http://www.megaupload.com/?d=KQFM08W9 *Pass:* www.dl4all.com U need any soft ask her http://www.orkut.co.in/Main#CommMsgs.aspx?cmm=39782113&tid=5348791175017352794&na=2&nst=86 On Tue, Jun 30, 2009 at 1:45 AM, hanumant shinde wrote:

$$Excel-Macros$$ Password recovery

hi guys can somebody pleass tell me how to recover VBA password. i tried password recovery tool by microsoft but i have free version which gives only 4 char password.so can somebody tell me hw to recover password plss thanx in advance --~--~-~--~~~-

$$Excel-Macros$$ Need to copy file name to XL.

Hi all, I am stuck with a problem now, Please help. My problem is : I need a macro which will search a group of folders containing documents with extention .xls, .xlsx, .doc, .docx, ppt, pptx, .PDF and txt. I want all the document name to get populate in the B2 coloum of an excel and all the file

$$Excel-Macros$$ how to recover VBA password?

hi guys, can somebody please tell me how to recover VBA password. im in urgent need for this pls send me mails also if possible. arsfan2...@yahoo.co.in thanx a lott --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Re: Macro for MS word formatting

Dear Group, Will anybody be kind enough to solve my problem ??? *I need a macro, that "paste special" an already copied text from email / any other source .. as "values" in a word file, change its font to Arial, font size=16 and colour=Blue and save as on desktop with name "my diary dd-mm-.do

$$Excel-Macros$$ Re: MS PROJECT

Hi, Download ebooks from following site 1. http://rapidshare.com/files/217217105/053-FD_404.rar 2. http://rapidshare.com/files/217217554/053-FD_405.rar 3. http://rapidshare.com/files/156382086/LiP-Ms_Project_2007_Bible.rar Regards kunal On Jun 28, 3:35 pm, rakesh luthra wrote: > Dear All, >

$$Excel-Macros$$ Re: about VBA in MS project

Any help? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Lynn Sent: Sunday, June 28, 2009 2:40 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ about VBA in MS project Hi, I have not been successful in getting this fro

$$Excel-Macros$$ Re: Urgent Help required!!!! Please help!!!

Hi Dilip, Thanks a lot for your respose. This is something which i am expecting to perform. However, i forgot to mention one thing in my previous mail. It would be great if a macro could be created, where all these things (which you have made in the file) could be automatically keeping in mind t

Fwd: $$Excel-Macros$$ Condition Checking

Hi Tertius. -- Forwarded message -- From: TERTIUS KOSHY THOMAS Date: Mon, Jun 29, 2009 at 6:52 AM Subject: $$Excel-Macros$$ Condition Checking To: excel-macros@googlegroups.com Hi all,  Can you help me  with a small query regarding a condition checking using formula.  Please f

$$Excel-Macros$$ Need Help for File Searching Macro

Hi All, I've created one macro that will look into non-blank cells in Column A and search for all file with that extension. This macro was working fine previously but I don't know what happened now, it's not running. Can Anybody help here. May be there is some error or I'm missing an

$$Excel-Macros$$ Re: Condition Checking

hi, use this formula : =IF(INT((LEFT(A2,LEN(A2)-1)))<1000,1,"NA") with regards BALA --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Vide

$$Excel-Macros$$ Re: Help with Attendance Tracker & Salary Calculation

Hello Krishna Thanks a lot to both you and Ajit for looking into my problem. I appreciate the help provided by both of you. Thanks Ashish "Of what use is freedom if it does not include the freedom to make mistakes" -- Mahatma Gandhi On 6/29/09, MOKSH.. wrote: > > Mr. Ashish & Ajit,

$$Excel-Macros$$ Re: Condition Checking

Hi, Please check the attached solution, let me know if it solves your query. Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of TERTIUS KOSHY THOMAS Sent: 29 June 2009 06:52 am To: excel-macros@googlegroups.com Subject: $$

$$Excel-Macros$$ Re: Help with Attendance Tracker & Salary Calculation

Hello Ajit Yes, you are correct. It works after I corrected the error I was making as rightly pointed out by you. Thanks a lot once again for repeatedly looking into my problem and appreciate the help provided. Thanks Ashish "Of what use is freedom if it does not include the freedom to make

$$Excel-Macros$$ Re: How to recover the VBA editor password for any book?

I will not comment on the authentication for those softwares, but there are a lot of passware recovery softwares which gives you all types of password you have lost. Just Google "Lost Passware" and try your luck, you might get some trial/free versions. On Jun 28, 12:55 pm, JsinSk wrote: > You wi

$$Excel-Macros$$ Change the same value in all worksheets with one replace

To replace, for example N/A in all sheets of a workbook with BLANK, use the following: - Use CTRL + F - Type N/A in Find What - Click on Replace - Do not type anything in Replace With - Click on Options - Click on Workbook in Within - Click on Replace All Bingo... all the N/A in the workbook are

$$Excel-Macros$$ Re: Urgent help

Hi, try this code Activeworkbook.saveas(Thiswookbook.path & "\" ClinentName & format(now (),"ddmmhhmm")&".xls") With regards BALA On Jun 27, 5:14 pm, "Chidurala, Shrinivas " wrote: > Dear Friends > > I want file should be save like client name with current date & time > > e.g. > > ICICI

$$Excel-Macros$$ Re: Inserting Rows

Thanx for your help friends, My excel has gone to next level after joining this group. thanx from bottom of my heart, you all are simple gr8. Rgds, Mahender Bisht On Fri, Jun 26, 2009 at 8:52 PM, Dilip Pandey wrote: > Hi Mahesh, > > 'Try below code:- > Sub insertt() > Cells(1, 1).Select >

$$Excel-Macros$$ Re: Inserting Rows

Hey, Hold the cursor where you want to insert the rows. And press ctrl + twice. Regards, Rajesh Kunder On Fri, Jun 26, 2009 at 4:04 PM, Mahesh wrote: > Hi All, > > Need Your help, > > I want 2 insert 2 empty rows between 2 rows containing data. > > Please suggest how to do it. > > Ex. :

$$Excel-Macros$$ Condition Checking

Hi all, Can you help me with a small query regarding a condition checking using formula. Please find the attached Excel file herewith for the query. Thanks in Advance, Tertius. <> --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: EXCEL E BOOK .

Hello Vikas, I tried it didn't gave any error. Please recheck from different computer. Also, let me know the error message. Regards, Sarfaraz Ahmed *MS Excel help * On Sun, Jun 28, 2009 at 4:13 PM, Vikas Gupta wrote: > dear sarfaraj > > this link gives errer >

$$Excel-Macros$$ Re: macro book!!urgent help

Hi Lohit, Download below file from Rapishare.com http://rapidshare.com/files/248896187/Wrox_-_Excel_2003_VBA_Programmers_Refe rence.pdf Regards, Upendra Singh +91-9910227325, +91-9310760597 -

$$Excel-Macros$$ Re: Help with Attendance Tracker & Salary Calculation

HI, The first solution is correct, you are using it in a wrong way. Let me break that up for you- =MonthlySalary *(if(DaysWorked > 30, 30, DaysWorked)/30) You just want to multiply the Monthly Salary with Days Worked. What you are using in the sheet is =D38*(IF(D35>30,30,D35/30)), where

$$Excel-Macros$$ Re: Strange Formatting

Hi Martin, Please send the file.. that'll be easy to see the problem. Regards, Sri On Wed, Jun 24, 2009 at 9:13 PM, mnutty wrote: > > I have a user who after running a macro, has strange formatting > applied to cells in any subsequent workbooks opened in the same Excel > session. When I select

$$Excel-Macros$$ Re: Mail Merge Word Excel 2003

Hi Nourredine, Just insert a column next to your invoice amount date and use =round(cell name,2). Use this new cell reference in your mail merge. That'll do Cheers, Sri On Thu, Jun 25, 2009 at 6:48 PM, NOURREDINE BELHAJ < nourredine.bel...@gmail.com> wrote: > Hi All, > > Hope you are all fine.

$$Excel-Macros$$ Re: Come on Excel Enthusiasts !!! Submit your tip for this week !!!!!

Hye All, Inserting rows and columns is a daily exercise for Excellers!! Crtl+Space and then Ctrl and + to insert columns Shift+Space and then Ctrl and + to insert columns That'll do a lot of wonders. Best Regards, Sri On Fri, Jun 26, 2009 at 8:49 PM, Ayush Jain wrote: > > > Hello Members, >