Use this in D4
=DATE(YEAR(C4),MONTH(C4)+1,5)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of L.K. Modi
Sent: Thursday, July 07, 2011 10:26 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ help regarding date formula
Dear Members,
*
hi L K modi use this formula in d4
=EOMONTH(C4,0)+5
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Jul 7, 2011 at 11:29 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Use this in D4*
* my pleasure
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Wed, Jul 6, 2011 at 7:04 PM, Idhrees Mohamed idhrees...@gmail.comwrote:
Dear Ankur,
Its working fine. Thank you very much.
Regards,
Idhrees.
On
*
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Wed, Jul 6, 2011 at 6:05 PM, ankur ankurpande...@gmail.com wrote:
*hi ashish sir
may this help u ...
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
*HI VASANT
thanks a lot
code is working fine in my main data file... this is what i needed
u had saved my time and efforts..
thnks again
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Jul 7, 2011 at 12:42
*dear friends
plz check the attached file for changing the text case of selected range
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Jul 7, 2011 at 10:23 AM, anandydr anand...@gmail.com wrote:
Dear STDEV(i),
THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS
REGARDS
LKMODI
On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi ca.mod...@gmail.com wrote:
Dear Members,
Me attaching a sheet which relates to Excise duty payment.The result should
be 5 of the next of the month of Invoice.We are
Hello Team,
I am preparing chart basis certain data. However wanted to check some
way to prepare the chart only on the data which reflect in the excel
sheet post i do a filter. So as soon as I change the filter the chart
should change.
Do let me know if that can be done.
Cheers
Atul
--
*ok sir
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Jul 7, 2011 at 11:44 AM, L.K. Modi ca.mod...@gmail.com wrote:
THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS
REGARDS
LKMODI
On Thu,
chart only represent the data of visible cells if you hide any rows or
will apply filter it will show the data of visible cells only
check the attachment choose any name u will see the chart will automatically
change
if it is not working as per the default setting .
*hi atul
dynamic chart preparation can help
have a look link below
http://chandoo.org/wp/2009/02/12/make-a-dynamic-chart-using-data-filters/
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Jul 7, 2011 at 12:11
See if it help
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Atul Kesaria
Sent: Thursday, July 07, 2011 12:11 PM
To: excel-macros
Cc: atul.kesaria
Subject: $$Excel-Macros$$ Help on Chart
Hello Team,
I am preparing chart
Hi
Have a photo in a comments box in Database.xls. Also have a vlookup in
another workbook Shipment-New.xls to bring forward the text from the cell
into
the wb. This works great. I also want to bring forward the comment box
in the same cell from Database.xls into Shipment-New.xls.
Would
Hi,
u use this
=DATE(YEAR(C4),MONTH(C4)+1,5)and drag the fill handle down till c4 is not
blank.
u will get what u want.
R.Karunanithi.
--- On Thu, 7/7/11, L.K. Modi ca.mod...@gmail.com wrote:
From: L.K. Modi ca.mod...@gmail.com
Subject: $$Excel-Macros$$ help regarding date formula
To:
hi,
the betterr is
=DATE(YEAR(C4),MONTH(C4)+1,5)
because he wants 'next month' 5th.
R.Karunanithi
--- On Thu, 7/7/11, ashish koul koul.ash...@gmail.com wrote:
From: ashish koul koul.ash...@gmail.com
Subject: Re: $$Excel-Macros$$ help regarding date formula
To: excel-macros@googlegroups.com
Hi,
It's a pivot chart in your sheets its taking references from Pivot Table ,
when you will apply filter in Pivot table it will Show Only Filter Summary
Data,
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Atul Kesaria
Sent:
Hi Rajan,
I would be doing filter not on the pivot table...but on the data in
the sheet 1 which should reflect in the chart and the table.
Cheers
Atul
On 7/7/11, Rajan_Verma rajanverma1...@gmail.com wrote:
Hi,
It's a pivot chart in your sheets its taking references from Pivot Table ,
when
Hello :
Note that the macro should be in the Shipment-New.xls workbook :
Sub CopyComments()
Dim Rg As Range, C As Comment
Dim Sh As Worksheet, x As Range
Set Sh = Workbooks(Database.xls).Sheets(Sheet1)
With Sheets(Sheet1)
For Each Rg In .Range(.[J12], .Cells(.Rows.Count,
Dear Friends,
I have a BOQ(Bills of Quantity) and I need to add a formula to each rate.
The formula should be as follow.
=rate*(Constant cell reference)
For an example;
The rate on cell E18 is 250.00 (see attached BOQ)
It should like this after run the macro
'=250*($H$1)
It need to repeat for
Hi,
The data is not displaying in the below code which has written for pivot.
Please let me know where is the error is.
Thanks in advance
Sub pivot_table()
Dim pvt_ch As PivotCache
Dim pvt_tbl As PivotTable
Dim rng As Range
Set rng = ThisWorkbook.Worksheets(Formatdata).UsedRange
Set pvt_ch =
Hi Experts,
Could you please look into my excel query. I have the multiple columns
filled with some Revenue values. I need the first month when the revenue
started flowing in (anything which is greater than 0).
For example – for the Account Name: Mohan, We started recognizing the
revenue from
Thanks a lot Rajan. But the below macro is not running in Excel 2003 or any
reference need to select from Tools. Please confirm.
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00 01.
Ph- +91-80-4144 6339 / 6340
Pls find a UDF
Public Function GetFirstRevenueDate(Rng As Range)
For Each cls In Rng.Cells
If cls.Value 0 Then
Dt = Cells(1, cls.Column)
GetFirstRevenueDate = Format(Dt, dd-mmm-)
Exit Function
End If
Next
End Function
File attached.
On Thu, Jul 7, 2011 at 10:05 PM, AK exce...@gmail.com
Yes Rajan, the code is calling a procedure in
Call bulkUpload.GenerateReport
The procedure has not been included.
Could you please include that also ?
On Thu, Jul 7, 2011 at 10:45 PM, Chidurala, Shrinivas
shrinivas.chidur...@citi.com wrote:
Thanks a lot Rajan. But the below macro is not
Hi,
C2 copy down.
=IFERROR(INDEX(D$1:SF$1,MATCH(TRUE,INDEX(ISNUMBER(1/D2:SF2),),0)),Not
Started)
HTH
Haseeb
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Please attached corresponding data
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: Thursday, July 07, 2011 8:15 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Pivot Issue
Hi,
The data is not displaying in the
Try this Function in C2
Function GetStartDate(RevRange As Range) As Variant
Dim cell As Range
For Each cell In RevRange
If cell.Value 0 Then
GetStartDate = Cells(1, cell.Column).Value
Exit Function
End If
Next
End
Please Remove that Line From the Code. It will work fine..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vasant
Sent: Thursday, July 07, 2011 11:04 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Convert HTML file to Excel
=INDEX($1:$1,0,SMALL(IF(D2:AB20,COLUMN(D2:AB2),),1))
press ctrl +shift+ enter
check the attachment
On Fri, Jul 8, 2011 at 12:31 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Try this Function in C2*
* *
*Function GetStartDate(RevRange As Range) As Variant*
*Dim cell As Range*
*
Hi Ankur,
this is FANTASTIC. thanks a lot.
From: ankur ankurpande...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tue, 5 July, 2011 12:16:06 PM
Subject: Re: $$Excel-Macros$$ copy data without opening file
check this also
one sample file and explanations is given
thanks rajan. this is really great. i didnt know abt this. thanks again
From: Rajan_Verma rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tue, 5 July, 2011 12:53:47 PM
Subject: RE: $$Excel-Macros$$ copy data without opening file
No, We cant Copy the data from Closed
Hi Daniel
Thanks for code. Have done as you suggest and installed in the Shipments
wb. When I run the code it goies thru to var =... and gives a
message that ' variable not defined ' .
Is there something missding ?
Your help appreciated.
Thanks
Charlie
On Fri, Jul 8, 2011 at
Dear Members,
Thanks for your valuable support. I have an querry in which i have to check
interest calculation for banks.
Me attaching a sheet in which column A have date that is in different
format. and in column B the balance as on the respective dates.
As the bank charges interest on the
add this code to new workbook and run the macro and choose the csv file
Option Compare Text
Sub swa()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim s As Workbook
Dim i, j, k As Long
Set s = Workbooks.Open(Application.GetOpenFilename)
j = 1
For i = 1 To
hi
check the attachment see if it helps
On Fri, Jul 8, 2011 at 10:09 AM, L.K. Modi ca.mod...@gmail.com wrote:
Dear Members,
Thanks for your valuable support. I have an querry in which i have to check
interest calculation for banks.
Me attaching a sheet in which column A have date that
HOPE THIS MIGHT BE USEFUL.
On 8 July 2011 10:09, L.K. Modi ca.mod...@gmail.com wrote:
Dear Members,
Thanks for your valuable support. I have an querry in which i have to check
interest calculation for banks.
Me attaching a sheet in which column A have date that is in different
format. and
Thanks Ashish
Thanks Ankur
On Thu, Jul 7, 2011 at 11:51 AM, ankur ankurpande...@gmail.com wrote:
*
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Wed, Jul 6, 2011 at 6:05 PM, ankur ankurpande...@gmail.com
Thanks Vasant, Haseeb, Rajan and Ashish for your solution .. you guys are
Master !
Regards,
AK
On Fri, Jul 8, 2011 at 5:39 AM, ashish koul koul.ash...@gmail.com wrote:
=INDEX($1:$1,0,SMALL(IF(D2:AB20,COLUMN(D2:AB2),),1))
press ctrl +shift+ enter
check the attachment
On Fri, Jul 8, 2011
38 matches
Mail list logo