Dear Excel Gurus,
Would require your help in completing this task. Excel attached for reference.
Thank you in advance.
Regards,
JP
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concis
Need help with a macro to:
If nothing in Column "H" do nothing
If Column "H" has a number in it (always greater than 1)
Then Highlight entire row Yellow
Then Hide entire Row
Thanks again for much needed help.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
F
Once again! Thanks so much!! Works like a charm
On Sunday, August 26, 2012 11:40:59 AM UTC-4, Don Guillett wrote:
>
> Change the lookin:XLvalues to xlFORMULAS
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguil...@gmail.com
>
> *From:* Dick
> *Sent:* Sunday, August
Thanks Don Sir
Works perfect
Rashidd
On Sunday, August 26, 2012 6:20:22 PM UTC+4, Don Guillett wrote:
>
> Put this in the sheet module and PRE format your column as TEXT
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> Dim s As String
> s = Target
> Application.EnableEvents = False
>
*Greetings!*
*
*
*I currently use the formula below to calculate the total time to complete
a task between 6AM and 7PM (13-hour workday). I need to reverse the formula
to calculate the other 11-hours in a separate column.*
*
*
*B2 = End Time*
*C2 = Start Time*
*
Total Time =MAX(0,TIME(19,0,0)-MA
*Ashish Koul,*
*
*
*Tks, its work very well.*
*
*
*i am new in this forum / vba program*
*
*
*i want to know the basic things of vba & how to construct the macros /
variables + formulas with simple examples - can you please help me in this
regards.*
*
*
*Thanks,*
*
*
*M Solaiyappan*
*
*
On Fri, Au
Change the lookin:XLvalues to xlFORMULAS
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Dick
Sent: Sunday, August 26, 2012 8:18 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Run code to also include hidden rows
Is there a way to also includ
I thought I answered this
Right click sheet tab>view code>insert this
Private Sub Worksheet_Change(ByVal Target As Range)
Dim mf As Range
If Target.Count > 1 Or Target.Column <> 3 Then Exit Sub
Set mf = Range("c1:c" & Target.Row - 1).Find(What:=Target, _
LookIn:=xlValues, LookAt:=xlWhole, SearchOr
Put this in the sheet module and PRE format your column as TEXT
Private Sub Worksheet_Change(ByVal Target As Range)
Dim s As String
s = Target
Application.EnableEvents = False
Target = Right(s, 4) & Mid(s, 3, 2) & Left(s, 2)
Application.EnableEvents = True
End Sub
Sub FixIt()’in case event macr
Hi Ashish,
Thanks a lot for this. But I was looking forward to a four quadrants. Also
does this file support more data rows?
Regards,
Sharad
On Saturday, August 25, 2012 1:59:12 PM UTC+5:30, ashish wrote:
>
> check the attachment
>
> On Thu, Aug 23, 2012 at 4:23 PM, sharad jain
> > wrote:
>
Is there a way to also include the hidden rows when running code, copy,
find, etc
This code works great but I would also like for it to copy even though the
row is hidden.
If I type the same number in Column A, BEFORE it's hidden it will copy
across. But AFTER I HIDE that row, and I enter that n
On Saturday, August 25, 2012 5:47:36 PM UTC-4, Dick wrote:
>
> Need help in creating a macro to or formula:
> Trying to stop repetative typing.
> In column "C" I have a list of different numbers/letters
> I would like to when the user types in that SAME number again, which would
> also be in col
The macro I sent you was designed to do EXACTLY that. When you enter the 8
digits they will be changed automatically to your desire. I asked you to send
me the file you TESTED and you did not do so... When you do as I requested and
tell me exactly what happens I will help you.
Don Guillett
Mi
Hello,
Don Sir I have mailed you the file on your gmail ID.
Van, your solution is ok if the entry is done as a date
We just type 8 digits like 08092012 and want to change it to 20120908
Your solution will work for a date which is already there and I was looking
to change the entry as soon as it
This formula is not working. please check the same.
=IF(IF(LEN(H6)/IF(ISERROR(FIND(10,H6)),1,FIND(10,H6))=2,1,0)=1,MID(H6,IF(ISERROR(FIND(10,H6)),1,FIND(10,H6)),2),0)
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the enviro
Hi Experts,
Extract "10" from the reference numbers by using MID Function, if "10" is
not in middle then it will show "0"
Request you to, please MID function short & easy.
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the
16 matches
Mail list logo
