Re: $$Excel-Macros$$ breaking my head last six months-PLsssssss. Help

Hi Joseph, please Find the attached file and let me know if you wanted this kind of formula. Regards, Hanumant From: Joseph To: excel-macros@googlegroups.com Sent: Fri, 21 January, 2011 3:33:04 PM Subject: Re: $$Excel-Macros$$ breaking my head last six month

$$Excel-Macros$$ How to get the address of a cell in VBA

Hi there, I have a question about how to locate the address of the cell in VBA For example, I am looking for "ABC" in my sheet. By using FIND function, I got the location as A1. How could I write this location into one variable? So when later I am using ABC again, I could refer Range("A1") direc

$$Excel-Macros$$ Excel Help

Hi I am trying to build a system for a hairdressers to manage their contacts and activity. I have tried using access which is the obvious answer but I am struggling with the relationships. So i thought excel might do the job. I need a new page per client, but am unsure if excel will do this? Any

Re: $$Excel-Macros$$ Re: Requesting help to generate progress reports in Excel ...

Greg, You are most welcome cheers On Fri, Jan 21, 2011 at 9:05 PM, Greg Mouning wrote: > Hi Ayush, > > That's perfect! Exactly what I want. > > Thanks, > Greg > > On Thu, Jan 20, 2011 at 9:55 PM, Ayush Jain wrote: > >> Hi Greg, >> >> See attached updated one. >> I hope it helps. >> >> >> Thank

Re: $$Excel-Macros$$ Re: Requesting help to generate progress reports in Excel ...

Hi Ayush, That's perfect! Exactly what I want. Thanks, Greg On Thu, Jan 20, 2011 at 9:55 PM, Ayush Jain wrote: > Hi Greg, > > See attached updated one. > I hope it helps. > > > Thanks. > > Best Regards, > Ayush Jain > > On Thu, Jan 20, 2011 at 11:07 PM, Greg Mouning wrote: > >> Hi Ayush, >> >>

RE: $$Excel-Macros$$ Help

Ashish, Please note some time the date is in middle and some it is last. The below formula is not working. Please can you have any other formula. Regards, Shrinivas Citi(r) Global Transaction Services - India UB City, Canberra Block, # 24, Vittal Mallya Road, Bangalore - 56 00 01. Ph- +91-8

RE: $$Excel-Macros$$ breaking my head last six months-PLsssssss. Help

hi, pls provide the clearity you want to student attendance tracker regards saurabh Date: Fri, 21 Jan 2011 02:03:04 -0800 From: rvijayanan...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ breaking my head last six months-PLsss. Help ddsd --

RE: $$Excel-Macros$$ breaking my head last six months-PLsssssss. Help

hi, pls provide the clearity you want to student attendance tracker regards saurabh Date: Fri, 21 Jan 2011 02:03:04 -0800 From: rvijayanan...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ breaking my head last six months-PLsss. Help ddsd --

Re: $$Excel-Macros$$ Auto Reference

hi deepak check you dont need macro for this check the attachment if you still want a macro let me know On Fri, Jan 21, 2011 at 7:02 PM, Deepak Rawat wrote: > > My problem is, I want max amount in the last column but whenever i insert > any column before the Max column the Max range should chan

Re: $$Excel-Macros$$ Help

try this it will extract last word. RIGHT(A1,LEN(A1)-FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1," ","") On Fri, Jan 21, 2011 at 4:37 PM, Chidurala, Shrinivas < shrinivas.chidur...@citi.com> wrote: > Thanks Ashish & Hanumant. Can you also help me how to extract date from > give

$$Excel-Macros$$ help required on conditional formatting

dear all please solve my query in the attached file Thanks in advance Dharmesh Shah -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

$$Excel-Macros$$ Auto Reference

My problem is, I want max amount in the last column but whenever i insert any column before the Max column the Max range should change automatically. I want a macro for the maximum value calculation at the last column. The sample file is attached. Regards, Deepak Rawat -- ---

$$Excel-Macros$$ Re: NEEDHELP

Short answer, Yes. Long answer: You are making a lot of work from this where you probably dont need to. I would suggest that you would be better off writing the VBA code into Outlook and have that application 'push' the data you want into an Access MDB file. I dont see any connection to Excel need

$$Excel-Macros$$ Help

Thanks Ashish & Hanumant. Can you also help me how to extract date from given securities. SecurityDate REC 07.60% 22JAN13 22-Jan-2013 08.80% STATE BKOF BK&JAIPUR 05SEP11 FD GAIL INDIA LIMITED HDFC 0.00% 24AUG12 LIC HOUSING FINANCE 07.50% 10JUN13 Regards, Shrinivas Citi(r) Global Tra

Re: $$Excel-Macros$$ How to save Diff Excel sheet & form excel database

Hi Group, Request you to kindly provide me the solution of my below problem. Ayush :Request you to kindly look into it and provide me the solution its bit urgent. Thanks in Advance. On 1/16/11, maulik desai wrote: > Hi Excel Gurus, > > I am having excel database I want the Diff excel workbook to

Re: $$Excel-Macros$$ breaking my head last six months-PLsssssss. Help

ddsd -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel t

$$Excel-Macros$$ Auto Execute Macro

Can anyone help with this please? I’m trying to set up an auto execute macro in a number of spreadsheets that will automatically record the ID of any user who opens and saves the file. I have set this up Ok but can only it it to work for files where I name the file name in the code ie Applicatio

$$Excel-Macros$$ Re: Help req

HOW TO PASTE THE EXCEL FILE WHILE REPLYING.. RAKESH I AM SENDING YOU THE SOLUTION ON YOUR ID... LET ME KNOW IF THAT HELPED.. On Jan 21, 11:34 am, saggi wrote: > not getting any idea after seeing ur data, > plz elaborate ur issue > > On Jan 21, 4:21 am, Prakash Gusain wrote: > > > What