Re: $$Excel-Macros$$ Calendar - Quarterly

2012-10-27 Thread Excel Beginner
Hi Viswanathan, please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Sat, Oct 27, 2012 at 3:06 AM, Viswanathan Yoganathan viswanathan.yoganat...@asia.xchanging.com wrote: HI, ** ** In the first column we have is year, based upon the month of

Re: $$Excel-Macros$$ Calendar - Quarterly

2012-10-27 Thread The Viper
pfa On Sat, Oct 27, 2012 at 3:06 AM, Viswanathan Yoganathan viswanathan.yoganat...@asia.xchanging.com wrote: HI, ** ** In the first column we have is year, based upon the month of the year it should fix into 4 quarters as shown in the below example. ** ** *Year* *Qtr1*

$$Excel-Macros$$ Excel

2012-10-27 Thread Ruchi Sharma
Hi, I want to learn - how to prepare a pivot table in the excel spreadsheet? Explain with suitable examples. Regards Ruchi Sharma Sent from my iPhone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for

$$Excel-Macros$$ Fwd: Excel

2012-10-27 Thread Ruchi Sharma
Sent from my iPhone Begin forwarded message: From: Ruchi Sharma simpliru...@gmail.com Date: 27 October 2012 4:38:40 PM GMT+05:30 To: excel-macros@googlegroups.com excel-macros@googlegroups.com Subject: Excel Hi, I want to learn - how to prepare a pivot table in the excel

Re: $$Excel-Macros$$ Excel

2012-10-27 Thread ashish koul
visit below links http://www.youtube.com/watch?v=HvZVSn7JkfI http://www.contextures.com/CreatePivotTable.html On Sat, Oct 27, 2012 at 4:38 PM, Ruchi Sharma simpliru...@gmail.com wrote: Hi, I want to learn - how to prepare a pivot table in the excel spreadsheet? Explain with suitable

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

2012-10-27 Thread Don Guillett
You would want to use some autofilter or advanced filter with a series of input boxes or a user form. On Saturday, October 27, 2012 3:14:51 AM UTC-5, shrini wrote: Dear all I WANT TO WRITE A MACRO WHICH WILL ASK USER TO DEFINE HIS SEARCH Example .-: user want to find details of

Re: $$Excel-Macros$$ Exel hyperlink

2012-10-27 Thread Upendra Singh
Hi Ajay, After selecting the cells containing hyperlinks, go to vb editor by pressing alt+f11. Then press ctrl+g and type selection.hyperlinks.delete Press Enter and you are done... Sent from my iPhone On 27-Oct-2012, at 8:56 PM, ajay prasad ajay...@gmail.com wrote: DEAR All, please help me

$$Excel-Macros$$ Need help for Excel - sort expiry date in a seperate sheet

2012-10-27 Thread Rupendra Phatak
Hi Friends, I am having data in a excel which contains records of maturity deposits/securities in different. sheets the only common field is Maturity Date in all sheets. Now what i need is to sort the records in a separate sheet which are due within next 7 days from today when i run macro.

Re: $$Excel-Macros$$ The first sheet to be opened always in an excel file

2012-10-27 Thread Paul Schreiner
If you choose to use the Auto_Open macro, then it must go in a standard module (like Module1) and...It doesn't need to be Private. only the Event macro Workbook_Open needs to be in the Thisworkbook module.   Paul - “Do all the good you can, By all the

Re: $$Excel-Macros$$ Need help for Excel - sort expiry date in a seperate sheet

2012-10-27 Thread ashish koul
attach the sample file On Sat, Oct 27, 2012 at 10:41 PM, Rupendra Phatak rup...@gmail.com wrote: Hi Friends, I am having data in a excel which contains records of maturity deposits/securities in different. sheets the only common field is Maturity Date in all sheets. Now what i need is to