Search:

Type: Posts; User: jim may; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.38 seconds.

  1. Re: Excel opens blank book along with existing file

    I didn't read the article I referenced, it just looked like on the surface as an article providing a great amount of detail on the subject.
    Unless it has changed the default excel template file...
  2. Re: Excel opens blank book along with existing file

    This might help...

    https://docs.microsoft.com/en-us/office/troubleshoot/excel/files-open-automatically
  3. Re: Get address of cell with conditional formatting in VBA

    Are you using a formula within your conditional formatting set up window? If so, what is the formulatext?
  4. Re: Code Not sending email when worksheet range is changed

    Have you tries STEPPING-THROUGH the code (using the F8 Key) and during the process determining what happens (as you go).
    Is an Error Produced after you run the code, or does just "nothing happen"?
  5. Replies
    4
    Views
    172

    Re: Convert Worksheet Name to Date in a Cell

    Should work for next 80 years, till year 2100 when formula needs updating to 21 from 20. LOL!!
    THANKS for your REPLY.
    Jim
  6. Replies
    4
    Views
    172

    Re: Convert Worksheet Name to Date in a Cell

    Paste this code into the code window of your ThisWorkbook Object
    Then on a selected blank cell Double-Click it. HTH, Jim



    Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal...
  7. Replies
    6
    Views
    302

    Re: Sumif (or return) numbers or text

    Excel 2010
    <tbody>

    A
    B
    C


    1
  8. Replies
    1
    Views
    391

    How to delete a posting

    I tried deleting a post - near the bottom (while within the time limit given) I see the button to EDIT, there in a tool tip I see "DELETE" also offered. So how do I follow through on Deleting, not...
  9. Re: Help Please - a simple question i believe!

    My post went out prematurly. What I was tryig to establish was If in uour Input Sheet you have a numeric in the August Column, row 2
    then on your summary sheet row 2 would change from Fcast to...
  10. Re: Help Please - a simple question i believe!

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF ;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px"...
  11. Re: Help Please - a simple question i believe!

    In your displayed Summary if your "Act" cell under Jun is the cell address is A2 -- what is in this cell? A value or a Formula
    Same question as to the first F'cast under Aug - cell reference C2 -...
  12. Re: Anything Look strange with this - using in Office 365 = It is Displaying $0.00 but shouldn't

    The Problem is LIKELY that Column M contains multiple text - and I need only those row that contain anywher in the M Cell either the text "Settlement" or "Card Credit".
  13. Anything Look strange with this - using in Office 365 = It is Displaying $0.00 but shouldn't

    <tbody>
    =SUMPRODUCT((YTD_GOOG_2019_CyberSource!$A$5:$A$500='Monthly Recons-Google'!C$4)*((YTD_GOOG_2019_CyberSource!$M$5:$M$500="Settlement")+(YTD_GOOG_2019_CyberSource!$M$5:$M$500="Card ...
  14. Re: Can I create a "Button" on a sheet that only becomes visible in the month of Jun?

    Maybe something like this...



    Private Sub Worksheet_Activate()
    'ActiveX button
    dYear = Year(Date) 'your systems currrent year
    If Date >= DateSerial(dYear, 6, 1) And Date <= DateSerial(dYear,...
  15. Re: Can I create a "Button" on a sheet that only becomes visible in the month of Jun?

    Paste below code in your June Code Sheet (Code below currently reads Sheet1). Currently assumes your Command button to be named "CommandButton1". You will only need to edit it each year to update...
  16. Replies
    0
    Views
    118

    Switching Pivot Table Data Sources

    My PT isn't updating after switching my data sources. It might be that my Pivot Cache isn't updating.
    If I go into my immediate Window (VBE) what one-line statement can I type to Update my Cache?...
  17. Re: Index Match Across Multiple String Criteria

    Excel 2010
    <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>

    A
    B
    C
    D
    E
    F
    G
  18. Re: Link cell in new worksheet to another cell in source worksheet. They are in different workbooks

    [QUOTE=JSH720;5266216]Unfortunately, that is not working. ???

    What is produced in the cell ? Show exactly what's happening..
  19. Replies
    5
    Views
    171

    Re: Minimum Value of 1.00 in Cell

    Use Data Validation in your cell(say cell A1), Custom - Formula =A1>0
  20. Re: Link cell in new worksheet to another cell in source worksheet. They are in different workbooks

    To create the link I'd start with both workbooks OPEN. Just start with the "=" then Point to or select the cell you wish to link to in the Other Workbook, and then CLICK OK.
  21. Replies
    5
    Views
    280

    Re: Looking for basic formula advice

    Use INDEX() accompanied by the Match()
  22. Re: Error: unable to get the match property of the worksheet function class

    Welcome to Mr Excellll

    Revisit this part of your code line...

    Worksheets("Shet1")
  23. Replies
    4
    Views
    154

    Re: VBA macro Text Filters -> Contains

    Let's Start here...

    Paste the below code in the code window of your BASE worksheet.



    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Address = "$P$4" Then...
  24. Replies
    11
    Views
    350

    Re: Beginner Seeking Help

    Are you wanting to DELETE Column of Row 10 Only?
  25. Replies
    3
    Views
    152

    Re: Copy Formulas with Name Ranges

    Not Sure, But could you select (highlight) the area involved and then go to the Menu
    Home tab, Find, Select - there do a:
    Replace...
    Find What? Replace With

    Oil.Volume.3 ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4