Search:

Type: Posts; User: James006; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.11 seconds.

  1. Re: Reference Multiple Sheet Names on one sheet

    Hi,

    It looks like you need to create your Sheets Index ...

    see : https://www.extendoffice.com/documents/excel/3176-excel-create-sheet-index.html#a1

    Hope this will help
  2. Re: Sumproduct with Multiple Rows and Columns

    Have you tried to Insert a Pivot Table ...?
  3. Replies
    6
    Views
    115

    Re: [VBA] Set a shortcut key for "Copy Format"

    What do you call :

    the usual mouse-click / mouse-double-click function of "Copy Format"
  4. Thread: Sending mail

    by James006
    Replies
    7
    Views
    162

    Re: Sending mail

    I know pretty well Ron's code ... since have been using it for years ...

    The question is Office 365 ... and the SMTP server ...
  5. Re: How to find and SUM Multiple Column Data by two criteria?

    You are welcome
  6. Re: Need a [VBA] code which show a Pop Box in Excel if condition is meet.

    You are welcome :smile:
  7. Re: Need a [VBA] code which show a Pop Box in Excel if condition is meet.

    Hi,

    Live data might require you to test another event Worksheet_Calculate() ...

    Hope this will help
  8. Re: VBA Code - Sort by Custom List Reference

    Hi,

    Since you have added your Custom List to all available lists ... you could test following modification:


    CustomOrder:=Application.CustomListCount + 1

    Hope this will help
  9. Replies
    6
    Views
    115

    Re: [VBA] Set a shortcut key for "Copy Format"

    Hi,

    Sorry ... do not understand you remark ...

    If you need to repeat a Copy Format you have just made ... you can use the function key F4
  10. Replies
    9
    Views
    137

    Re: Summarize data with multiple criteria

    Hi,

    Have you tried to Insert a Pivot Table ...?
  11. Replies
    6
    Views
    115

    Re: [VBA] Set a shortcut key for "Copy Format"

    Hi,

    You can record your own macro ... and give it the shortcut you want ...
  12. Re: How to find and SUM Multiple Column Data by two criteria?

    Hello,

    With your table located in range A1:F7, you can have following Array Formula:

    =SUM(IF(B1:F1="w",OFFSET((B1:F1),MATCH("A",A2:A7,0),0),0))

    Hope this will help
  13. Thread: Sending mail

    by James006
    Replies
    7
    Views
    162

    Re: Sending mail

    You are in for a trial and error phase ...

    Maybe your firewall is not letting you access the SMTP server

    You should review your firewall configuration
  14. Re: Sumproduct with Multiple Rows and Columns

    Hi,

    What is you expected result ... ???
  15. Thread: Sending mail

    by James006
    Replies
    7
    Views
    162

    Re: Sending mail

    Hello,

    You should take a look at following link:

    https://www.tachytelic.net/2018/12/email-vbscript-vba-office-365/

    Hope this will help
  16. Replies
    1
    Views
    70

    Re: Date formula needed

    Hi,

    As long as January is located in A1, February in A2, etc ...

    In your sheet ' Summary ', in cell B10, you can following Array Formula:


    =SUM(IF(MONTH(Sheet1!$D$1:$E$2)=ROW(),1,0))

    to...
  17. Re: sort two columns, one from each of two sheets

    Just turn on your macro recorder ... and go once through your process ...

    You will get a good starting point ...

    Hope this will help
  18. Replies
    1
    Views
    58

    Re: Create a Calculated Field.

    Hello,

    To learn how to add a calculated field, take a look at Debra's excellent site :

    https://www.contextures.com/excel-pivot-table-calculated-field.html

    Hope this will help
  19. Replies
    1
    Views
    58

    Re: Automatic Rolling Months

    Hello,

    To add n months to a given date ... you can use

    =Edate(yourdate, n )

    Hope this will help
  20. Replies
    5
    Views
    146

    Re: Change Coulour if gender is female

    Hi,

    You do need to have each name in a cell ...

    If your constraint is to keep your current sheet as it is ....

    Then you can replicate on a new tab you current sheet ... and generate clean...
  21. Replies
    2
    Views
    125

    Re: Template to be save in simple worksheet.

    Hello,

    If I understand your request ... you need to Copy Paste Values which can be performed as file is saved as new file ...

    Hope this will help
  22. Replies
    6
    Views
    128

    Re: adding date using date() function

    For sure ... problem is solved ...:smile:
  23. Re: opying into cells if particular criteria is met

    Hello,

    You should take a look at AutoFilter ...

    Hope this will help
  24. Replies
    6
    Views
    128

    Re: adding date using date() function

    Hi,

    You could test

    = Edate(A1,12)

    Hope this will help
  25. Replies
    3
    Views
    113

    Re: Error In Expiry Date Formula

    You are welcome :smile:
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4