$$Excel-Macros$$ How to calculate years of completion from Date of Joining in last and upcoming month.

2013-01-05 Thread santosh sharma
Hi All, Hope you all doing well. I recently joined this group and seeking your help to calculate 5,10,15,20,25,30,35,40,45,50 years of service in last month ( example :Dec'12) and upcoming month (Jan'12) through formula /Macro. Example: DOJ (mm/dd/) (5,10.100 years c

$$Excel-Macros$$ Fwd:

2013-01-05 Thread Ghanshyam Chopare
http://hotel-select-olanesti.ro/lmkrrlp.php -- 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

Re: $$Excel-Macros$$ Vlookup for two same values

2013-01-05 Thread harshad shukla
THANX ..ALTHOUGH THE FILE IS QUITE HELPFUL...BUT IT IS LIMITED FOR EDITING...supposedly i change value for Veg dish...the same is not incorporated in the vlookup. I am also not able to add more items in the list...But thanx a lot for this too.Hope better solution comes next. Harshad On Sat, Jan 5,

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-05 Thread mohan . pandey87
Hi Pankaj Why don't you use user form for the same with better features. Regards, Lalit Mohan Sent from BlackBerry® on Airtel -Original Message- From: Prince Sender: excel-macros@googlegroups.com Date: Sat, 5 Jan 2013 20:03:55 To: Reply-To: excel-macros@googlegroups.com Subject: $$Exc

$$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-05 Thread Prince
Yes one more thing Uncheck the ignore blank option Regards Prince On Saturday, January 5, 2013 9:10:29 AM UTC+5:30, Pankaj wrote: > > Dear Gurus > > I want to make a excel data entry form in which i want some cells to be > mandatory and some can be left out. But with sequence > > Like > >

$$Excel-Macros$$ Re: Mandatory Cell Entry

2013-01-05 Thread Prince
yes it is possible, pleas follow the following steps. 1:DATA Tab->Data validation->Data validation->Select *Custom *in allow section-> In formula box Write *=A1<>"" *->Select *Error alert tab* on same popup ->in Style select *stop*->in error message option give your message-> And at last* OK*

$$Excel-Macros$$ office stationery template

2013-01-05 Thread Smitha S R
HI, Can anyone send some good excel template to maintain the office stationery items, their consumption, opening stock , closing stock, and reports on monthly basis and daily basis -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ Re: need the document in 88mm size

2013-01-05 Thread Prince
why are you not trying font size option in the menu of excel it self.and what do you mean by 89 mm. regards prince On Saturday, January 5, 2013 7:29:39 AM UTC+5:30, Anupam Konhar wrote: > > Hi All, > > I want the font size to be 89mm, how do i do that? > > Find the attached word document.

$$Excel-Macros$$ Re: Multiple xl sheet in single work book

2013-01-05 Thread Prince
HI Kishore. this is the solution provided by one of group member Ashish kaul so please see the attachment. and let us know if it is full feel your requirements. regards prince On Saturday, January 5, 2013 4:28:20 PM UTC+5:30, Kishore wrote: > > > > Dear Experts, > > I have multiple xl wo

Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba

2013-01-05 Thread Prince
hi dear, the code provide by lalit mohan doing the same please check that, i hope it is 90 percent full felling ur requirement it just need a small modification. regards prince On Saturday, January 5, 2013 9:09:21 PM UTC+5:30, .. wrote: > > Please add me to the people wishing to send mail usin

$$Excel-Macros$$ [partially OT] Struggling with a Laptop buy decision; could some1 pls suggest good windows user grp?

2013-01-05 Thread ..
Dear Folks Could someone please suggest a good Ms Windows user group ? Why do I ask ? Yesterday I went to store to buy a working Laptop ... NOT all bells and whistles, but something with a good (I5 or so ) processor, reasonable HDD (500+GB), Windows , etc - sturdy working laptop I am an o

Re: $$Excel-Macros$$ Re: Login to gmail/yahoo and send email using excel vba

2013-01-05 Thread ..
Please add me to the people wishing to send mail using g mail or yahoo What am I looking for 1. Log in = I am ready to log in thru VBA or thru browser 2. Send mail = I will cut and paste recipients , first name, subject, body in the places dedicated / decided by you on the XL sheet. Click a butt

$$Excel-Macros$$ Multiple xl sheet in single work book

2013-01-05 Thread Kishore
Dear Experts, I have multiple xl work sheets total 10 xl files, I want to merge or export to single xl work book, top of the heading of all xl sheets are remain same, Pls help . files are attached. Regards, Kishore. -- Join official Facebook page of this forum @ https://www.fac

$$Excel-Macros$$ res puzy has shared a document with you

2013-01-05 Thread res puzy
Slow processing of dataAPEX CAPITAL PARTNERS DASHBOARD-v3.5.xlsb https://skydrive.live.com/redir.aspx?cid=626d2ba5d18b8138&page=view&resid=626D2BA5D18B8138!107&parid=626D2BA5D18B8138!105&authkey=!AkuGYHZCrWyfKPY&Bpub=SDX.SkyDrive&Bsrc=Share -- Join official Facebook page of this forum @ https://

Re: $$Excel-Macros$$ بضائع جنسية +18

2013-01-05 Thread Ayush Jain
Banned. Thanks for reporting On Saturday, 5 January 2013 10:49:57 UTC+5:30, §»VIPER«§ wrote: > > Ayush, > > Nowadays lots of spam in group. Moderators should be cautious > > 2013/1/4 سمية صفار > > >> اول موقع سكس شوب عربي >> يتميز المتجر بالمصداقية العالية و الموثوقية الكبيرة >> الاسعار المنا

$$Excel-Macros$$ Fwd:

2013-01-05 Thread Michael Cho
http://sandwelltraining.com/ufnthho.php -- 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