$$Excel-Macros$$ Auto Hide Empty Columns

2013-03-06 Thread Azhar Rai
Hello Dear Gurus I have a large worksheet with huge numbers of rows and columns. What I want is that when I filter a row all irrelevant (empty) columns should hide automatically. Please help as a lot of time is wasted on daily basis while hiding and unhiding columns. Thanks lot. -- Are

$$Excel-Macros$$ IN TROUBLE

2012-06-29 Thread Azhar Rai
Hello Dear Gurus I want to add columns in an *excel sheet* between *R* and *AQ* to be total in number as in cell *H5* and I also want this to be replicated in sheet2, sheet3, and sheet4 and these columns should also carry the formula from column *R*. Gurus please help me. Thanks -- FORUM

Re: $$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge

2010-06-15 Thread Azhar Rai
. AZHAR RAI Skype: azhar.rai On Fri, Jun 4, 2010 at 16:52, Azhar Rai azhar@gmail.com wrote: Hello Gurus I am afraid I did not receive response from anyone. AZHAR RAI Cell: +92-333-552-7731 Skype: azhar.rai On Thu, Jun 3, 2010 at 10:03, Azhar Rai azhar@gmail.com wrote: Hi Gurus

Re: $$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge

2010-06-15 Thread Azhar Rai
Thanks Alvin My question is HOW? I am just failed to accomplish the task. Please help me. AZHAR RAI Skype: azhar.rai On Wed, Jun 16, 2010 at 07:10, fongie alvin.c.s.f...@gmail.com wrote: Hi Azhar, Try using a variable for your file name. This variable file name can be driven from

Re: $$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge

2010-06-04 Thread Azhar Rai
Hello Gurus I am afraid I did not receive response from anyone. AZHAR RAI Cell: +92-333-552-7731 Skype: azhar.rai On Thu, Jun 3, 2010 at 10:03, Azhar Rai azhar@gmail.com wrote: Hi Gurus My work relates to prepare a large number of reports and I use mail merge for all this process. I

$$Excel-Macros$$ Solution Required for MS Word File Generated through Mail Merge

2010-06-02 Thread Azhar Rai
is when I apply the save as command on MS Word the new file name is fetched from the first line of the report (a combination of Ref No, Name, country or whatever). Please help me out in the issue. Thanks AZHAR RAI Islamabad, Pakistan +92-333-552-7731

Re: $$Excel-Macros$$ Excel Sheet Renameing Macro Reqired

2010-06-01 Thread Azhar Rai
of each report. What I need is when I apply the save as command on MS Word the new file name is fetched from the first line of the report (a combination of Ref No, Name, country or whatever). Please help me out in the issue. Thanks AZHAR RAI Cell: +92-333-552-7731 On Tue, Jun 1, 2010 at 15:38

Re: $$Excel-Macros$$ Excel Wonders(Excel formulas)

2010-05-14 Thread Azhar Rai
Hi Rajesh The document is really impressive. Can you please guide where to find its latest version after Office 2010 has appeared in the market and may be author has made changes since then as its v1.0 Beta copyright 1998-2001. I am grateful to you. AZHAR RAI Cell: 0333-552-7731 Skype

Re: $$Excel-Macros$$ URGENT Request

2010-05-13 Thread Azhar Rai
Thanks a lot Vigooo. You have solved my problem. Thanks again and again. AZHAR RAI Cell: 0333-552-7731 Skype: azhar.rai On 13 May 2010 10:10, Vigooo nv1...@gmail.com wrote: to make it precise, =if(ISERROR(SEARCH( ,A1)),LEN(A1),SEARCH( ,A1)-1) With best regards, Vignesh *From

$$Excel-Macros$$ URGENT Request

2010-05-12 Thread Azhar Rai
. Thanks and regards in advance for urgent replies. AZHAR RAI Cell: +92 333-552-7731 Skype: azhar.rai -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ TOUGH QUESTION

2010-05-10 Thread Azhar Rai
Hi aindril The pictures are stored on my local hard disk. AZHAR RAI Cell: 0333-552-7731 Skype: azhar.rai On 7 May 2010 18:33, Aindril De aind...@gmail.com wrote: Hi azhar, Are these images stored somewhere in your local disk or online? Regards, aindril On Fri, May 7, 2010 at 10:46 AM

Re: $$Excel-Macros$$ Date formatting

2010-05-07 Thread Azhar Rai
Dear Members I was just trying to calculate a similer thing but could not. Please help me too. I need to add a certain number of years to a date and get the resulting date. HOW? Thanks AZHAR RAI Skype: azhar.rai On 6 May 2010 16:13, dare2gold goldiechoudh...@gmail.com wrote: Dear Members

$$Excel-Macros$$ TOUGH QUESTION

2010-05-07 Thread Azhar Rai
Dear Members Can someone help me create a trick related to mail merge in Office 2007/2010. I want to mail merge pictures FROM an excel sheet (where there are hyperlink to different pictures) TO a word document. Your help will save a lot of my time and efforts. Regards AZHAR RAI Cell: 0333-552

Re: $$Excel-Macros$$ Urgent Help

2010-05-06 Thread Azhar Rai
Dear can you please tell me how to change the extention from txt to exe. thanks AZHAR RAI Cell: 0333-552-7731 Skype: azhar.rai On 5 May 2010 19:58, sudhir kumar sudhir.p...@gmail.com wrote: i attached the folder lock software, u install it , it is very good for folder lock. first change