Re: $$Excel-Macros$$ Change the date in required format in macro and store in variable

2015-07-09 Thread Ganesh N
Thanks bro Regards, GN On Thu, Jul 9, 2015 at 1:45 PM, Sunil Kumar Yadav wrote: > PFA > > -- > Thanks & Regards > *Sunil Kumar Yadav* > Skype ID: sunil.yadav7186 > > On Thu, Jul 9, 2015 at 12:15 PM, Ganesh N wrote: > >> Dear team, >> >> Need a help on storing the date in the required format in

$$Excel-Macros$$ Re: Query

2015-07-09 Thread Rohit Jadhav
Hi Soumyendu Paul I'm not exactly sure what you want. So here's my understanding "If user makes any changes in the file he/she has to click the Send mail button before closing the file and you have code for sending the mail " A simple way is to use activex control button instead of the shape you

$$Excel-Macros$$ Please Point error in following UDF

2015-07-09 Thread Rohit Jadhav
Hi I had made this UDF based on the needs of a question asked in this forum. However when i change anything in VBA code (as minute as adding comments or add a point to debug etc. ) the calculated value becomes zero on the worksheet. Also the function does not update automatically when input data

$$Excel-Macros$$ FW: Automatically Generating Report - URGENT

2015-07-09 Thread KANNAN V
Dear friends pls help me. Pls find Attached file and do the needful urgent basis... -Original Message- From: "Kannan V" Sent: ‎10-‎07-‎2015 07:15 AM To: "kannan.ex...@gmail.com" Subject: Fw: Automatically Generating Report - URGENT Dear Friends, Kindly find the enclosed attachment a

$$Excel-Macros$$ FW: Automatically Generating Report - URGENT

2015-07-09 Thread KANNAN V
Dear friends pls help me. Pls find Attached file and do the needful urgent basis... -Original Message- From: "Kannan V" Sent: ‎10-‎07-‎2015 07:15 AM To: "kannan.ex...@gmail.com" Subject: Fw: Automatically Generating Report - URGENT Dear Friends, Kindly find the enclosed attachment a

Re: $$Excel-Macros$$ Re: Need to print text properly alligned in excel

2015-07-09 Thread M.Rafique MRU
Dear MandeepBaluja, You are absolutely right i need data in this way bu slightly different then your invoice. I have illustrated my problem more clearly, hope now you can easily understand my problem & give me solution. For any further query plz ask to me. Thanks & Regards Muhammad Rafique Ujjan

Re: $$Excel-Macros$$ is it possible to reduce this sorting code

2015-07-09 Thread ashish koul
Sub MULTI_LEVEL_SORT() '1ST level SORT ON NAME COL A '2ND level SORT ON START DATE COL B '3RD levle SORT ON END DATE COL C Sheets("Sample").Range("a1:d" & Sheets("Sample").Range("a1").End(xlDown).Row).Sort _ key1:=Sheets("Sample").Range("A:A"), order1:=xlAscending, _ key2:=Sheets("Sample").Range("B

$$Excel-Macros$$ is it possible to reduce this sorting code

2015-07-09 Thread Rohit Jadhav
Hi I want to sort a range say a1 to j15 containing various details of one's mutual fund portfolio like company name, fund name, fund type, no of units held, NAV , dividend received etc. I have created sorting code from excel but is it possible to reduce this code. I am using a separate function

$$Excel-Macros$$ link the cell with different sheet

2015-07-09 Thread Kumar Bhanushali
Dear Sir, I want a macro, the macro which has keyboard shortcut associated with it, will entering any data in cell, if shortcut Key is pressed the list of internal sheet shows and selecting the one sheet from the list it will ask the cell reference with which the cell is to be link. In short,

Re: $$Excel-Macros$$ Change the date in required format in macro and store in variable

2015-07-09 Thread Sunil Kumar Yadav
PFA -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Thu, Jul 9, 2015 at 12:15 PM, Ganesh N wrote: > Dear team, > > Need a help on storing the date in the required format in macro. > > I can able to do but i showing the current date not the actual date. > > Please find the a