please check attachment its allowing to input only DD/MM/ or DD-MM/,
if still you face problem then change DOB column in Text format from General
or date
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rupesh Patil
Sent: Friday, March 14, 2014 11:
Dear Ravinder,
I have learnt lot from you. you have help me before.
this time you have give awesome formulas for mobile and email column.
just one query DOB Column don't accepts any date format, I have entered
30-09-1986 or 09/30/1986 format but not accepted, am I doing something
wrong
On Thu
Hi E J try this...
Sub testing()
Dim rng As Range
Dim rcount As Long
Dim cel As Range
rcount = Sheets(1).Cells(Rows.Count, "c").End(xlUp).Row
Set rng = Sheets(1).Range("c1:c" & rcount)
For Each cel In rng
If cel <> cel.Offset(1, 0) And cel <> "" Then
cel.Offset(1, 0).Selec
PFA, just select first complete row
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of E J
Sent: Friday, March 14, 2014 4:03 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ additional row creation
Hi Everyone,
I was wondering if I cou
Hi Everyone,
I was wondering if I could get help with a macro. I'm trying to write a
macro (with no luck) that walks down a column based on the initial
placement of the active cell. Every time there are two cells with different
data it adds two (or N rows). It doesn't, however, view blank cel
Hi Everyone,
I was wondering if I could get help with a macro. I'm trying to write a
macro where the macro walks down a column of data based on where I
initially highlight the active cell. If the data in two consecutive cells
are different it adds 2 rows (or N rows). I've attached an example o
Hi Team,
I need a help in creating a macro for attached Excel File in E Mail.
Process Brief:-
1) I have one excel file. In that excel file, there is one column named as
"Branch Name". Which is important us to find out Branch Name and that
particular
branch details should be create as Separat
Obrigada Ricardo.
Muito legal a planilha, mas a minha dúvida é que quando adiciono um
hyperlink em uma das suas celulas da pasta 1, a pasta 2 não atualiza a
mesma celula, adicionando o hyperlink automático.
*Att. Caroline Campos (21) 8102-4893*
*Preserve o Meio Ambiente*
*Por favor, pense e
Pfa. try this may be you like...I have put data validation till 20th row you
can increased as per your requirement.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rupesh Patil
Sent: Thursday, March 13, 2014 9:49 AM
To: excel-macros@googlegroups.com
Subje
Dear All,
Waiting for the same.
Dear All,
Thanks for reply..
MY question is
when I use the Dynamic Range then output of Avg Response time is coming but
it is not applicable to Resolution.
Why this happen ..?
Please explain
Regards,
Prafull Jadhav
9920553518
On 12 March 2014 20:10, Pra
10 matches
Mail list logo
