Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    9
    Views
    2,479

    Re: How to post spreadsheet in forum

    Thanks Peter. I found the "unblock" box (it was UNchecked).
  2. Replies
    9
    Views
    2,479

    Re: How to post spreadsheet in forum

    I'm not sure what "unblock" means. However, I found a YouTube video which indicated I needed to add the "file path" in Excel's "Trust Center's" Trusted Locations section. I did and now the HTML Maker...
  3. Replies
    9
    Views
    2,479

    Re: How to post spreadsheet in forum

    https://onedrive.live.com/?id=8CFFDEC0CE27E813%21189&cid=8CFFDEC0CE27E813

    The file I downloaded is MrExcel HTML Maker 20170807.zip


    Does it matter that my Excel is 64-bit?
  4. Replies
    9
    Views
    2,479

    Re: How to post spreadsheet in forum

    Ok. I downloaded MrExcel HTML maker.
    In Excel, I hit ALT-T, I

    Then, browsed for the add in, added the checkbox (then OK)

    Once I leave Excel, and open Excel again, the tab for MrExcel HTML...
  5. Replies
    9
    Views
    2,479

    How to post spreadsheet in forum

    I have tried installing the various .xla file in order to copy/paste my Excel worksheets; however, I keep getting errors, mainly saying that they are incompatible with my version of Excel (version...
  6. Replies
    6
    Views
    249

    Re: With/End With statement without the dot

    Yes, I now see that it's redundant, but at least I know HOW to add it it within the WITH statement.

    Thank you for your help.
  7. Replies
    6
    Views
    249

    Re: With/End With statement without the dot

    Ah, so I have a nested With statement. I get it.

    I am curious, I Dim'd a variable, "ShNew as Worksheet", that I would like to use within the With statement to add sheets, but I cannot figure out...
  8. Replies
    6
    Views
    249

    With/End With statement without the dot

    Using Excel 365, my VBA works, but I am curious about the With/End with section. I always assumed that I needed a "." to precede my entries within a With/End With statement. Why doesn't my code have...
  9. Re: Why does assignment needed to be on LEFT-hand side?

    Thank you both! I understand it now.
  10. Why does assignment needed to be on LEFT-hand side?

    I am starting to learn VBA. On this For/Next loop, I am stumped by one line of code:
    If myValue > 400 Then Range("F" & i).Value = myValue + 10

    I get the first part: If myValue > 400 Then ...
  11. Re: Export VBA code to Word but keep color format

    Thank you. That info worked perfectly for me.
  12. Replies
    3
    Views
    226

    Re: Find MIN value among dates

    Thank you. It worked perfectly.
  13. Replies
    3
    Views
    226

    Find MIN value among dates

    I have multiple "Tickers", but with different dates. I want to find the oldest date, based upon each ticker (Column C is the end result I am looking to get).
    Note that sometimes, there is only one...
  14. Combine files from multiple workbooks into one

    Using Excel 2016, I have 20 .xlsx files which I would like to combine into one workbook. Note that each files has only one worksheet, so it should be an easy merge (I don't care about the name of the...
  15. Using SMALL function to determine smallest of groups

    I know how to use the SMALL function to determine the nth smallest figure; however, when you have a table like this, how do I determine the 3rd smallest figure from the GROUP?

    For example, if I...
  16. Replies
    0
    Views
    300

    Pivot table (Excel 2016)

    I have two tables I am trying to combine into one pivot table. The first, "Price", has (thousands of) unique symbols which will be my "key".


    <tbody>

    I
    J
    K
    L
    M
  17. "Change Data Source" Pivot Table Excel 2016

    I first Create Table (where the data is =$A:$B, incl headers).

    <tbody>

    A
    B
    C


    1
  18. Replies
    3
    Views
    230

    Re: Find sum by matching multiple criteria

    Thank you Joe4, this is exactly what I needed.

    Mark
  19. Re: How to Copy | Paste my worksheet into MrExcel.com forum (using Excel 2016)

    Thank you!
  20. Replies
    3
    Views
    230

    Find sum by matching multiple criteria

    My goal is to sum up the total Volume of a particular stock on a daily basis. The stock may be listed on one, or both, exchanges. If the Dates are the same, I want to add up both Volume totals; if...
  21. Re: How to Copy | Paste my worksheet into MrExcel.com forum (using Excel 2016)

    Well, I read it, and downloaded both "MrExcel HTML Maker (updated 2017) (Win), Forum Tools Add-In (updated 2017) ", but when I click on them, it opens Excel 2016, then that's it.

    There's no...
  22. How to Copy | Paste my worksheet into MrExcel.com forum (using Excel 2016)

    Using Excel 2016, exactly HOW do I copy the information from my worksheet into a proper Excel format in MrExcel.com?

    I have tried and, while it pastes, it does not have the Excel-type format I see...
  23. Re: How to sum up integers from multiple sources

    Thanks again, but the real list is thousands of lines, with about 6 months of dates.
    Thus, I have to "think big" and not search by entering specific dates.

    Simply put, my goal is to have the...
  24. Re: How to sum up integers from multiple sources

    Ok, I tried it and yes, it works, but only for the specific stock (in this case "A"). I should have mentioned that I have thousands of stocks I will be looking at, so I am not sure how to continue.
  25. How to sum up integers from multiple sources

    My goal is to add up the Short Volume for each stock, based on the same Stock Symbol and same date. Some stocks show on both lists, some don't. Some dates match on each list, some don't.

    I have...
Results 1 to 25 of 107
Page 1 of 5 1 2 3 4