Re: $$Excel-Macros$$ multiple sheet reference..

2012-11-09 Thread satiqjaffar satiqjaffar
Dear Mr. Ansari Anil, I got that sir.. that was in 97 - 2003 format, so that the formula was not working now i got it sir... thanks a lot for valueable help Regards Jafna kuwait -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

Re: $$Excel-Macros$$ VBA : Class does not support automation error.

2012-11-09 Thread Amol Jadhav
Hi Anil As I aleready mentioned. its too heavy file which is about 19 MB. Let me know the possible reasons Or even if you guys have alternate solution. how to export chart from chartspace. Thanks, Amol J On Fri, Nov 9, 2012 at 12:26 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear

Re: $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple values by vlookup

2012-11-09 Thread Ashish Bhalara
Thanks Rajan, its working fine, thank you very much. Regards Ashsish Bhalara On Thu, Nov 8, 2012 at 7:12 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *I have just Change* * * *LookupRange.Address to LookupRange.Address(, , , 1)*** * * * * *Regards* *Rajan verma* *+91 7838100659

Re: $$Excel-Macros$$ Need Help for Access 2007- How to remove unwanted characters from table.

2012-11-09 Thread Mangesh Vimay
but how? Can you help me please. On 11/9/12, Anoop K Sharma aks.sharm...@gmail.com wrote: Use Clean function On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help. I have Excel file containing some data. I have import this data to MS

$$Excel-Macros$$ sheet name as variable

2012-11-09 Thread Divaker Pandey
Is there any way to make reference like it DataTabTemp!$1:$1 i want to keep sheet name variable MATCH(EVAMOMARGIMP10,DataTabTemp!$1:$1,0) actully i have data in two sheet DataTabTemp and DataTabUS and now i need to change formula on whole application so i don't used anoter formula, but just

$$Excel-Macros$$ Conditional formatting

2012-11-09 Thread Shiva Prasad
Dear Champs, i have on excel one sheet when i mentioned values of percentages change the color of that cells. please help me the formula r any macro also. plz find the attchement of example of trail sheet. plz need . -- Regards, Shivaprasad K. -- Join official facebook page of this

Re: $$Excel-Macros$$ Conditional formatting

2012-11-09 Thread ashish koul
check the attachment On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad shivaprasad1...@gmail.comwrote: Dear Champs, i have on excel one sheet when i mentioned values of percentages change the color of that cells. please help me the formula r any macro also. plz find the attchement of

Re: $$Excel-Macros$$ Conditional formatting

2012-11-09 Thread Ayush Jain
Hi Shiv You can use conditional formatting to color the cells(or any other formatting) based on the value of the cell. I have implemented the same in the enclosed file. Let us know if you need any further assistance on this. Regards Ayush Jain On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad

Re: $$Excel-Macros$$ sheet name as variable

2012-11-09 Thread ashish koul
check the attachment see if it helps On Fri, Nov 9, 2012 at 8:00 PM, Divaker Pandey divake...@gmail.com wrote: Is there any way to make reference like it DataTabTemp!$1:$1 i want to keep sheet name variable MATCH(EVAMOMARGIMP10,DataTabTemp!$1:$1,0) actully i have data in two sheet

Re: $$Excel-Macros$$ Conditional formatting

2012-11-09 Thread Excel Beginner
Hi shiva, please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad shivaprasad1...@gmail.comwrote: Dear Champs, i have on excel one sheet when i mentioned values of percentages change the color of that cells. please

$$Excel-Macros$$ ****Urgent ****Incentive plan of MIS Executive Team

2012-11-09 Thread Brajesh Kumar Porwal
HI Experts, I need help for make incentive plan of MIS executive Team if you have any format and plan for incentive please share with me.. Thanks Brajesh 7503020750 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED

$$Excel-Macros$$ Need Help to Modify the includes code to import data into the active sheet.

2012-11-09 Thread Best Of Luck
Hi, I am importing data using the macro below but my requirements have changed now I have multiple sheets in the target workbook. So I want to import the data only in the active sheet. thanks in advance. Here is the code. Sub ImportCity() ' Get customer workbook... Dim customerBook As

$$Excel-Macros$$ Guide me in modifying the included code to import data into the current active sheet

2012-11-09 Thread Best Of Luck
Hi, I was using the code below to import data into a Excel 2010 workbook with only one sheet. I now have multiple sheets and I wont this macro to only import the data into the active sheet. Here is the code. Sub ImportCity() ' Get customer workbook... Dim customerBook As Workbook Dim filter

RE: $$Excel-Macros$$ VBA : Class does not support automation error.

2012-11-09 Thread Asa Rossoff
Hi Amol, I haven't use the Office Web Components, and we don't know much about your code or file, but the error is usually caused by a references/library problem, such as: .You used early binding but the reference to the OWC library was broken. .The OWC library is not installed

Re: $$Excel-Macros$$ Conditional formatting

2012-11-09 Thread Aamir Shahzad
Please see the attached sheet Aamir Shahzad On Fri, Nov 9, 2012 at 9:59 PM, Excel Beginner excelbegin...@gmail.comwrote: Hi shiva, please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad

$$Excel-Macros$$ discussexcel formula quiz 1

2012-11-09 Thread Ayush Jain
Dear group, I have created a small formula quiz to test your formula knowledge. This quiz has 10 questions related to excel formulas only. Formula quiz http://goo.gl/DE4V3 Based on your participation and engagement, I will try to launch more such activities in the forum Click here to

Re: $$Excel-Macros$$ discussexcel formula quiz 1

2012-11-09 Thread vba
Thanks.. Rilli gud idea.. Sent on my BlackBerry® from Vodafone -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 9 Nov 2012 22:10:48 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ discussexcel formula quiz 1

2012-11-09 Thread vijayajith VA
done On Sat, Nov 10, 2012 at 12:43 PM, Pravin Gunjal isk1...@gmail.com wrote: Done. On Sat, Nov 10, 2012 at 11:40 AM, Ayush Jain jainayus...@gmail.comwrote: Dear group, I have created a small formula quiz to test your formula knowledge. This quiz has 10 questions related to excel

Re: $$Excel-Macros$$ discussexcel formula quiz 1

2012-11-09 Thread Rajasekhar Praharaju
done On Sat, Nov 10, 2012 at 12:47 PM, vijayajith VA vijayajith...@gmail.comwrote: done On Sat, Nov 10, 2012 at 12:43 PM, Pravin Gunjal isk1...@gmail.com wrote: Done. On Sat, Nov 10, 2012 at 11:40 AM, Ayush Jain jainayus...@gmail.comwrote: Dear group, I have created a small formula