Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    4
    Views
    198

    Re: Please help to identify unique values

    Im glad to help you, thanks for the feedback.
  2. Re: How to save macro workbook to a new workbook as xls with same formats

    save the file as a normal xlsx file
  3. Re: need help filter all years date data and delete except current year

    I don't have 365 I suggest you create a new thread.
  4. Re: How to include file names while merging multiple files through VBA

    This already worked for you?
  5. Replies
    17
    Views
    364

    Re: Update Chart SourceData in dynamic range

    Youre welcome!
  6. Re: is there a way to make a pivot table show only negative values *in all fields* ?

    an idea: in an auxiliary column, put the formula if the min (of all the columns in that row) is> = 0, then 1, otherwise 0. add the auxiliary column to the pt and filter the 1.
  7. Re: Excel VBA How to Coply excel columns into NotePad

    What is the ultimate goal of taking it to notepad?
  8. Re: Amend an Find Replace macro to offset the results column

    Im glad to help you. Thanks for the feedback.
  9. Re: VBA or formula to run a look up based on a cell value

    Im glad to help you. Thanks for the feedback.
  10. Replies
    12
    Views
    303

    Re: Filter cells and emial filter result

    you must answer the questions I asked in posts #2 , #4 #8
  11. Replies
    17
    Views
    364

    Re: Update Chart SourceData in dynamic range

    Of course. Try this please.



    Sub ChartData1()
    Dim lr As Long
    lr = Columns("A:G").Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row
    ...
  12. Re: VBA Code for Searching Data in Multiple Sheets

    Do you have any reference to know which sheet to look for or should you search on all sheets?
  13. Re: Excel VBA How to Coply excel columns into NotePad

    If you only need the 3 columns in a txt file:



    Sub Macro2()
    Application.ScreenUpdating = False
    Application.DisplayAlerts = False
    Columns("A:C").Copy
    Workbooks.Add
    ...
  14. Re: Formula for when a number is greater than or less than by a certain value

    I'm glad to help you. Thanks for the feedback.
  15. Re: Excel VBA How to Coply excel columns into NotePad

    Try this please:



    Sub Copy_into_NotePad()
    Dim lr As Long
    lr = Sheets("Copied Summary").Range("A" & Rows.Count).End(xlUp).Row
    Sheets("Copied Summary").Range("A1:C" & lr).Copy
    Shell...
  16. Replies
    3
    Views
    161

    Re: Help me stop hurting myself or others

    A longer option:


    The sheet in question must be protected.
    Create a userform with a combo to display open books and a button.


    It would work like this, the user would execute the userform...
  17. Re: Formula for when a number is greater than or less than by a certain value

    Do you need something like this?

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold;...
  18. Re: Excel VBA How to Coply excel columns into NotePad

    Try this



    Sub Copy_into_NotePad()
    Dim lr As Long
    lr = Range("A" & Rows.Count).End(xlUp).Row
    Range("A1:C" & lr).Copy
    Shell "notepad.exe", vbNormalFocus
    SendKeys "^V"
  19. Re: How to Reference ONE cell from ALL Pivot Tables in a Workbook - VBA

    I'm glad to help you. Thanks for the feedback.
  20. Replies
    17
    Views
    364

    Re: Update Chart SourceData in dynamic range

    Youre welcome.
  21. Re: Paste several worksheets into one worksheet

    Hi @★ mmclaug143 and welcome to the forum!

    What changes did you make or what do you need to adjust in the code?


    Note: Deleted lines are not necessary:
  22. Re: VBA to email selected range in body of email and add the same selected range as an attachment

    Try this



    Sub Mail_Selection_Range_Outlook_Body()
    'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm
    'Don't forget to copy the function RangetoHTML in the module.
    'Working...
  23. Replies
    4
    Views
    198

    Re: Please help to identify unique values

    I put you 2 options, the first option writes the first cell as unique. The second option writes the last cell as unique. Choose the best option for you.


    <table border="1" cellspacing="0" ...
  24. Replies
    17
    Views
    364

    Re: Update Chart SourceData in dynamic range

    It is very weird, my version of Excel is 2007. Hopefully if someone with version 2016 can review what is happening.
  25. Re: Make UDF based on multiple Match-criteria

    Try this


    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4