Objective is to calculate Sale for the financial year 2009-10 (April 2009 -
March 2010 )for each staff no. Data are in sheet named 'DATA' in different
column. It Starts with Staff No. then Start Date, End Date, Sale Type, and
Amount (It is Sale per month during start and end period).
1. F
Please follow the link.
http://www.ozgrid.com/VBA/ExtractNum.htm
Hope it serve the purpose.
Regards,
C.G.Kumar
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Monday, August 23, 2010 5:23 PM
To: excel-macros@goog
Its rocking.
Regards,
C.G.Kumar
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of viju mobile
Sent: Monday, August 23, 2010 3:30 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rupee symbol on PC
Just use thi
.
Regards,
C.G.Kumar
From: Chandra Gupt Kumar [mailto:kumar.bemlmum...@gmail.com]
Sent: Saturday, August 21, 2010 12:32 PM
To: 'ashish koul'
Cc: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ sending e mail based on data in column in
excel
Dear Koul,
Thanks fo
http://akoul.blogspot.com/
On Sat, Aug 21, 2010 at 10:31 AM, Chandra Gupt Kumar
wrote:
Could you please share how it is possible.
Regards,
C.G.Kumar
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Vasant
Sent: Friday, August 20, 2010 1
Could you please elaborate the problem so that I may suggest a solution.
Regards,
C.G.Kumar
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of hemant shah
Sent: Thursday, August 19, 2010 10:54 PM
To: excel-macros@googlegroups.com
based on data in column in
excel
Yes, it is possible to do
Regards
Vasant
On 8/20/10, Chandra Gupt Kumar wrote:
Dear All,
My requirements are as follows;
1. Based on date of birth (Col D), mail to be sent on particular day
to respective office for good wishes.
2
Dear All,
My requirements are as follows;
1. Based on date of birth (Col D), mail to be sent on particular day
to respective office for good wishes.
2. Based on date of joining , congratulation mail to be sent if the
concerned completes 5,10,15,20,25,35,40 years of service.
Please find attached solution.
Regards,
C.G.Kumar
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Kal xcel
Sent: Wednesday, August 18, 2010 6:49 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Etracting sales data as per desired
Thanks Neil .
Regards,
C.G.Kumar
AMW-2
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of neil johnson
Sent: Thursday, July 15, 2010 10:22 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Pdf of Excel Macro
Hi Everyone,
Please
Yes. You can schedule the time of Message. First go to message option and
then select the delivery option. Enter the date and time after which you
want the message to be sent and save. The message will be sent after that
time and provided your outlook is connected.
Regards,
C.G.Kumar
Could you please attach sample sheet.
Regards,
C.G.Kumar
AMW-2
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Sach1810
Sent: Wednesday, July 14, 2010 3:12 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Finding a cell
Could not understand the objective.
Regards,
C.G.Kumar
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of lucky singh
Sent: Tuesday, June 29, 2010 3:36 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Exrtact only numbers.
Hi
Kindly attach the worksheet.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of siva
Sent: Friday, May 28, 2010 3:38 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ PAID LIST TRACER
Dear Team,
Please help me . I HAVE LAST
If you have not received any solution yet, I would like to see the Sample
data worksheet.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of SLF
Sent: Monday, May 31, 2010 10:45 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$
Could you all please provide a macro which save each Sheet in a separate
worksheet as directed. Further, each time it updates the records the same
file unless otherwise new sheet has been added to the master workbook.
Regards,
C.G.Kumar
AMW-2
-Original Message-
From: excel-macros@googleg
Dear Pooja Jee,
Hope the solution provided by Dave serves the purpose.
Regards,
C.G.Kumar
From: Dave Bonallack [mailto:davebonall...@hotmail.com]
Sent: Friday, November 20, 2009 9:57 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Require help on a condition
Hi
PLZ USE V LOOKUP...
On Wed, Nov 18, 2009 at 12:48 PM, Anil Saxena wrote:
>
> Hi All
>
> Plz suggest me how to use formula like these e. g. when i written any names
> automatically put value.
>
>
>
>Anil 100 Saxena 90 Guni 80 Sonu 70 Yash 60 Thakur 50 Mathur 40
>
> --
>
> -
Just run the macro or press ctrl+g,it will do the needful you required.
Regards,
C.G.kumar
On Mon, Nov 16, 2009 at 1:23 PM, Nandkumar kakvipure <
nandkumar.hindust...@gmail.com> wrote:
> Hello
> Pls change the date format and tell me solution
> me manually nahi karsakta because 4500 customer
database it is not showing the accurate way as it should be.
> I'm attaching the complete sheet where I've tried it with more data.
> Hope you will again resolve this.
>
> Best Regards
> Pooja Sharma
>
>
> On Wed, Nov 4, 2009 at 1:05 AM, Pooja Sharma wrote:
>
.
Regards,
Pooja
On Mon, Nov 2, 2009 at 1:05 PM, Chandra Gupt Kumar
wrote:
Dear Pooja Jee,
Attached the solution. Hope it serves the purpose.
Regards,
Kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Hemant Hegde
Sent: Sunday, November
Dear Pooja Jee,
Attached the solution. Hope it serves the purpose.
Regards,
Kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Hemant Hegde
Sent: Sunday, November 01, 2009 11:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-
Hi Deepak,
You have provide good solution but when I drag the list it shows #NAME? .
Further you have used .xlfn in your formulae , may you please tell what it
is exactly and what it does.
Regards,
Kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroup
Could you please attach one example of using the function i.e. left lookup
function using the user defined function.
Regards,
C.G.Kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Paul Schreiner
Sent: Thursday, October 29, 2009 8
♫ “Let this diwali burn all your bad times and enter you in good times”
Wish you & your family very happy & joyful Deepawali...
Regards,
C.G.Kumar
--~--~-~--~~~---~--~~
--
Some imp
Dear Dilip,
I am not as good as you are. So, could you pls modify the Macro to suite
Indian Curreny i.e. Rupees (Rs) and Paisa.
Thanks
On Sun, Oct 4, 2009 at 4:58 PM, Dilip Pandey wrote:
> Hi Zaheer,
>
> Just answered this one a while ago. Check out and let me know if you
> did'nt find that e
Alternatively,
Do the following,
1. Select the column where you want to apply the date format
2. Go to >Data>Text to Coulmn>Fixed Width>Click Next>Click at the end
of date (this will insert a column break)
3. Click Next>Select from Coiumn data format Date (DMY if u like)
4. C
Used Find option.
On Tue, Sep 29, 2009 at 10:40 AM, Vikas Agarwal wrote:
> Dear All,
>
> Need a small help.
>
> Is there a way to find unique values in excel when some data is filtered.
>
> Eg:
>
> There are 1-100 rows in a particular sheet
>
> If the filter contains some 20 odd rows based on ce
Dear Member,
Monthly i take report of Sales for the previous months with respect to which
Sales Tax is payable from our database. It gives in the format
attached.Since, for filling of return, i require the sales tax payable tax
rate wise, i have to mannualy insert a column and sort it first by CST
Dear Dilip,
You provided good answer .
I have two
1. 1st possible solution based on "Identifying the rowsin earlier problem ''
leaves the first data matched as it is.
2. Could you tell how to do this in case I have two columns on named Dr and
other named Cr. Both Columns have matching figur
Dear Sonal,
I am afraid that the macro you are looking for may not be possible since
name to be matched should be identical.
If you find some solution, please let me know also.
Regards,
Kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
Dear S.Deshpande,
Saw the excel file but couldn't able to understand how you did it. Could you
plz explain ?
Regards,
Kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Swanand Deshpande
Sent: Thursday, September 24, 2009 10:4
32 matches
Mail list logo
