What is this? ? ? ?
Thanks
Ashish Pradhan
On 05-04-2012 11:27, جمال دغيدى wrote:
*Dear valued customers
*
*Please send all new value of your involvement
*
*Greetings
*
*
*
*
*
*Gamal deghady
*
*Egypt
*
*تقبلوا تحياتى *
*جمال دغيدى*
--
FORUM RULES (986+ members already BANNED for violation)
*Dear valued customers
*
*Please send all new value of your involvement
*
*Greetings
*
*
*
*
*
*Gamal deghady
*
*Egypt
*
*تقبلوا تحياتى *
*جمال دغيدى*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent,
Hi,
U can also try
="R"&A1
On Wed, Apr 4, 2012 at 2:07 AM, pawel lupinski wrote:
> Hi All,
> Can you help me with cell format I need to format it in the way that
> should change input "0204177" to "R0204177", but the difficult of my is
> that number of digit can be vary from 6 to 7. Please see
Hi Rajan,
I had a look and tried but unable to understand the codes.
The code is very heavy for me.
Can you please send a sample sheet for me.
Regards
Santosh
From: rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Prefix a pic in the userform caption
Dat
The following does not seem to work with the Sample File. All I want is a
blank line to follow after Category appears in the line above.
Ron
On Wed, Apr 4, 2012 at 3:16 PM, dguillett1 wrote:
> Option Explicit
>
> Sub InsertRowsSAS()
> Dim lr As Long
> Dim r As Range
> Application.ScreenUpdatin
Option Explicit
Sub InsertRowsSAS()
Dim lr As Long
Dim r As Range
Application.ScreenUpdating = False
lr = Cells(Rows.Count, 1).End(xlUp).Row
With Range("a2").Resize(lr)
.AutoFilter Field:=1, Criteria1:="=category*"
For Each r In .SpecialCells(xlVisible)
Rows(r.Row + 1).Insert
Next r
.AutoFilter
En
Hello Asa,
Thank you for your explanation.
Deba, also hope this website also help you.
http://www.excelfunctions.net/ExcelCellReferences.html
If that works for you, you can avoid LEFT function,
=INDEX(C$6:C$47,MAX(IFERROR(MATCH("*"&MID(TRIM(D6),2,{1,2,3,4,5,6,7,8,9})&"*",SUBSTITUTE(C$6:C$47,"
Sample File Attached
Many Thanks
Ron
On Wed, Apr 4, 2012 at 10:50 AM, vijayajith VA wrote:
> Hi Cayne,
>
> Sub rowinsertcola()
>
>
> Dim i, j, k, z, h As Long
> j = 1
> z = 1
>
>
> Range("a65356").Select
> Selection.End(xlUp).Select
>
> k = ActiveCell.Row
>
>
>
>
>For i = 5 To k + z Step
Hello Shahzad,
Also If you doesn't have always 6 digit this will extract the available
numbers (<=6 digits) If any,
=IFERROR(LOOKUP(99,--RIGHT(C2,{1,2,3,4,5,6})),"")
___
HTH, Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles.
Good One Maries :)
As you know OFFSET is volatile. A non volatile formula,
=IFERROR(INDEX($B$4:$E$4,MATCH(B$9,INDEX($B$5:$E$7,MATCH($A10,$A$5:$A$7,0),0),0)),"")
___
HTH, Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thre
Hello Arslan,
One way;
=SUMPRODUCT(SUBTOTAL(109,OFFSET(AB11,ROW(AB11:AB249)-ROW(AB11),)),--(AB11:AB249<0))
If you have more condition just add it.
___
HTH, Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, li
Hi Mohammed,
Try Below Formula with Ctrl + Shift + Enter.
=SUM((AB11:AB249<0)*SUBTOTAL(109,INDIRECT("AB"&ROW(11:249
Regards,
MARIES.
On Wed, Apr 4, 2012 at 5:20 PM, Maries wrote:
> *PFA...*
>
>
> On Wed, Apr 4, 2012 at 4:25 PM, Rajan_Verma wrote:
>
>> Use only SUubtotal(109,rng_Sum) ***
hi
i recived few "job opening emails" this week pasting few see if any
one is intrested
-
An Esteemed Client of Elixir Web Solutions is looking for Associate
Project Manager"s for Noida Location.
Y
Hi Rajan,
I need some web links for the study material of excel vba. So kindly send
me links so that I could learn vba.
With regards,
Mangesh Dayne
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgen
awesome !! Great !!!11
On Wed, Apr 4, 2012 at 10:20 AM, Maries wrote:
> Hi,
>
> PFA. Use below Array formula,
>
>
> =IFERROR(INDEX($B$4:$E$4,MATCH(B$9,OFFSET($A$4,MATCH($A10,$A$5:$A$7,0),1,1,4),0)),"")
>
> Regards,
>
> MARIES.
>
> On Wed, Apr 4, 2012 at 7:16 AM, rekha siri wrote:
>
>> Hi I
Hi Cayne,
Sub rowinsertcola()
Dim i, j, k, z, h As Long
j = 1
z = 1
Range("a65356").Select
Selection.End(xlUp).Select
k = ActiveCell.Row
For i = 5 To k + z Step 1
If (i Mod j = 0) Then
ActiveSheet.Cells(i + z, 1).Select
Selection.EntireRow.Insert
z = z + 1
End
Thanks Rajan...
On Wed, Apr 4, 2012 at 12:39 PM, Rajan_Verma wrote:
> Nice solution marries J
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Maries
> *Sent:* Apr/Wed/2012 10:20
> *To:* excel-macros@googlegroups.com
> *Subject:* Re:
---
Mangesh Dayne wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-39630eaae8-0f6e46ff2e-POa8AcgjdL8eh-GF-4az46SJV4s
You'll
Put this code in Worksheet Module, it will not work in normal module..
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mangesh Dayne
Sent: Apr/Wed/2012 06:35
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Event macro request
Hi
You should use this one
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = 0
If Target.Column = 1 And WorksheetFunction.IsNumber(Target.Value) Then
Target.Value = (Target.Value * 12) / 100
End If
Application.EnableEvents = 1
End Sub
Rajan
From:
Hi Sam,
Definitely I remember you, but just thinking about coming again in WNS.
Regards,
Kavita
On Tue, Apr 3, 2012 at 7:40 PM, Sam Mathai Chacko wrote:
> Kavita, I am looking for such a person. I'm sure you remember me from good
> old days.
>
> Regards,
> Sam
>
>
> On Tue, Apr 3, 2012 at 6:35
Assuming column 1. Filter on begins with and insert r>unfilter
‘=
Option Explicit
Sub InsertRowsSAS()
Dim lr As Long
Dim r As Range
Application.ScreenUpdating = False
lr = Cells(Rows.Count, 1).End(xlUp).Row
With Range("a2").Resize(lr)
.AutoFilter Field:=1, Criteria1:="=category*"
For Each r In
*PFA...*
On Wed, Apr 4, 2012 at 4:25 PM, Rajan_Verma wrote:
> Use only SUubtotal(109,rng_Sum)
>
> When you will apply filter it will sum only visible cells
>
> ** **
>
> Rajan.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of
Hi Rajan,
Kindly tell me where i can put above written code in vba editor.
I am trying to learn these concepts so please help me.
Thanks !!!
On Wed, Apr 4, 2012 at 6:13 PM, Sharath Sambrani <
sharath.c.sambr...@gmail.com> wrote:
> Thanks Rajan,
>
> It worked!
>
> Appreciate your quick reply.
>
Thanks Rajan,
It worked!
Appreciate your quick reply.
Cheers,
Sharath
On Wed, Apr 4, 2012 at 6:13 PM, Sharath Sambrani <
sharath.c.sambr...@gmail.com> wrote:
> Thanks Rajan,
>
> It worked!
>
> Appreciate your quick reply.
>
> Cheers,
> Sharath
>
>
> On Wed, Apr 4, 2012 at 6:01 PM, Rajan_Verma
Thanks Rajan,
It worked!
Appreciate your quick reply.
Cheers,
Sharath
On Wed, Apr 4, 2012 at 6:01 PM, Rajan_Verma wrote:
> Please try it.
>
> ** **
>
> ** **
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> Application.EnableEvents = 0
>
> If Target.Column = 1 Then
>
Please try it.
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = 0
If Target.Column = 1 Then
Target.Value = (Target.Value * 12) / 100
End If
Application.EnableEvents = 1
End Sub
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@goog
Hello Experts,
I have a quick question for you. I am looking for a event macro. Whenever
someone inputs a value in any cell under a particular column (say column A)
and hits ENTER, the value in the same cell should calculate as (Value x
12)/100.
For example, I enter a value in cell A2, the result
Hello Experts,
I have a quick question for you. I am looking for a event macro. Whenever
someone inputs a value in any cell under a particular column (say column A)
and hits ENTER, the value in the same cell should calculate as (Value x
12)/100.
For example, I enter a value in cell A2, the result
Use only SUubtotal(109,rng_Sum)
When you will apply filter it will sum only visible cells
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Muhammad Arslan
Sent: Apr/Wed/2012 05:49
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How
I am trying to use SUBTOTAL with a nested SUMIF function
like so
=SUBTOTAL(109,(SUMIF(AB11:AB249,"<0",AB11:AB249))
I only want the sum_range to sum based on a filter, and thus the SUBTOTAL.
I know this is not possible the way I have it , because it is not working,
but is it possible some other wa
HI Ron
Please find the attached sheet
Sub InsertBlankRow()
Dim rngRange As Range
Set rngRange = Range("A1").CurrentRegion.Columns(1)
rngRange.Replace "Category: ", ""
Set rngRange = rngRange.SpecialCells(xlCellTypeBlanks)
rngRange.Value = "Category: "
rngRange.Off
Ie Every time the word Category appears insert a line.
On Wednesday, April 4, 2012, Ronald Cayne wrote:
> Have a list in excel within one column
>
> Name
> Tel
> Address
> Has data or not
> Has data or not
> Category: eg "Category: Designers" This line always has the word
> "Category" on extreme
Have a list in excel within one column
Name
Tel
Address
Has data or not
Has data or not
Category: eg "Category: Designers" This line always has the word
"Category" on extreme left
Want to insert blank line after this line.
Macro to perform task. SVPACCIDENT
Thanks
Ron
--
FORUM RULES (986+ memb
Dear Friends,
Very Useful Link,
http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP010342656.aspx#BMcompatibility_functions
Regards,
MARIES.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Ple
Hi All,
thanks a lot for everyone for such quick reply, working great.
Asa, yours is the simplest I go for it, thanks a lot to all.
Thanks
Pawel
From: Asa Rossoff
To: excel-macros@googlegroups.com
Sent: Wednesday, April 4, 2012 10:20 AM
Subject: RE: $$Ex
Hi Pawel,
You can use the following number format:
\R@
That formats the cells as text and includes the leading R. Type as manby
digits as you like, including leading zeroes, and they will be preserved.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Beh
USE THIS.
Shortcut Keys - ALT+D+E>NEXT>NEXT>TEXT>GENERAL
then Cntl+1>custom>Type"\R00">OK.
Regards
Amresh
On Wed, Apr 4, 2012 at 2:13 AM, Amresh Maurya wrote:
> Hi Pawal,
>
> please find the attached solution.
>
> kindly use text to column.- ALT+D+E>NEXT>NEXT>TEXT>ENTER
>
> Regards
> A
Hi Pawal,
please find the attached solution.
kindly use text to column.- ALT+D+E>NEXT>NEXT>TEXT>ENTER
Regards
Amresh
On Wed, Apr 4, 2012 at 2:07 AM, pawel lupinski wrote:
> Hi All,
> Can you help me with cell format I need to format it in the way that
> should change input "0204177" to "R
Hi Deba,
The $ in a cell or range reference means "absolute reference". When there
is no $ it is a "relative reference". If you copy the formula to other
cells, the relative references will change and the absolute references will
remain unchanged.
You can put a $ in front of the column lette
Hi All,
Can you help me with cell format I need to format it in the way that should
change input "0204177" to "R0204177", but the difficult of my is that number of
digit can be vary from 6 to 7. Please see inside the file.
Regards,
Pawel
--
FORUM RULES (986+ members already BANNED for violation
Nice solution marries J
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Maries
Sent: Apr/Wed/2012 10:20
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need assistance in finding formula to
substitute the values to dates.
Hi,
PFA.
Hi
Please visit the link , here a procedure to do the same
http://www.pcreview.co.uk/forums/user-form-picture-caption-t967952.html
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of santosh subudhi
Sent: Apr/Wed/2012 04:19
To: excel-macros
Hi
Please find the attached sheet'
=IF(ISNUMBER(INT(RIGHT(C2,6))),INT(RIGHT(C2,6)),"")
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: Apr/Wed/2012 01:17
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Extrac
44 matches
Mail list logo
