Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!
Dear Jocky, please find attached sheet.. Formula is here... =IFERROR(VLOOKUP($F$2,DATA!$B$2:$G$8,3,0),) Thanks regards, Noorain Ansari On Sun, Jan 16, 2011 at 11:33 PM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Attached for ur reference Regards, Manoj Kumar On Mon, Jan 17, 2011 at 12:16 PM, jocky Beta jocky6...@gmail.com wrote: Hi, I made a Excel sheet with help of V lookup using the Data validation, but my formula shows unknown error. hence pls explain me the step by step procedure for the same. Regards Jocky -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel formula(Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!
For contact person ur formula should be =VLOOKUP($F$2,DATA!$B:$G,3,0) And so on. i.e instead of A it shoul start from B.as unique value is in col. B. Hope it will haelp u. On 17 January 2011 12:16, jocky Beta jocky6...@gmail.com wrote: Hi, I made a Excel sheet with help of V lookup using the Data validation, but my formula shows unknown error. hence pls explain me the step by step procedure for the same. Regards Jocky -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards, Sandeep Kumar Chhajer. Ph. no: 07498171901 09339549906 Wish you all happy new Year 2011. -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Graph Query (Its very urgent)
Dear all I have a problem in Excel Graph . Please find attached Sheet and help me Please lok at the graph ( I want to chenage the Legend and C should be on top then D then B then A) Can any one help me to do this Thanks in advance Waiting for reply -- Shrini -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel oct to march orders vs actual (2).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Need Help
Dear Team, Please find attach file in which i have explained my requirement and request of your kindness to provide me the solution, *as i have more than 4000 records of such data*. Thanks Regards Priya -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Solution Quest.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Formula
Good Formula! Please brief its logic especially about 2. On Sun, Jan 16, 2011 at 10:27 AM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi John, It will work in version 2003 if you refer the cell reference to part of the column range instead of referring it to the whole column. =LOOKUP(2,FIND(A1,Sheet2!A1:A65535),Sheet2!B1:B65535) See the attached file for detail. --- Ms.Exl.Learner --- On Sat, Jan 15, 2011 at 12:59 AM, John A. Smith johnasmit...@gmail.comwrote: Dave, Why am I getting #NUM! with the formula? (See Attached) Thank you. John On Fri, Jan 14, 2011 at 10:35 AM, Dave Bonallack davebonall...@hotmail.com wrote: Hi, I would like to submit the following formula as one I like. It performs a case-sensitive Vlookup, and is non-array. *=LOOKUP(2,FIND(A1,Sheet2!A:A),Sheet2!B:B)* A1 contains the lookup value Sheet2!A:A is the lookup column Sheet2!B:B is the return column I hasten to add that this formula is not my own, but is a very neat solution to a common problem. Regards - Dave. -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Empty Mail
Hi Hanumant, I have also faced this while approving messages. I think its a bug of Google groups and not any issue at your end. I hope it helps. Best Regards, Ayush Jain Group Manager. On Mon, Jan 17, 2011 at 1:28 AM, hanumant shinde hanumant_5...@yahoo.co.inwrote: Hi Friends, some time few mails which are sent to our group doesnt have any content. On my machine i dont see any content or body.this happens with even my mails which i send to our group. I just want to know this is my machine problem or my registration problem or you too guys face this. @Ayush Could you please look into this. -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Best regards, Ayush Jain -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need Help
Hi Se att, u can do with pivot table. Rgds Enjoy excelling... On Mon, Jan 17, 2011 at 7:04 PM, Priya Jose questpr...@gmail.com wrote: Dear Team, Please find attach file in which i have explained my requirement and request of your kindness to provide me the solution, *as i have more than 4000 records of such data*. Thanks Regards Priya -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Solution Quest.xls Description: MS-Excel spreadsheet
Fwd: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!
Hi Manoj, Thanks for the Information, But when i individually insert range_lookup value 0 it shows #NA value in contact person, Hence i request you to please give me the Step by step details from starting to do the Same(from how to make drag drop list to Last one) Looking foreword for your co-operation. *Please Help me for the above Query!!! * * * * * *Thanks * *Jocky * On Mon, Jan 17, 2011 at 1:03 PM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Attached for ur reference Regards, Manoj Kumar On Mon, Jan 17, 2011 at 12:16 PM, jocky Beta jocky6...@gmail.com wrote: Hi, I made a Excel sheet with help of V lookup using the Data validation, but my formula shows unknown error. hence pls explain me the step by step procedure for the same. Regards Jocky -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ hi experts good evening
can u help me any one how to use offset, index, match in indepth i know basics to use these functions i need indepth summery using arrays like that i need more and more help for offset function thanks in advance -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ good evening all experts can u solve my problem
Date Time 04/15/2009 06:02:35 04/14/2009 16:46:49 04/14/2009 16:46:49 04/14/2009 16:46:49 04/14/2009 16:46:48 04/14/2009 23:58:34 i need this kind of format in internally, formula bar have this kind of format only i dont need am or pm in internallcell formula in formula bar how to change this kind of format i know date format in format cells option but internally formula bar having am/pm but i dont need internally also how to change can u help me any one thanks in advance -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need Help
check the attachment se eif it helps On Mon, Jan 17, 2011 at 7:04 PM, Priya Jose questpr...@gmail.com wrote: Dear Team, Please find attach file in which i have explained my requirement and request of your kindness to provide me the solution, *as i have more than 4000 records of such data*. Thanks Regards Priya -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Solution_Quest(1).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ good evening all experts can u solve my problem
goto control panel - reginal settings - select time and click on customise - click on time tab and choose H:mm option On Mon, Jan 17, 2011 at 8:21 PM, renuka chari jva.ch...@gmail.com wrote: Date Time 04/15/2009 06:02:35 04/14/2009 16:46:49 04/14/2009 16:46:49 04/14/2009 16:46:49 04/14/2009 16:46:48 04/14/2009 23:58:34 i need this kind of format in internally, formula bar have this kind of format only i dont need am or pm in internallcell formula in formula bar how to change this kind of format i know date format in format cells option but internally formula bar having am/pm but i dont need internally also how to change can u help me any one thanks in advance -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ build a database from multiple workbooks
send us the sample workbook On Mon, Jan 17, 2011 at 12:10 AM, Seba sebastjan.hri...@gmail.com wrote: Hello all, I have a question regarding building a database. I have a workbook for each of my projects. I would like to have a macro, which would extract/ copy certain data (always in the same rows and columns) to a new workbook, which would serve as a database. Could anyone please help? Thank you in advance. Best regards, seba -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Query
Dear experts, How to resolved attached query, can anybody tell formula not macro. Regards, Aamir Shahzad -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel QUERY.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Data Validation - No Repitation of data avoid blank
Dear Masters, I have one issue.. I am creating one file wants to use data validation with list (giving name to a range of vendor). My data sheet contains few columns.ColumnA - Vendor name, B - service type. As one vendormay provide I have 2 or more options in column B against same vendors. Thus my list or say name range covers Vendor name more than once. I want to avoid this in data Validation. I want to seeVendor's name only once not more than that (as like filter). Also I do not want to see any blank cell as an option in data validation cells. Kindly reply. Best Regards, Amit Desai -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Query
Sorry Aamir, Can't understand the question. If your worksheet had a cell with the desired answer in it (entered manually) this may help me understand your request. Regards - Dave. From: aamirshahza...@gmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query Date: Mon, 17 Jan 2011 23:31:49 +0500 Dear experts, How to resolved attached query, can anybody tell formula not macro. Regards, Aamir Shahzad -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Query
check the attachment see if it helps you On Tue, Jan 18, 2011 at 10:36 AM, Dave Bonallack davebonall...@hotmail.comwrote: Sorry Aamir, Can't understand the question. If your worksheet had a cell with the desired answer in it (entered manually) this may help me understand your request. Regards - Dave. -- From: aamirshahza...@gmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query Date: Mon, 17 Jan 2011 23:31:49 +0500 Dear experts, How to resolved attached query, can anybody tell formula not macro. Regards, Aamir Shahzad -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel QUERY(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Empty Mail
Hi Ayush, Thanks for clarification. From: ayush jain jainayus...@gmail.com To: excel-macros@googlegroups.com Sent: Mon, 17 January, 2011 8:00:52 PM Subject: Re: $$Excel-Macros$$ Empty Mail Hi Hanumant, I have also faced this while approving messages. I think its a bug of Google groups and not any issue at your end. I hope it helps. Best Regards, Ayush Jain Group Manager. On Mon, Jan 17, 2011 at 1:28 AM, hanumant shinde hanumant_5...@yahoo.co.in wrote: Hi Friends, some time few mails which are sent to our group doesnt have any content. On my machine i dont see any content or body.this happens with even my mails which i send to our group. I just want to know this is my machine problem or my registration problem or you too guys face this. @Ayush Could you please look into this. -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Best regards, Ayush Jain -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Array If
Hi Srinivasan, Thanks for the reply. there is no sample data . i just wanna know hw can i know if the specifi value (lets say hanumant) is present in specific range or not (lets say A1:A1000). so i can say i wanna check IF hanumant is present in A1:A1000 range. but i dont wanna type any formula in all cells from A1 to A1000. its jus i ll type 1 formula in B1 and i ll get True or False in B1. From: Srinivasan Ethirajalu srinivasan.ethiraj...@gmail.com To: hanumant_5...@yahoo.co.in; excel-macros@googlegroups.com Sent: Mon, 17 January, 2011 9:10:49 AM Subject: Re: $$Excel-Macros$$ Array If Hi hanumant, You are checking absolute ranges(A8:A14) with a single value a. Which is not possible. Please narrate your requirement as well as send with sample data. On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde hanumant_5...@yahoo.co.in wrote: Hi Friends, I want to use IF condition like i used below but its no working. I used below formula. ={IF($A$8:$A$14=a,1,)} f d s d f g a . . . and so on this is my data which is random. i want to write if any of the row in above data has a then write 1 else 0. if condition will come only once not for all the rows. i dont wanna use macro nor OR as data can be large. Thanks -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Srinivasan Ethirajalu, +919677042736 -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ How to save Diff Excel sheet form excel database
Hi group, Awaiting for your help On 1/16/11, maulik desai mauliksde...@gmail.com wrote: Hi Excel Gurus, I am having excel database I want the Diff excel workbook to be save on basis of walkin date Process from sheet1 (Excel Database) in D:\output Data\Sheet name walk In Date with year with their respective test Scores with addition to capability of sending mail from Sheet 2 (Summay Sheet) for More detail Please ref Attached excel Sheet. Thanks In Advance -- Thanks Regards, Maulik Desai 9967363926 -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks Regards, Maulik Desai 9967363926 -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ latest Value By Macro
Hi, Can some provide me the solution,Awaiting for your responce. On 1/16/11, maulik desai mauliksde...@gmail.com wrote: Hi excel Guru's 1)I want a macro which can able to Provide the unique entry on the basis of walk in date , Date of Birth name 2)I am having 3 excel Sheets. In Sheet1 I have to paste the data from server on a daily basis,In Sheet 2 I have to maintain database with unique entrys,Sheet 3 Will be the Output File Please Find attached file for your ref better Understading. -- Thanks Regards, Maulik Desai 9967363926 -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks Regards, Maulik Desai 9967363926 -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Query
Dear Amir, Pl provide more clarity wid complete example. a href=http://www.signaturebar.com/img src= http://www.signaturebar.com/uploads/images/24667.png border=0/a On Tue, Jan 18, 2011 at 12:01 AM, Aamir Shahzad aamirshahza...@gmail.comwrote: Dear experts, How to resolved attached query, can anybody tell formula not macro. Regards, Aamir Shahzad -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Array If
TYPE THIS IN B1 =IF(COUNTIF(A1:A1000,hanumant )=1,true,false) On Tue, Jan 18, 2011 at 9:48 AM, hanumant shinde hanumant_5...@yahoo.co.inwrote: Hi Srinivasan, Thanks for the reply. there is no sample data . i just wanna know hw can i know if the specifi value (lets say hanumant) is present in specific range or not (lets say A1:A1000). so i can say i wanna check IF hanumant is present in A1:A1000 range. but i dont wanna type any formula in all cells from A1 to A1000. its jus i ll type 1 formula in B1 and i ll get True or False in B1. -- *From:* Srinivasan Ethirajalu srinivasan.ethiraj...@gmail.com *To:* hanumant_5...@yahoo.co.in; excel-macros@googlegroups.com *Sent:* Mon, 17 January, 2011 9:10:49 AM *Subject:* Re: $$Excel-Macros$$ Array If Hi hanumant, You are checking absolute ranges(A8:A14) with a single value a. Which is not possible. Please narrate your requirement as well as send with sample data. On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde hanumant_5...@yahoo.co.in wrote: Hi Friends, I want to use IF condition like i used below but its no working. I used below formula. ={IF($A$8:$A$14=a,1,)} f d s d f g a. . . and so on this is my data which is random. i want to write if any of the row in above data has a then write 1 else 0. if condition will come only once not for all the rows. i dont wanna use macro nor OR as data can be large. Thanks -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Srinivasan Ethirajalu, +919677042736 -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ need help
Hi Guys need your help, I have 25 agenst overall I have to record listen to 12 calls per agent, While rating a call i'll put scores in sheet one automatically it should get updated in sheet 3 i.e. summary sheet all the scores shuld get accumulated... Thanx in advance Regards, Lucky -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Assessment Sheet.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!
Hi Jocky, The reason you are getting #NA error because your criteria for * table_array* * * (*This is the table of data that VLOOKUP searches to find the information you are after.*) is wrong. Your range should start from column B and not A because the value you want to find in the B column of the table. And I think this is the only mistake u have made in the formula Some links :- http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel http://www.techonthenet.com/excel/formulas/vlookup.php I think this help u out Regards, Manoj Kumar On Mon, Jan 17, 2011 at 8:40 PM, jocky Beta jocky6...@gmail.com wrote: Hi Manoj, Thanks for the Information, But when i individually insert range_lookup value 0 it shows #NA value in contact person, Hence i request you to please give me the Step by step details from starting to do the Same(from how to make drag drop list to Last one) Looking foreword for your co-operation. *Please Help me for the above Query!!! * * * * * *Thanks * *Jocky * On Mon, Jan 17, 2011 at 1:03 PM, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Attached for ur reference Regards, Manoj Kumar On Mon, Jan 17, 2011 at 12:16 PM, jocky Beta jocky6...@gmail.com wrote: Hi, I made a Excel sheet with help of V lookup using the Data validation, but my formula shows unknown error. hence pls explain me the step by step procedure for the same. Regards Jocky -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Array If
Hi Hanumant, use it like IF($A$8 =a,1,) and drag the formula till A14 or till last row it will give u 1 only if the cell will contain a. Try this out. Rgds, Mayank On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde hanumant_5...@yahoo.co.inwrote: Hi Friends, I want to use IF condition like i used below but its no working. I used below formula. ={IF($A$8:$A$14=a,1,)} f d s d f g a. . . and so on this is my data which is random. i want to write if any of the row in above data has a then write 1 else 0. if condition will come only once not for all the rows. i dont wanna use macro nor OR as data can be large. Thanks -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks, Mayank -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ How to add Icon sets
Hi Group, I am trying to add icon sets in excel 2007. I want to add a up arrow in the cell for the value 0, down arrow for the value 0 and horizontal line (neutral) for value =0. I tried to implement the above by using the standard formula but could not do it. Please advise how it can be done. Do I need to use VBA code for this? Regards, San -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Formula of the week - share your best formula
Mine Fav Formula this week is =COUNTIF(A$3:A3,A3) It resolved my headache...Give ranking n order number for repetitive values Love tht one -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Fwd: need help
Hello, Guys Need your help urgently please Regrads -- Forwarded message -- From: lucky singh lucky60...@gmail.com Date: Tue, Jan 18, 2011 at 10:51 AM Subject: need help To: excel-macros@googlegroups.com Hi Guys need your help, I have 25 agenst overall I have to record listen to 12 calls per agent, While rating a call i'll put scores in sheet one automatically it should get updated in sheet 3 i.e. summary sheet all the scores shuld get accumulated... Thanx in advance Regards, Lucky -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Assessment Sheet.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet