$$Excel-Macros$$ Re: Investment Calculator 2018

Please help me. On Friday, October 5, 2018 at 8:31:07 PM UTC+5:30, Suyog wrote: > > Hello All, > > I'm trying to develop *"Investment Calculator"* with increasing > investment. > Please refer attached excel file & please help me to calculate *"Futu

$$Excel-Macros$$ Investment Calculator 2018

Hello All, I'm trying to develop *"Investment Calculator"* with increasing investment. Please refer attached excel file & please help me to calculate *"Future value"* of investment. *Thank you in advance.* With Regards, *Suyog* -- Are you =EXP(E:RT) or =NOT(EX

Re: $$Excel-Macros$$ Re: Invitation to the Excel Modeling World Championships 2014

Dear Saleem, Find attached excel created by me & already shared in group. This is the same attaching for your ready ref. I've used only & only formulas to convert digit into words. With Regards, Suyog On Sunday, 7 September 2014 09:23:40 UTC+5:30, Saleem Ansari wrote: > &

$$Excel-Macros$$ How to share Code/Macro ?

ormal user to do ? This macro should run automatically on any pc. 3. Can I add "Any additional button" which would be appear along with the exiting toolbar of excel ? so that normal use will only click that button without headache ? Kindly advice me. With Regards, Suyog -- Are you =E

Re: $$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

share the same with my co-workers. I can't see, save as option in vba window. Pl help. Thanks to all group members, because of you all I made this code. With Regards, Suyog *Below is the modified code. * Sub ReportWriter() ' Format Macro ' ' Keyboard Shortcut: Ctrl+q ' 

$$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

Hello All, I made my first macro code. Kindly review. Now only problem remain is instead of *Range("A1:I100"), I want excel to choose "last row & last column" which contain text/value.* PL help. Regards, Suyog " Below is my code" *Sub Format()* ' F

$$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

Hello All, I made my first macro code. Kindly review. Now only problem remain is instead of *Range("A1:I100"), I want excel to choose "last row & last column" which contain text/value.* PL help. Regards, Suyog " Below is my code" *Sub Format()* ' F

$$Excel-Macros$$ Re: Question on My Menu !!

is the excel which I've shared with group members. Kindly help me to solve this issue. With Regards, Suyog On Sunday, 28 October 2012 13:10:35 UTC+5:30, Suyog Kulkarni wrote: > > Hello All, > > I'm using Ashish Sir's "My Menu ver 1.6" very frequently &

Re: $$Excel-Macros$$ Need macro for repetative formatting

Hello Ravinder, Pl refer attached excel which contains all steps & also refer two sheet. One with original software output & other is "required format" I'm requesting all to look into this & kindly help me. With Regards, *Suyog* On Wednesday, 2 April 2014 15:17

Re: $$Excel-Macros$$ Need macro for repetative formatting

Hello All, Pl advice on mail below. Am I asking something very difficult ? If anybody can help that can save my lots of time. Pl do the needful. Regards, Suyog > On Tuesday, 25 March 2014 11:59:37 UTC+5:30, Suyog Kulkarni wrote: >> >> Hello Vicky, >> >> I'm

Re: $$Excel-Macros$$ Need macro for repetative formatting

Hello All, Pl help & try to solve my problem. Regards, Suyog On Tuesday, 25 March 2014 11:59:37 UTC+5:30, Suyog Kulkarni wrote: > > Hello Vicky, > > I'm not at all coping data from any where otherwise I would have used the > "paste special". I'm pullin

Re: $$Excel-Macros$$ Need macro for repetative formatting

ow I want to tell excel that follow my 10 steps upto last row & last column which is having text. It may be "row 10 column 10" or "row 85 or column 60" or anything. Sometimes it's come so hectic to just waste time on formatting only. Pl help & solve this problem.

$$Excel-Macros$$ Need macro for repetative formatting

contains text" sometimes report may finish in F column & 30th row or sometimes it cross P column & 150th row. Refer attached excel, I've added my steps, sample of original report & sample of expected report. If I got answer of this, this will increase my productivity

$$Excel-Macros$$ Need help in modification of Cell range !

cro enabled excel" in the "C:\Program Files\Microsoft Office\Office12\XLSTART" folder ? Kindly help me. Regards, *Suyog* -- 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.fa

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

t;fonts & cells" in white color ? <> I can't say, we'll keep those sheets hidden as anyone can "unhide" those sheets. If we can achieve this, that will be great. Regards, Suyog On Monday, 5 August 2013 11:41:55 UTC+5:30, pappu wrote: > > Hi Umar Abeer,

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

y. I would like to set "my date & time" as expiry & I'll set password to that macro. Thanks in advance. With best regards, Suyog On Monday, 29 July 2013 14:17:14 UTC+5:30, De Premor wrote: > > This is the sample code, you can set it up in ExpDate variable > >

Re: $$Excel-Macros$$ Question : Form control of Excel 2007

Ashish Sir, Thank you. This is working. You have solved my big problem. With Regards, *Suyog* On Wednesday, 3 July 2013 20:23:41 UTC+5:30, ashish wrote: > > try this macro see if it helps > > Sub add_comboboxes() > > Dim rng As Range > Dim cl As Range > Dim shp As Shape

$$Excel-Macros$$ Question : Form control of Excel 2007

here anyway of copying Form Control Check Boxes ? Kindly refer attached file for ready ref. Please advice. With Regards, *Suyog* -- 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.co

$$Excel-Macros$$ List of Diffcult formules

ing preparation kindly advice about this thought. If anybody already having such excel then we can use the same. With Regards, Suyog -- 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.fac

$$Excel-Macros$$ Re: Need formula based on 3 condition

g his 12months between the leave card duration should get PL with request to Pro-rata basis Regards, Suyog On Sunday, 13 January 2013 12:11:20 UTC+5:30, SamJesseK wrote: > > Suyog, > > It seems that multiple conditions can be met based on certain dates. Can > you double chec

$$Excel-Macros$$ Need formula based on 3 condition

Hello All, Requesting to help again. I.ve tried IF condition to solve this problem but failed. I don.t know how to create conditions with multiple If. With Regards, Suyog -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise

$$Excel-Macros$$ Need formula based on 3 condition

Hello All, Please see attached excel, I'm confused how can I set IF statement based on varying 3 condition for one cell. Please review & advice. With Regards, *Suyog* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ Question on My Menu !!

Hello All, I'm using Ashish Sir's "My Menu ver 1.6" very frequently & that increased my working speed in excel. I'm really thankful for same. Please refer attached my question regarding "insert" option of my menu. Please advice on my question. With

Re: $$Excel-Macros$$ Macro for outlook

e 7) Restart "outlook" 8) Goto - tools - macro - set for No check for security Testing : 1) Try to send mail without subject. Outlook will ask you question. 2) Type "Please find attached " & try to send mail without attachment, Outlook will ask you question. Regards, Suy

Re: $$Excel-Macros$$ Macro for outlook

k for security Testing : 1) Try to send mail without subject. Outlook will ask you question. 2) Type "Please find attached " & try to send mail without attachment, Outlook will ask you question. In case of any problem feel free to ask me. Regards, *Suyog* On Tuesday, 18 September

$$Excel-Macros$$ Macro for outlook

uot;enclose" also. I'm not expert of macro but I learned little bit due to this group. Please review & advice. With Regards, *Suyog* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use c

$$Excel-Macros$$ Please help : Use of Criteria & Rule1-2

ood book for excel 2007 for study. Thanks & regards, Suyog -- FORUM RULES (986+ members already BANNED for violation) 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

Re: $$Excel-Macros$$ Attendance tracker 2012

Hi Santosh, Nicely solved. I checked IF condition but I've not understood how you set criteria for different names. Ex .Selecting Halfday Leave will result HL in status column. How to set that. Can explain please. Regards, Suyog On Monday, 18 June 2012 14:07:48 UTC+5:30, santosh

$$Excel-Macros$$ Re: Attendance tracker 2012

Hi Lokesh, I'm not expert of macros but following condition you can achieve by using combination of "Match & vlookup". Regards, Suyog On Friday, 15 June 2012 17:51:42 UTC+5:30, lokesh wrote: > > Hi Experts, > > I need a help from you, i have attache

Re: $$Excel-Macros$$ Query on dd-mm & mm-yy format

Thanks Sam, I think my problem is solved. Regards, Suyog On Wed, Nov 16, 2011 at 12:01 AM, Sam Mathai Chacko wrote: > > =IF(IFERROR(DATE(YEAR(G23),MONTH(G23),DAY(G23))=G23,0),MONTH(G23)&"-"&IF(DAY(G23)=1,0,DAY(G23)),G23) > > Regards, > > Sam Mathai Chacko

Re: $$Excel-Macros$$ Query on dd-mm & mm-yy format

Hello Noorain, Thanks for quick response but I've added two problems in same excel. Please review & advice. Suyog On Tue, Nov 15, 2011 at 3:14 PM, NOORAIN ANSARI wrote: > Dear Suyog, > > Please see attached sheet. > > > > -- > Thanks &am

Fwd: $$Excel-Macros$$ Query on dd-mm & mm-yy format

hich have mm-dd-yy format & same cells should be converted into "dd-mm" TEXT format. 3) Remaining al cells should be remain UNCHANGED. Formula I tried : =IF(D7="","",IF(YEAR(D7)=2000,TEXT(D7,"mm-yy"),TEXT(D7,"dd-mm"))) But this is changing cells

$$Excel-Macros$$ Query on dd-mm & mm-yy format

have more than 1000 rows), If anybody can suggest any easy way to save time. Thanks & regards, -- *Suyog Kulkarni* Mailto:-suyog.kulka...@yahoo.com suyog.kulka...@hotmail.com Ph:-( +91 ) 9890123539 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurat

$$Excel-Macros$$ VB one to 33 lessons

Hi All, Refer uploaded VB 33 lesson (39).doc for new comers. Refer all 33 lessons & start your VBAmacros. Thanks SK --~--~-~--~~~---~--~~ - Some important links for excel users: