Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.62 seconds.

  1. Replies
    173
    Views
    384,263

    Re: VBA Delete Entire Row if Contains Certain Text

    moramramesh,

    We can not tell what worksheet(s), cells, rows, columns, your raw data is in.

    And, we can not tell what the results should look like.

    You could improve your chance of getting...
  2. Replies
    7
    Views
    160

    Re: Deleting specific rows with VBA

    Mr2017,

    Here is another macro solution for you to consider.




    Sub DeleteColumnB_N()
    ' https://www.mrexcel.com/forum/excel-questions/1113838-deleting-specific-rows-vba.html
    Dim Addr As...
  3. Replies
    1
    Views
    107

    Re: can you recommend scraping addons?

    indigo,

    See if the following link will help you:

    https://www.mrexcel.com/forum/excel-questions/1015000-reflections2-web-scraping-sharing-some-code-knowledge.html
  4. Thread: Formula

    by hiker95
    Replies
    7
    Views
    424

    Re: Formula

    handysmurf,

    Nicely done. Glad that you were able to figure it out.

    Have a great day, and, come back to MrExcel anytime.
  5. Replies
    12
    Views
    575

    Re: Loop through data and build an array

    2077delta,

    Your link to your workbook is not working?

    We would like to see what your raw data workbook/worksheets look like, and, we would like to see what the resulting worksheet, manually...
  6. Replies
    12
    Views
    575

    Re: Loop through data and build an array

    2077delta,

    Try this next link, Reply #2 :

    https://www.mrexcel.com/forum/about-board/508133-attachments.html
  7. Replies
    12
    Views
    575

    Re: Loop through data and build an array

    2077delta,

    We can not tell what worksheet(s), cells, rows, columns, your raw data is in.

    And, we can not tell what the results should look like.

    Can you post a screen shot of what your data...
  8. Re: VBA: Extracting multiple strings from cells onto multiple columns.

    Thanks for that.


    Try the following link, reply #2:

    https://www.mrexcel.com/forum/about-board/508133-attachments.html
  9. Re: VBA: Extracting multiple strings from cells onto multiple columns.

    JMudd,

    Welcome to the MrExcel forum.

    We can not tell what worksheet(s), cells, rows, columns, your raw data is in.

    And, we can not tell what the results should look like.

    Can you post a...
  10. Replies
    4
    Views
    324

    Re: Financial Planning Worksheet

    rparedes,

    Section B at this link has instructions on how to post a screen shot: https://www.mrexcel.com/forum/board-...forum-use.html

    Alternately, you could upload a copy of your file to a free...
  11. Replies
    10
    Views
    778

    Re: Delete Row based on cell value

    esmecat,

    Can you post a screen shot of what your data looks like?

    Section B at this link has instructions on how to post a screen shot: https://www.mrexcel.com/forum/board-...forum-use.html
    ...
  12. Re: Find a text within a cell and return a text in the adjacent column using VBA

    colaps,

    Thanks for the feedback.

    You are very welcome.

    And, come back to MrExcel anytime.
  13. Re: Find a text within a cell and return a text in the adjacent column using VBA

    colaps,

    The latest macro will adjust to the number of entries in worksheet S1, in column E, E2 to the last used row in column E.
  14. Re: Find a text within a cell and return a text in the adjacent column using VBA

    colaps,

    Here is a new macro solution for you to consider, that will run in worksheet S1.

    Please try the following macro on a copy of your raw data workbook.




    Sub FindFamily_V2()
  15. Re: Find a text within a cell and return a text in the adjacent column using VBA

    colaps,

    Here is a macro solution for you to consider, that will run in worksheet S1.

    Please try the following macro on a copy of your raw data workbook.




    Sub FindFamily()
  16. Re: what is the best course to learn about excel and vba?

    dpaton05,

    Thanks for the feedback.

    You are very welcome, and, come back to MrExcel anytime.
  17. Re: Find a text within a cell and return a text in the adjacent column using VBA

    colaps,

    1. What version of Excel, and, Windows are you using?

    2. Are you using a PC or a Mac?

    We can not tell what worksheet(s), cells, rows, columns, your raw data is in.

    And, we can not...
  18. Re: what is the best course to learn about excel and vba?

    nivo11,

    Thanks for the feedback.

    You are very welcome.
  19. Replies
    4
    Views
    483

    Re: Where should i start to learn Excel

    nivo11,

    See if something, in the below link(s), of my most up to date list will help you:

    Training / Books / Sites as of 6/3/2019
    ...
  20. Re: VBA Delete entire row if any cell in column c contains "mania" or "beverly hills polo" or "calvin"

    bwaaack,

    We can not tell what worksheet(s), cells, rows, columns, your raw data is in.

    And, we can not tell what the results should look like.

    Can you post a screen shot of what your data...
  21. Re: VBA Delete entire row if any cell in column c contains "mania" or "beverly hills polo" or "calvin"

    bwaaack,

    Here is another macro solution for you to consider that does not do any looping in the rows in the active worksheet, in column C, and, should be very fast.

    I assume that you have...
  22. Replies
    7
    Views
    363

    Re: Need help matching data

    RoccoM83,

    Welcome to the MrExcel forum.

    1. What version of Excel, and, Windows are you using?

    2. Are you using a PC or a Mac?


    To start off, and, so that we can get it right on the first...
  23. Replies
    10
    Views
    778

    Re: Delete Row based on cell value

    esmecat,

    You are very welcome.

    Glad I could help.

    And, come back to MrExcel anytime.
  24. Replies
    10
    Views
    778

    Re: Delete Row based on cell value

    esmecat,

    Welcome to the MrExcel forum.

    1. What version of Excel and Windows are you using?

    2. Are you using a PC or a Mac?


    Here is a Macro solution for you to consider, that does not do...
  25. Replies
    15
    Views
    595

    Re: Sheet1 Not running

    8700Rakf,

    In order to assist you it would help us if you posted all of your macro code using code tags.

    When posting VBA code, please use Code Tags - like this:




    Paste your code here.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4