RE: $$Excel-Macros$$ Convert Date to month

2011-11-15 Thread Hitesh Dilipbhai Dhare
Hi, You may define custome date as mmm in A2 column and give reference to the date column that you want to have as month. Regards, Hitesh Dhare (M) +919824004308 NWS-Gujarat Email id: hitesh.dh...@idea.adityabirla.com "Every Problem Is An Opportunity" -Original Message- From: excel

RE: $$Excel-Macros$$ Removing selected letters and symbols from a cell

2010-08-19 Thread Hitesh Dilipbhai Dhare
You can use Mid and RIGHT formula to take the required data See attached Excel for the details With Regards, Hitesh From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Alexander Cargill Sent: Wednesday, August 18, 2010 5:21 PM

RE: $$Excel-Macros$$ Need Help to pickup Rate List for formula

2010-05-07 Thread Hitesh Dilipbhai Dhare
AM, vidyut more wrote: Thnaks for ur sollution. I have given sample ,anybody has formula for to many parties and rate is different for each party i want to know. On Thu, May 6, 2010 at 10:19 AM, Hitesh Dilipbhai Dhare wrote: > Can you tell me, what is the meaning of following argument in

RE: $$Excel-Macros$$ Need Help to pickup Rate List for formula

2010-05-05 Thread Hitesh Dilipbhai Dhare
Can you tell me, what is the meaning of following argument in the solution provided? 'Inv for Rate'!D8 With Regards, Hitesh From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, May 05, 2010 1

FW: $$Excel-Macros$$ How to Copy data from different Excel files into a single Excel Sheet in appended way?

2010-04-30 Thread Hitesh Dilipbhai Dhare
Hi Paul, There are excel files with different sheet in it. I need to capture details of specific sheet. Also it is nice if the details are collected without opening Excel. I am comfortable with VBA and having working experience on Macros in Excel. I need some basic code so that I can go forwar

$$Excel-Macros$$ Help for the macro which combines (appends) data from different excel to single excel file

2010-04-27 Thread Hitesh Dilipbhai Dhare
Hi Friends, If you have got any macro or VB module which compiles data from different excel into single one which are lying in same folder, please provide me. Thanks, Hitesh. From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] O

$$Excel-Macros$$ Re: Pls help me..

2008-11-05 Thread Hitesh Dilipbhai Dhare
Hi Ram, Solution is attached herewith in EXCEL. Use of Pivot table may give you this solution. Regards, Hitesh Dhare +919824004308 New * Email ID: [EMAIL PROTECTED] From: excel-macros@googlegroups.com [mailto:[EMAIL PROTEC

$$Excel-Macros$$ Make a cell a control that launches macro whenclicked

2008-09-12 Thread Hitesh Dilipbhai Dhare
HI, How to include macro in private module? Regards, Hitesh Dhare +919824004308 New * Email ID: [EMAIL PROTECTED] From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Alokeshwar Tiwary Sent: Friday, Septe