Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: Delete rows if cell value is greater than a specific time

    something in the column other than a date?
    In which row start data?
  2. Re: Close all ComboBox dropdowns when I click a button.

    If you select a cell, does the dropdown close?
  3. Re: Excel formula to update values for specific columns only

    You can play a little with a pivot table and check if the result is what you need.

    http://tedata.blob.core.windows.net/uploads/md/ad569729a1c18165f521172fcf4febc1.jpg
  4. Replies
    1
    Views
    39

    Re: ThisWorkbook Question

    If the sheet occupies position 2 of your sheets then simply:



    ThisWorkbook.Sheets(2).Range("B11:X180")
  5. Re: Extracting numbers before and after spaces

    Try:

    <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...
  6. Replies
    1
    Views
    50

    Re: IF function with cursor move

    Welcome to the forum!

    Put the following macro in sheet events



    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    If Not Intersect(Target,...
  7. Re: VBA MACRO TO Keep duplicates BASED ON CONDITION (Remove duplicate if the duplicate count of a particular id is greater 12 times

    Welcome to the forum.

    Please coment:
    - In which row the data starts
    - In which column are the dates
    - in which column are the Id's
  8. Re: Copy several cell values into another workbook based of the criteria

    Try this.
    I assume that the header row of the source sheet begins in row 1, if it is another row, then change the value 1.



    Sub Copy_into_another_workbook()
    Dim w2 As Workbook, s1 As...
  9. Replies
    1
    Views
    84

    Re: How do I highlight duplicated data

    In your example, which row do you want to delete 14 or 25?
    And what should the macro do if it has more than 2 duplicate rows?
  10. Re: Cell address locating by text or value in a cell with address formula in a multiple columns data set

    How about:

    <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...
  11. Re: Filter Table save as new workbook in same folder

    The result is a single book?
    Or do you want a book for each manager?
    It is not clear to me. You could give an example of what you have on each sheet and what you expect from the result in the new...
  12. Replies
    3
    Views
    85

    Re: Relace and Delete Question!

    Youre welcome!
  13. Replies
    3
    Views
    85

    Re: Relace and Delete Question!

    If you want to delete the rows.
    - Select column
    - Autofilter
    - Fiter = 456
    - Now select all rows filtered
    - Press right mouse click on any cell of a selected row
    - In the menu select delete row.
  14. Re: Count number of months per year between two dates

    Please note:

    https://www.excelguru.ca/content.php?184
  15. Re: VBA Help - If Cell Contains Partial String Then.......

    sorry, typo error



    If InStr(1, Cell.Offset(0, 2), "P Card") > 0 Then
  16. Re: VBA Help - If Cell Contains Partial String Then.......

    try without wildcard



    If InStr(1, Cell.Offset(0, 2), "P Card) > 0 Then
  17. Replies
    2
    Views
    85

    Re: VBA - Open PDF file

    Try:



    Sub test() ActiveWorkbook.FollowHyperlink "C:\Users\i ' M\Desktop\PDF\test file 123-234.pdf"
    End Sub
  18. Re: Formatting a label caption as "$##,###.##"

    Try:



    Budget = " " & Format(ws.Cells(SelectedRow, 34).Value, "$##,###.00")
  19. Re: Inserting Character From End of String

    If you want the result in the same column, we can use Rick's formula in the following macro.
    The code assumes that the data begins in row 2.



    Sub Add_Dot()
    With Range("A2", Range("A" &...
  20. Replies
    14
    Views
    201

    Re: Loop through data and create formulas

    I'm glad to help you. Thanks for the feedback.
  21. Re: vba to add fields to pivot table, needs work

    The error is new, or did you already have it from the beginning?
  22. Replies
    14
    Views
    201

    Re: Loop through data and create formulas

    try



    Sub Macro1()
    Dim Obj As Object, t As String, i As Long, col As Long, n As String, ini
    Application.AutoCorrect.AutoFillFormulasInLists = False
    For i = 3 To 5
    Set Obj =...
  23. Re: vba to add fields to pivot table, needs work

    I really don't know how to hide the fields, all I did was put your code in a cycle.
    But you must fine tune it with a table and then adjust it in the cycle.
  24. Replies
    9
    Views
    232

    Re: sort all sheets

    But in the "Template (2)" sheet In column A you have the formula =totals!A11
    But in column B there are no formulas.
    Then it is not to sort the data. I believe that you must regenerate all the data...
  25. Re: Delete rows if cell value is greater than a specific time

    In column D you must have date and time, example:

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