For summing col 5,6,7 i enclose the code. verify. do it for sny no. of
sheets.the code follows:Sub sum567()
Dim LastRow As LongDim iRow As LongDim iCol As IntegerLastRow = 0
For iCol = 5 To 7 iRow = Cells(65536, iCol).End(xlUp).Row If iRow > LastRow
Then LastRow = iRowNext iCol
With Applicatio
Hi,I give u the following code you can run and get what u expect. For the next
time u have to change the j value(i.e.,columnvalue,A=1 B=2 etc) to 6 to 7, and
next time this should be 8 to 9.Or if u don't mind in over printing the data,u
can put j value = 4 to 33.It is upto u.Here the row is fixe
Hi,I enclose which may solve ur request.
From: Kat
To: MS EXCEL AND VBA MACROS
Sent: Wednesday, February 3, 2016 6:28 AM
Subject: $$Excel-Macros$$ compare columns through for loop
Hi all,
I would like to compare columns in two workbooks. If data from column D in
fortest1.xlsx a
Hi,
If you want in columns, say a1,b1,c1 etc use the following fomula(which I
learned from this site) and drag it (UPTO Z).
=MID(ADDRESS(1,COLUMN()),2,1)
-r.karunanithi.
On Friday, May 9, 2014 1:20 PM, Amit Desai (MERU)
wrote:
Dear Abhishek,
This worked perfectly fine. Thanks a lot.
Hi,
Keep the cursor in A1 and run the following code. Here I put the autofill 'C'
column and you will get the required result.
File also enclosed.
Sub autofill()
Do While ActiveCell <> ""
ActiveCell.Offset(0, 2).FormulaR1C1 = ActiveCell.Offset(0, 0)
ActiveCell.Offset(1, 0).Select
Hello, what is to be autofill. can u give what is in a1 to a5 and
what is to be autofilled in b1 to b5
-r.karunanithi.
On Saturday, May 10, 2014 6:20 AM, Bill Q wrote:
I have spent the better part of 40 minutes searching the web for what I believe
is a simple solution. I have found many answ
Hi,
Use 'End of month' formula and add 720or whatever number of months to find
the date of retirement.(Usually retirement happens at the last day of the month)
- r.karunanithi.
On Wednesday, February 19, 2014 4:29 PM, "prabhakar_k...@sify.com"
wrote:
thanks its working fine
On Tuesday, Febr
Sirs,
I want to fill down Sim card numbers around 5 lacs each contain 19 digits
and the sims have numbers from one value to another, in sequence for 5 to
10,000.
I split this to 3 or 4 columns and then idea to concatenate. The numbers in
sequence
is highlighted in yellow.Using a macro i can m
duct not working in vba -reg.
Dear Karunanithi,
Pl forward those files I'll see and get back to you later.
Warm Regards,
Gawli Anil
On Wed, Feb 6, 2013 at 11:32 AM, karunanithi ramaswamy
wrote:
Dear Gawli Anil,
> Thank you very much for your timely help. The formula work
@googlegroups.com; era_...@yahoo.com
Sent: Tuesday, February 5, 2013 12:05 PM
Subject: Re: $$Excel-Macros$$ $$excel-$$ sumproduct not working in vba -reg.
Dear Karunanithi,
Pl find attached herewith required data.
Warm Regards,
Gawli Anil
On Fri, Feb 1, 2013 at 4:56 PM, karunanithi ramaswamy wrote
Sir,
I have data of Station and category in columns a and b. But I want the
report
in category wise as in columns h to k. When i use the sumproduct formula it
works
and it is not working in vba. Please guide how to modify the vba to get the
desired
result.(formula used is available in the
Hi,
Pl see the attached sheet.(you can also find the days between two dates)
-R.Karunanithi.
From: MRafique Ujjan
To: excel-macros@googlegroups.com
Sent: Monday, November 26, 2012 4:48 PM
Subject: $$Excel-Macros$$ How to calculate Joining Date from a given
Hi,
If year,month,days are in A1,A2,A3 respectively then put the date on which
you want to calculate in A4,
enter the formula in A5(the joining date,if it is one complete spell,
=Date(Year(A4)-(A1),Month(A4)-(A2),Days(A4)-(A3))
R.Karunanithi
From: MRafiqu
Hi,
One way is finding the matching cells, by copying sheet3 in sheet1 and run the
program.In column "H" Available are matching cells.Then filter
the blanks selecting upto 14 rows. you will get what you want.
- Karunanithi R
From: Prabhu
To: excel-macros@goo
xt R
Application.ScreenUpdating = True
tStop = Timer
tMin = Int((tStop - tStart) / 60)
tSec = Round((tStop - tStart) - (tMin * 60), 2)
Debug.Print tStop & "-" & tStart & " " & tMin & ": " & tSec
MsgBox tMin & ": " & tSec
End Sub
Paul
---
Dear Expert Paul Schreiner,
"Thank you" for your remarks. After correcting the"spaces" into "0",it
works.
-R.Karunanithi.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accu
attached sheet.
Jaysheel.
On Wed, Apr 11, 2012 at 11:48 PM, Rajan_Verma wrote:
Please attached file
>
>Rajan.
>
>From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
>Behalf Of karunanithi ramaswamy
>Sent: Apr/Wed/2012 11:17
>To: excel-macros@goog
@googlegroups.com
Subject: Re: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO
DATES
Hi,
Please find the attached sheet.
Jaysheel.
On Wed, Apr 11, 2012 at 11:48 PM, Rajan_Verma wrote:
Please attached file
Rajan.
From:excel-macros@googlegroups.com [mailto:excel-macros@g
sir,
I have list of staff with dates of retirement. I want to extract the staff
who retire between 5/1/2012 and 5/31/2012.
I want the vba code to do this.
thank u in advance.
Karunanithi R
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
Sir,(All forum members)
Re: $$Excel-Macros$$ REG:$$Column to table formula Now working
It is fine.Working well.Thank you very much for your timely help and guidence.
Karunanithi R
From: Sourabh Salgotra
To: excel-macros@googlegroups.com
Sent: Wednesday, March
Sir,
It is happy to see the desired result. But after typing the formula I pressed
with ctrl+shift+enter,I dont get the result.
Is there any other procedure? Please help in detail.
Thank you very much.
-Karunanithi R
91-9486100934.
From: Sourabh Salgotra
To: e
explanation.
Don
Guillett
Microsoft MVP Excel
SalesAid
Software
dguille...@gmail.com
From: karunanithi ramaswamy
Sent: Tuesday, March 27, 2012 12:34 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ REG:$$Column to table formula not
working
Sir,
About 4 to 6 months back, in theis
Sir,
About 4 to 6 months back, in theis Forum Someone(may be Siti or so) has given a
formula to convert a column to table.
i.e., =Row(A1)*3-(3-Column(A1)) this works fine when A1 to A100 is 1 to 100.
But not with 10 digit cell phone number
data. Can any one suggest any formula or vba.(i am usin
ot; FUNCTIONS IN VBA-REG
Yes you can Use this function in VBA like this
WorksheetFunction.Replace(parameters)
Right(parameters)
From:excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of karunanithi
ramaswamy
Sent: Thursday, August 18, 2011 2:31 PM
To: excel
PLACE" FUNCTIONS IN VBA-REG
Dear karunanithi,
Please try below VBA Function..and see attached sheet..
Function use_cbt(s As Range)
use_cbt = Application.WorksheetFunction.Substitute(s, "CB", "CBT")
End Function
On Thu, Aug 18, 2011 at 2:30 PM, karunanithi ramaswa
Hi,
I am using some vba to filter some data related with station code, such as
AVN,CBAVN,CBEAVN,CBTAVN
all the four meas the same station, but used in different software. Here, my
job is I have to collect the data in
any one of the formate say CBAVN in any column and then replace them to CB
Mr Santhosh,
your formula put 1 in A2,1 IN A3,2 IN A4,AGAIN 1 IN A5,3 IN A6.
i.e., REQUIRED NUMBERING FILLED IN EVEN CELLS, AND ODD CELLS HAVE 1
AM I RIGHT?
R.KARUNANITHI
--- On Sat, 7/9/11, santosh bahuguna wrote:
From: santosh bahuguna
Subject: Re: $$Excel-Macros$$ Numbering
To: excel-mac
Hi,
here is a macro u can apply which works well.
Sub test32()
Dim LastRow As Long
Dim j As Long
LastRow = Cells(Rows.Count, "A").End(xlUp).row
k = LastRow
For j = k - 1 To 4 Step -1
If Worksheets("Sheet1").Cells(k, 1).Value =
Worksheets("Sheet1").Cells(j, 1).Value Then
Worksh
Hi,
Please try this macro. This macro will give reference of numbers that matches
in D column
i have inserted two columns in bwtween) with col A and also "true" and also a
ref of A column
next to D column. Confirm actualy what u want.(i have added 4or 6 numbers for
examble)
--R.Karunanithi
Sub
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 wrote:
From: ashish koul
Subject: Re: $$Excel-Macros$$ help regarding date formula
To: excel-macros@googlegroups.com
Date: Thursday, July 7, 2011, 11:26 AM
use
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 wrote:
From: L.K. Modi
Subject: $$Excel-Macros$$ help regarding date formula
To: excel-macros@googlegroups.com
Date: Th
HI,
APPLY THE MAX FORMULA AT A4 AND CLICK THE FILL HANDLE AND DRAG.
=MAX(A2:C2)
DOUBTS IF ANY CONTACT.
-R.KARUNANITHI
--- On Wed, 7/6/11, satish wrote:
From: satish
Subject: $$Excel-Macros$$ Help for Excel query
To: "MS EXCEL AND VBA MACROS"
Date: Wednesday, July 6, 2011, 2:31 AM
Hi,
HI,
I AM INTERESTED TO KNOW HOW TO AUTO FILL A 4X4 MAGIC SQUARE FOR ANY
SUM WITH NO NUMBER REPEATS FROM A SERIES OF NUMBERS.
THANKS IN ADVANCE
-R.KARUNANITHI,2/7/2011.
--
--
Some important links for excel users:
1
Sir,
Do u have any idea of auto filling magic squre for a particular sum total.
Iam interested
to know it. Thanks if u could help.
-R.Karunanithi
--- On Sat, 7/2/11, Rajan_Verma wrote:
From: Rajan_Verma
Subject: RE: $$Excel-Macros$$ Urgent Help required!!
To: excel-macros@googleg
34 matches
Mail list logo