Re: $$Excel-Macros$$ Re: Delivery Status Notification (Failure)

Anu, A sample file will help. Please provide. AJ On Wed, Sep 7, 2011 at 12:23 PM, anu gomathi wrote: > > > >> > Hi All, >> > >> > Attached the sample data. >> > >> > I have a set of data with multiple opportunity id with the product split >> > which is in the vertical order. >> > >> > Now i h

$$Excel-Macros$$ Re: Delivery Status Notification (Failure)

> > > > Hi All, > > > > Attached the sample data. > > > > I have a set of data with multiple opportunity id with the product split > > which is in the vertical order. > > > > Now i have to make the opportunity id unique & the product level 3 in the > > horizantal. > > > > I have used the pivot for

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - August'11

Congratulations. . . Keep up the good work. Regards, DILIPandey On 5 Sep 2011 23:00, "Ayush Jain" wrote: > Hello Everyone, > Rajan Verma has been selected as 'Most Helpful Member' for the month of > August'11 > He has posted 152 posts in August 2011 and helped many people through his > expertise.

Re: $$Excel-Macros$$ Help in IF Function

Thanks a lot pawel Regards Anu On Wed, Sep 7, 2011 at 12:41 AM, pawel lupinski wrote: > result by IF function > > regards, > Pawel > > -- > *From:* anu gomathi > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, September 6, 2011 9:00 PM > *Subject:* $$Excel-

Re: $$Excel-Macros$$ Reasons for increase in excel file size

2011/9/7 Amit Desai (MERU) > What could be the reason for increase in excel file? I have a file with > size of 4.5 MB, but data contents are not that much. > > ** ** > > You can do the following: > - First you file your virus scanner. > - Then select all the rows and columns and delete it. >

$$Excel-Macros$$ JOB

*Experience:* 2 - 7 Years *Location:* Delhi *Compensation:* Rupees 4,00,000 - 5,50,000 *Education:* UG - B.B.A - Management,B.Com - Commerce PG - M.Com - Commerce,MBA/PGDM - Any Specialization, Finance *Industry Type:* Auto/Auto Ancillary *Role:* Finance Exec. *Functional Area:* Accounts, Finance,

$$Excel-Macros$$ Reasons for increase in excel file size

What could be the reason for increase in excel file? I have a file with size of 4.5 MB, but data contents are not that much. Best Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally pri

Re: $$Excel-Macros$$ Help on Indexing and Matching

I would adise you to do the following: 1. Concatenate the three cells I.e., region, province and barangay in both the Sheets. 2. Now use index and match. Let me know if this clear. Regards, Joe On Tuesday, September 6, 2011, John Alliage Tinio Morales < alliage.mora...@gmail.com> wrote: > Hi, I

Re: $$Excel-Macros$$ Help in IF Function

result by IF function regards, Pawel From: anu gomathi To: excel-macros@googlegroups.com Sent: Tuesday, September 6, 2011 9:00 PM Subject: $$Excel-Macros$$ Help in IF Function Hi All,   Please help me to put the IF function for the below table. If the table v

$$Excel-Macros$$ Help in IF Function

Hi All, Please help me to put the IF function for the below table. If the table value is 0 the product should not be there Attached the file for u r reference Tech OFM Apps Systems Result should be 1 2 0 1 Tech;OFM;Systems 1 2 0 1 Tech;OFM;Systems 1 2 1 0 Tech;OFM;Apps 1 0 0 1 Tech Systems

Re: $$Excel-Macros$$ problem with cell width in a workbook

Dear Bheema, Please try it and see attached sheet Sub Autofit() If TypeName(Selection) = "Range" Then Selection.Columns.Autofit End If End Sub Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ans

$$Excel-Macros$$ JOB MIS executive for Gurgaon

Hey All, We need MIS Exe having good knowledge of Excel and Access. Forward you’re CV on my e-mail address (vikask...@gmail.com) or call me 9911868518 Company Name : AuthBridge Research Services (p) Ltd. Company Website : www.AuthBridge.com Role:MIS Executive Job Description: 1) Prepare Cli

Re: $$Excel-Macros$$ to get printing dialogue box on printing

Dear Bheema, Try it... Private Sub CommandButton1_Click() Application.Dialogs(xlDialogPrint).Show End Sub Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On

Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

Hi Sridhar do you want to save your sheet in 12 new workbooks or you want to add the sheet to existing 12 workbooks On Tue, Sep 6, 2011 at 3:01 PM, SridharBL wrote: > Hi Noorain, > > The code in the weblink did not work. > > This just created a new workbook with a single sheet. > > > Apprecia

Re: $$Excel-Macros$$ pie chart -how to remove in chart

try the attached file On Tue, Sep 6, 2011 at 4:26 PM, sandhya jain wrote: > sometime its a requirement to use pie. > > > On Sun, Sep 4, 2011 at 10:54 PM, Deepak Pal Singh < > deepaktheind...@gmail.com> wrote: > >> Its better to not to use pie chart when you have many data points... >> FYI...

Re: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?

Hi John, please try this see if it helps after u copy and paste first image add Application.CutCopyMode = False this way u can check if loop is working properly or not use below statement to make it wait for 5 second then resume ur code Application.Wait Now + TimeValue("00:00:05") also c

$$Excel-Macros$$ Code to control the database not to accept repeated number

I made a userform. linked it with the datasheet. the filenumber acts as a bridge between userform and datasheet. I have to make the file number unique in excel. Because the duplicate numbers also accepting by the datasheet. If it happened so, my intention will not fulfill. So kindly provide solu

Re: $$Excel-Macros$$ PDF to Excel

try the attachment On Tue, Sep 6, 2011 at 4:06 PM, NOORAIN ANSARI wrote: > Hi Mrinal, > > Free online converter please try it. > > http://www.pdftoexcelonline.com/ > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* >

Re: $$Excel-Macros$$ problem with cell width in a workbook

A simple way to do this is to select the column headers(top row marked a,b,c,) desired>place you mouse on the line between any 2 and click. Record a macro and assign to a shape or button, if desired. From: Shankar Bheema Sent: Tuesday, September 06, 2011 8:48 AM To: excel-macros@googlegroups.co

$$Excel-Macros$$ code for modify command button

I have a database in my excel. On userform i pasted a command button with the name UPDATE. on the click event, the data to the corresponding File no. will populate in respective textfields. My intention is to, if any modify in one or two textfields, when I click on the update button the same wil

$$Excel-Macros$$ to get printing dialogue box on printing

I made a userform with a command button called PRINT and wrote the following: me.printform but it will directly printing the form without showing the Print dialogue box. how to get that dialogue box on command.click event. --

Re: $$Excel-Macros$$ problem with cell width in a workbook

sure guruji, pls have a look at my attachment and provide me solution. I marked the cell data with Redcolor. Those are to be adjusted to their width and remaining to their respective widths. Kindly provide solution. On Tue, Sep 6, 2011 at 7:06 PM, NOORAIN ANSARI wrote: > Dear Bheema, > > pleas

Re: $$Excel-Macros$$ problem with cell width in a workbook

Dear Bheema, please share attachement with any rough example.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Sep 6, 2011 at 6:56 PM, Bh

Re: $$Excel-Macros$$ Conditional Formatting

Perhaps because you said to avoid vba. What excel version. Perhaps a sample file. From: Zafar Iqbal Sent: Tuesday, September 06, 2011 2:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Conditional Formatting Dear Experts, Will somebody inform me that why my request is not

$$Excel-Macros$$ problem with cell width in a workbook

Pls. I need a form to adjust to the data widths of different sizes. Its a part of the form basing on your solution I have to prepare that form of 3 pages. pls provide solution. -- -- Some important links for excel

Re: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?

I am not understanding. Perhaps a sample file dguillett1 @gmail.com -Original Message- From: John Holland Sent: Tuesday, September 06, 2011 2:14 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ? Thanks dguill

Re: $$Excel-Macros$$ scrolling and blinking label caption

Thank so muchh. Noorainji On Tue, Sep 6, 2011 at 11:48 AM, NOORAIN ANSARI wrote: > Dear Bheema, > > See attached sheet. > > *Private Sub UserForm_activate() > marqueeText = " This is a test of the Marquee" > Do > For m = 1 To Len(marqueeText) >

$$Excel-Macros$$ Re: Creating shapes from lists of co-ordinates

Hi everyone, Looks like nobody has had any experience of this, so I've searched elsewhere and found the answer. The key to this problem is that I was looking at it in terms of points. If you change the way that you are looking at the problem to be in terms of segments, it becomes A LOT easier.

Re: $$Excel-Macros$$ write and read cookies through vba.

thanks venkat for ur reply, but it can not be used in excel vba. Divaker On Sep 2, 6:42 pm, Venkat CV wrote: > Hi , > > Look Below links... > > http://www.java2s.com/Code/ASP/Session-Cookie/WriteCookieandreadCooki... > > http://www.bigresource.com/VB-Read-Cookie-in-VBA-from-Word-QVYNPHx6U0... >

Re: $$Excel-Macros$$ pie chart -how to remove in chart

sometime its a requirement to use pie. On Sun, Sep 4, 2011 at 10:54 PM, Deepak Pal Singh wrote: > Its better to not to use pie chart when you have many data points... > FYI... > > On Sun, Sep 4, 2011 at 8:58 PM, sandhya jain wrote: > >> Hi All, >> >> please help me to remove 0 or null value

Re: $$Excel-Macros$$ pie chart -how to remove in chart

This is actually not working i am not able to use it. pls help me On Sun, Sep 4, 2011 at 9:46 PM, ashish koul wrote: > check the link > > http://www.andypope.info/charts/piezeros.htm > > > > On Sun, Sep 4, 2011 at 8:58 PM, sandhya jain wrote: > >> Hi All, >> >> please help me to remove 0 or nul

Re: $$Excel-Macros$$ PDF to Excel

Hi Mrinal, Free online converter please try it. http://www.pdftoexcelonline.com/ -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Sep 6,

Re: $$Excel-Macros$$ Link a Check Box to Other Check Box

[Little bit correction] Please consider it.. On Tue, Sep 6, 2011 at 3:37 PM, Mr Excellent wrote: > Hi Group, > > I have check boxes in the form below , what i want is if i update a value > in " Update Currency Type" in one Check box the value of the Other Check box > "Only Indian Currency" shud

Re: $$Excel-Macros$$ Link a Check Box to Other Check Box

Dear Surya, Please see attached sheet.. Type value in one text box and press tab... -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Sep

$$Excel-Macros$$ Link a Check Box to Other Check Box

Hi Group, I have check boxes in the form below , what i want is if i update a value in " Update Currency Type" in one Check box the value of the Other Check box "Only Indian Currency" shud be same, please let me know how to do it. Thanks Prasad. -- -

Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

Hi Noorain, The code in the weblink did not work. This just created a new workbook with a single sheet. Appreciate for any other options.. Regards, Sridhar BL -- -- Some important links for excel users: 1. Follo

Re: $$Excel-Macros$$ Re: write and read cookies through vba.

hi expert, still waiting Divaker On Mon, Sep 5, 2011 at 12:47 PM, Divaker Pandey wrote: > Hi Expert, > > still waiting for ur solution > > On Fri, Sep 2, 2011 at 4:12 PM, Divaker Pandey wrote: >> Hi Expert. >> >> Is there any way to write and read cookies through vba. >> >> Thanks in advance.

Re: $$Excel-Macros$$ Conditional Formatting

Dear Experts, Will somebody inform me that why my request is not getting your kind attention, please? Regards, Zafar Iqbal On Mon, Sep 5, 2011 at 11:00 AM, Zafar Iqbal wrote: > Dear Experts, > > Still waiting for your kind support. > > Regards, > Zafar Iqbal > >

Re: $$Excel-Macros$$ Re: Hi

Hi Mudit, See Below Links http://www.excel-vba.com/ http://www.ozgrid.com/VBA/ http://www.exceltip.com/book-1931841047.html http://www.cpearson.com/excel/Downloads.aspx http://www.contextures.com/tiptech.html *Best Regards,* *Venkat * *Chennai* *My Linked in profile

Re: $$Excel-Macros$$ processor to slow for proper sequential processing of vba code ?

Thanks dguillett1 for your assistance, but i am not sure this is the right track. Perhaps it is my lack of knowledge, but i cannot this code to work. What i need is to make sure that some code is completely excecuted before a next part of code is processed. How can i control the VBA code to wait wi