Search:

Type: Posts; User: My Aswer Is This; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.39 seconds.

  1. Replies
    1
    Views
    31

    Re: VBA Loop if then

    I'm confused.
    You said:

    A2 in sheet Raw

    if Sheet Raw Cell B2

    Why do you say A2 then B2 ?

    And are we suppose to repeat this process all the way down to last cell in sheet raw column A...
  2. Re: How can I edit this recorded macro to include all sheets?

    Now that your saying the number of rows will not always be the same.
    Try this:

    Sub All_Sheets()
    'Modified 7/18/2019 11:57:43 PM EDT
    Application.ScreenUpdating = False
    Dim i As Long
    Dim...
  3. Re: How can I edit this recorded macro to include all sheets?

    To do all sheets try this:

    Sub All_Sheets()
    'Modified 7/18/2019 11:46:30 PM EDT
    Application.ScreenUpdating = False
    Dim i As Long
    For i = 1 To Sheets.Count
    ...
  4. Re: VBA code to copy X amount of rows from all sheets and paste to new sheet

    I was one. I had trouble running scripts with the name MM1. Running Excel 2013. I just changed the script name.
  5. Re: Excel Userform - Multiple Checkbox comments populate textbox upon clicking

    What is a CheckBox Value ??
  6. Re: Excel Userform - Multiple Checkbox comments populate textbox upon clicking

    You said:


    So there are 2 text boxes. 1 textbox would need to collect the "comments" from 4 checkboxes. Then the other textbox would need to collect the comments from the other 4 checkboxes.
    ...
  7. Re: Excel Userform - Multiple Checkbox comments populate textbox upon clicking

    So if I understand correctly.

    You want to click on one checkbox which will result in entering the same value into a section of textboxes.

    The key word here is section.

    Excel has no such...
  8. Replies
    3
    Views
    74

    Re: Copying non-blank rows

    I hope you figured it out on your own and did not get the results from another online help forum.
  9. Re: Need a VBA Macro to hide/ unhide rows based on a string in a cell value

    Glad I was able to help you.
    Come back here to Mr. Excel next time you need additional assistance.
  10. Replies
    3
    Views
    74

    Re: Copying non-blank rows

    You asked that the row be copied. But did not say where to copy it to.
  11. Re: Need a VBA Macro to hide/ unhide rows based on a string in a cell value

    If you want to choose what year then use this script:

    Sub Hide_Rows()
    'Modified 7/17/2019 9:42:18 PM EDT
    Application.ScreenUpdating = False
    Dim i As Long
    Dim Lastrow As Long
    Dim ans As...
  12. Re: Need a VBA Macro to hide/ unhide rows based on a string in a cell value

    Now if your saying you want to toggle them from hidden to not hidden use this script.


    Sub Hide_Rows()
    'Modified 7/17/2019 8:49:01 PM EDT
    Application.ScreenUpdating = False
    Dim i As Long...
  13. Re: Need a VBA Macro to hide/ unhide rows based on a string in a cell value

    Try this:

    Sub Hide_Rows()
    'Modified 7/17/2019 8:38:16 PM EDT
    Application.ScreenUpdating = False
    Dim i As Long
    Dim Lastrow As Long
    Lastrow = Cells(Rows.Count, "A").End(xlUp).Row
    For i =...
  14. Re: VBA code - check if cells in range contain same value

    I do not think you would need more then one macro to perform the task.

    Please provide specific details.

    Like the name of the defined range.
    Search for what value.

    If all values in range are...
  15. Re: Userform - add new item to combobox drop down list

    If the answer to my previous question is yes then add this script to your UserForm

    Private Sub UserForm_Initialize()
    'Modified 7/16/2019 6:05:20 PM EDT
    Dim Lastrow As Long
    Lastrow =...
  16. Re: Userform - add new item to combobox drop down list

    Please never use the term "Other Sheet" when asking for help

    Please give the name of the sheet.
    Please give the name of the ComboBox on your UserForm

    So are you saying you want to see all the...
  17. Re: Automatically take rows from one sheet to various anothers based on 2 criteria

    Well that could be done if there is something on that row which is unique that could identify that row.
    And this could get more complicated. If user enters Old into column O row is copied to both...
  18. Re: Automatically take rows from one sheet to various anothers based on 2 criterial

    It would add another row.
    My question is. Why do you not run the script by entering one of those values like Old New or Complete into column O of the Master sheet and you will see how it works.
    I...
  19. Re: Automatically take rows from one sheet to various anothers based on 2 criterial

    It will be added as a new row.

    You must have not used the script yet or you would have seen how it works.
    Have you not used it yet?
    Is this not what you want?
  20. Re: Automatically take rows from one sheet to various anothers based on 2 criterial

    So assuming it now works.
    Glad I was able to help you.
    Come back here to Mr. Excel next time you need additional assistance.
  21. Re: Automatically take rows from one sheet to various anothers based on 2 criterial

    So tell me what happened when you ran the script.
    Did you get a error code?

    So to run the script you needed to enter Old New or Complete in column O
  22. Re: VBA Macro shortcut to "paste special formula"

    So you have code that does not work and you want us to incorporate our code into your code?
    And you have not shown us your formula. That would be hard for me to do.
  23. Re: VBA Macro shortcut to "paste special formula"

    My question would be:
    What Range do you want to sum and where do you want the results entered.

    If your going to use Vba why copy the formula?

    Vba can just put the results of the formula in a...
  24. Re: Automatically take rows from one sheet to various anothers based on 2 criterial

    Try this:

    This is an auto sheet event script
    Your Workbook must be Macro enabled
    To install this code:
    Right-click on the Master sheet tab
    Select View Code from the pop-up context menu
    Paste...
  25. Re: Automatically take rows from one sheet to various anothers based on 2 criterial

    In your original post you said:

    Each time we add a new row to the master the row of data needs to be moved to 1 or multiple sheets depending on criteria.

    But in your last posting you said:
    And...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4