$$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

$$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 vt_kan...@camsonline.com Sent: ‎10-‎07-‎2015 07:15 AM To: kannan.ex...@gmail.com kannan.ex...@gmail.com Subject: Fw: Automatically Generating Report - URGENT Dear

$$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 vt_kan...@camsonline.com Sent: ‎10-‎07-‎2015 07:15 AM To: kannan.ex...@gmail.com kannan.ex...@gmail.com Subject: Fw: Automatically Generating Report - URGENT Dear

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

2015-07-09 Thread Ganesh N
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 attached file for your reference. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

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 ganeshg...@gmail.com 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.

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

$$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$$ 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: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