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

done On Sat, Nov 10, 2012 at 12:47 PM, vijayajith VA wrote: > done > > > On Sat, Nov 10, 2012 at 12:43 PM, Pravin Gunjal wrote: > >> Done. >> >> On Sat, Nov 10, 2012 at 11:40 AM, Ayush Jain wrote: >> >>> Dear group, >>> >>> I have created a small formula quiz to test your formula knowledge. Thi

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

done On Sat, Nov 10, 2012 at 12:43 PM, Pravin Gunjal wrote: > Done. > > On Sat, Nov 10, 2012 at 11:40 AM, Ayush Jain wrote: > >> 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

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

Thanks.. Rilli gud idea.. Sent on my BlackBerry® from Vodafone -Original Message- From: Ayush Jain Sender: excel-macros@googlegroups.com Date: Fri, 9 Nov 2012 22:10:48 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ discussexcel formula quiz 1 Dear group, I have

$$Excel-Macros$$ discussexcel formula quiz 1

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 Based on your participation and engagement, I will try to launch more such activities in the forum Click here to particip

Re: $$Excel-Macros$$ Conditional formatting

Please see the attached sheet Aamir Shahzad On Fri, Nov 9, 2012 at 9:59 PM, >>Excel Beginner<< wrote: > Hi shiva, > >please find the attachment. > > > > > -- > *Regards,* > * > * > *Excel Beginner* > * > * > On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad wrote: > >> Dear Champs, >> >>

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

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 o

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

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

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

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 Work

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

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 f

Re: $$Excel-Macros$$ Conditional formatting

Hi shiva, please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad wrote: > 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

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

check the attachment see if it helps On Fri, Nov 9, 2012 at 8:00 PM, Divaker Pandey 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 "DataTabTem

Re: $$Excel-Macros$$ Conditional formatting

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 wrote:

Re: $$Excel-Macros$$ Conditional formatting

check the attachment On Fri, Nov 9, 2012 at 9:55 PM, Shiva Prasad wrote: > 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.

$$Excel-Macros$$ Conditional formatting

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 fo

$$Excel-Macros$$ sheet name as variable

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

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

but how? Can you help me please. On 11/9/12, Anoop K Sharma wrote: > Use Clean function > > > > On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay > wrote: > >> Hi Friends, >> >> I need your help. >> I have Excel file containing some data. I have import this data to MS >> Access 07 table by using Ap

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

Thanks Rajan, its working fine, thank you very much. Regards Ashsish Bhalara On Thu, Nov 8, 2012 at 7:12 PM, Rajan_Verma wrote: > *I have just Change* > > * * > > *LookupRange.Address to LookupRange.Address(, , , 1)*** > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk

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

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, अनिल नारायण गवली wrote: > Dear Amol , > > Pl share a she

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

> > 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 FOR