$$Excel-Macros$$
-- syed aliya -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ If you are interested to build your carrier in BI Developer/MIS/Database Reporting
Hi Satish/Ayush, Let me tell you one thing it is not mandatory to solve any query right and for your kind information I use to solve many query in earlier days but now a days I dont have the time for these kind of stuff due to busy schedule, On Sun, Jun 9, 2013 at 7:17 AM, Satish Raghav wrote: > > Hi Ayush, > > Pls ban this user, this group is not a advertising platform, > I have attached this group from long period but this user has not solved > any query of Excel and VBA. > > > Now a days this type of some peoples are miss guiding to users by using > this group. > Kindly strictly ban this type of users. > > > Thanks, > Satish R. > > > -- Forwarded message -- > From: syed aliya raza hashim > Date: Sun, Jun 9, 2013 at 12:05 AM > Subject: $$Excel-Macros$$ If you are interested to build your carrier in > BI Developer/MIS/Database Reporting > To: excel-macros@googlegroups.com > > > Hi If you want to build your carrier in BI developer /MIS Reporting/SQL > server coding basic and advance (dynamic Query) and VBA ,EXCEL then Please > Call 9953256629 > Currently I am running a batch ...I am Working In United Health Group as > an Sr.Database Reporting > > > -- > syed aliya > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- syed aliya -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this mess
$$Excel-Macros$$ If you are interested to build your carrier in BI Developer/MIS/Database Reporting
Hi If you want to build your carrier in BI developer /MIS Reporting/SQL server coding basic and advance (dynamic Query) and VBA ,EXCEL then Please Call 9953256629 Currently I am running a batch ...I am Working In United Health Group as an Sr.Database Reporting -- syed aliya -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Need to builtd carreer in MIS/Database Reporting
Please contact 9953256629 at a very reasonable price from a Co orporate Employee -- with real time project experience Regards syed aliya -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Regarding cariier in SQL SSRS SSIS and SAP ABAP
Hi Anybody who want to explore carrier in MS-BI objects,SQL or SAP/ABAP,VBA then feel free to contact on 9953256629/9910893918 I am not a trainer just like as an employees who is working in the same domain knowledge currently I am working in United Health Group As an Sr. Software Developer -- syed aliya -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Need Help
Can excel file such as reports be access from web or can be acccess as web pages suppose we have 10 sheets but from some url we want to see the reports -- syed aliya -- -- 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$$ Most Helpful Member Sep'11 - Noorain Ansari
Congratt Noorain bhai you rock On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Sept'11 > He has posted 140 posts in sept 2011 and helped many people through his > expertise. He has been consistent contributor to this excel forum but has > acheived this recognition for first time. > > *About Noorain Ansari :* > [image: noorain.jpg] > > Noorain is a great poet and keep sharing his thoughts on different topics > throgh cool poems. Professionally, he is a Excel aficionado and presently > working as senior business analyst in One97 Communication Ltd. He is a MS > excel - vba expert and keep sharing his thoughts with this forum. You can > follow his blogs for Excel knowledge and cool poems : > www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com > > *Noorain, Many thanks for all your great support to group. Keep it up* > > *Thanks to Don Guillett, Bheema, Venkat, GoldenLance, Ashish Koul, XLS S , > Paul and other folks for helping excel enthusiasts voluntarily !! Keep it up > !! > > *Keep posting. > > Regards > Ayush Jain > Group Manager > > -- > > -- > 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 > -- syed aliya -- -- 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 Urgent help
Hi, I want to learn VBA Excel so what is the path that should i follow ,does any book will help or what means i despretely learn VBA ,so please help me how to learn -- syed aliya -- -- 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 All, Currently I am working as a MIS-Lead but I want to build my carrier in SAS and I have done MCA so could you tell me the best institute for SAS in DELHI region,so that after doing i can get the good JOB -- syed aliya -- -- 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
Fwd: $$Excel-Macros$$ need help
-- Forwarded message -- From: syed aliya raza hashim Date: Mon, Jul 11, 2011 at 6:06 AM Subject: Fwd: $$Excel-Macros$$ need help To: "koul.ashish" -- Forwarded message ------ From: syed aliya raza hashim Date: Mon, Jul 11, 2011 at 6:03 AM Subject: Re: $$Excel-Macros$$ need help To: excel-macros@googlegroups.com Hi,Thanks for taking initiative , See there are two Clients:-> 1 Genentech 2 Lifetech Both have three tabs Open,closed,Rejection that means total 6 tabs but i want only three tabs named Open,close,Rejection,in Open tab i want to put all Genentech&Lifetech Open data same in closed tab i want to put all Genentech & Lifetech Data ,same as rejection but there should be some check box in all three tab so that i can select Client wise data for example if i check Genentech then it should display only Genentech client data same as for Lifetech On Fri, Jul 8, 2011 at 3:40 PM, syed aliya raza hashim wrote: > Hi, > > Hi , > > I have the two client sheet one for Genentech and Other one is lifetech but > in different tab I want in single tab what I want a check box should be > there when to select *Genentech* the data of that particular client should > appear same as with* Lifetech* > > > -- > syed aliya > > -- > > -- > 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 > -- syed aliya -- syed aliya -- syed aliya -- -- 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,Thanks for taking initiative , See there are two Clients:-> 1 Genentech 2 Lifetech Both have three tabs Open,closed,Rejection that means total 6 tabs but i want only three tabs named Open,close,Rejection,in Open tab i want to put all Genentech&Lifetech Open data same in closed tab i want to put all Genentech & Lifetech Data ,same as rejection but there should be some check box in all three tab so that i can select Client wise data for example if i check Genentech then it should display only Genentech client data same as for Lifetech On Fri, Jul 8, 2011 at 3:40 PM, syed aliya raza hashim wrote: > Hi, > > Hi , > > I have the two client sheet one for Genentech and Other one is lifetech but > in different tab I want in single tab what I want a check box should be > there when to select *Genentech* the data of that particular client should > appear same as with* Lifetech* > > > -- > syed aliya > > -- > > -- > 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 > -- syed aliya -- -- 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$$ Ashish Koul : Most Helpful Member - April'11
Congrat Ashish a deserving one! On Sun, May 1, 2011 at 12:57 PM, NOORAIN ANSARI wrote: > Congrate Ashish.. > Please keep it continue... > On Sun, May 1, 2011 at 10:09 PM, Ayush wrote: > >> Hello Everyone, >> >> Ashish Koul has been selected as 'Most Helpful Member' for the month of >> April'11 >> He has posted 57 posts in April 2011 and helped many people through his >> expertise. He has been consistent contributor to this excel forum and >> achieved this recognition from last five months consecutively.This is really >> awesome. >> >> ASHISH, Many Many thanks for the incredible support to group. >> >> *I have published the same on discussexcel.com homepage.* >> >> Regards >> Ayush Jain >> Group Manager >> >> -- >> >> -- >> 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 > -- syed aliya -- -- 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$$ Help Required!
Hi Andred, see for example in sheet1 UPS 28-Apr-12 Battery 28-Jul-11 SMPS 2-Jan-11 then i want the meassage box should display message when we open the file --like "ur UPS product will expire in 1 year 0r 365 days" because it will calculate from today date so today is 28 april-2011 but for UPS date entry is 28-Apr-2012 so that means it will expire in 365 days same for Battery "ur Battery product will expire after 3 month" because today date is 28 april 2011 and battery entry date is 28 jul-2011 so that means it will expire after 3 month but for SMPS product no need to display because the date mention for SMS is 02-jan-2011 which is already expired on so if the above condition is there for all product in all sheet then i want to display the message box for all sheet if remaining date is there to expire from current date 2011/4/28 André D'Avila > Hello Syed, > > Let me understand... > > You have in Sheet1 - UPS, Battery and SMPS > Sheet2 - Phone, Data Card, Lenser > Sheet3 - Keyboard, Mouse and Monitor > > You want when the file open, a message like: > > Ur product UPS will expire in X days > Ur product Battery will expire in X days > Ur product SMPS will expire in X days > Ur product Phone will expire in X days > Ur product Data Card will expire in X days > Ur product Lenser will expire in X days > Ur product Keyboard will expire in X days > Ur product Mouse will expire in X days > Ur product Monitor will expire in X days > > Or > Each time you open a sheet, for exemple sheet3 > > That automaticaly a message shows and display: > > Ur product Keyboard will expire in X days > Ur product Mouse will expire in X days > Ur product Monitor will expire in X days > > > Best Regards > > André Luiz D´Avila > > > > 2011/4/28 syed aliya raza hashim > >> Hi, >> Problem is stated in file itself , >> the problem is how to displaly the meassage box suppose date column is >> there is all sheets i want to display the meaasage like this product will be >> expired on one month or 30 days or more >> *when we open the file "* >> >> see in the attachment >> >> -- >> syed aliya >> >> -- >> >> -- >> 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 > -- syed aliya -- -- 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$$ Help Required!
Hi, Problem is stated in file itself , the problem is how to displaly the meassage box suppose date column is there is all sheets i want to display the meaasage like this product will be expired on one month or 30 days or more *when we open the file "* see in the attachment -- syed aliya -- -- 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 Sample.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Need Help urgent Please
Hi Ashish, Thanks for replying but it is showing for only 28-April-2011 see what i want to display the meassage which date has been expired eg.today date is 27 april ,so the message display for less than the today date or system date for example Product Date 1001 3-May-2011 1002 26-Apr-2011 1003 28-Apr-2011 the output would be for 1002 because 26 april ia less than the system date or today date,same for all the tab On Wed, Apr 27, 2011 at 4:04 AM, ashish koul wrote: > try this > > > > On Wed, Apr 27, 2011 at 12:50 PM, syed aliya raza hashim < > hashim...@gmail.com> wrote: > >> >> Hi, >> In my sheet there are three tab 1)UPS tab 2)Router tab 3)SMPS tab >> so there are date column as well is there >> my question :when we open the excel file it should prompt me the message >> the date is going to expire on which tab >> for example :suppose in UPS tab for product no 1002&1003 date is 26 Apr so >> it is going to expire from current date then so it has to prompt me when we >> open the file and display the message "under UPS Tab your product id >> 1002&1003 expired" same as for all the tab it should display the meassage >> for all the tab if date is expired into one message box >> like for same all other tab >> -- >> syed aliya >> >> -- >> >> -- >> 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 > -- syed aliya -- -- 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 urgent Please
Hi, In my sheet there are three tab 1)UPS tab 2)Router tab 3)SMPS tab so there are date column as well is there my question :when we open the excel file it should prompt me the message the date is going to expire on which tab for example :suppose in UPS tab for product no 1002&1003 date is 26 Apr so it is going to expire from current date then so it has to prompt me when we open the file and display the message "under UPS Tab your product id 1002&1003 expired" same as for all the tab it should display the meassage for all the tab if date is expired into one message box like for same all other tab -- syed aliya -- -- 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 Need Help.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ need help!
Plz solve my problem! -- syed aliya -- -- 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 Solve.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Need Help!
Hi, Hi i have attached my file i want in sheet 2 there are column c in that i want the name from sheet 1 but there are two condition first is match by ID then match by Name as well then how can we do this -- syed aliya -- -- 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 match by id&name then pull out submitted by from sheet 1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need Help Regarding not calculating the average in case of Jan month but for all other month they are showing correct result
Thank you very much! On Thu, Apr 7, 2011 at 7:32 AM, rajan verma wrote: > use averageif() Function instead of Average(if()) > > Rajan. > > > On Wed, Apr 6, 2011 at 2:09 PM, syed aliya raza hashim < > hashim...@gmail.com> wrote: > >> >> Hi in this formula if i am incresing the range 25 to 125 then it is >> counting blank cell also and traeting blank cell as a jan month so is there >> any suggestion where can we ignore blank cell >> >> =IF(ISERROR(AVERAGE(IF(MONTH($B$2:$B$125)=2,$E$2:$E$125))),"",AVERAGE(IF(MONTH($B$2:$B$125)=2,$E$2:$E$125))) >> >> *see i have highlighted the cell in yellow color in sheet >> *-- >> syed aliya >> >> -- >> >> -- >> 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 > Rajan verma > +91 9158998701 > > -- > > -- > 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 > -- syed aliya -- -- 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 Regarding not calculating the average in case of Jan month but for all other month they are showing correct result
Hi in this formula if i am incresing the range 25 to 125 then it is counting blank cell also and traeting blank cell as a jan month so is there any suggestion where can we ignore blank cell =IF(ISERROR(AVERAGE(IF(MONTH($B$2:$B$125)=2,$E$2:$E$125))),"",AVERAGE(IF(MONTH($B$2:$B$125)=2,$E$2:$E$125))) *see i have highlighted the cell in yellow color in sheet *-- syed aliya -- -- 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 Performance.xls Description: MS-Excel spreadsheet
