Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.28 seconds.

  1. Re: Sum data range if a cell in the column is blank

    Maybe Sub totals function

    https://www.dummies.com/software/microsoft-office/excel/how-to-insert-subtotals-in-an-excel-2010-worksheet/
  2. Replies
    2
    Views
    19

    Re: VBA VLookup Help Please

    http://www.cpearson.com/excel/CallingWorksheetFunctionsInVBA.aspx
  3. Replies
    2
    Views
    37

    Re: Change font color and style

    Sub Change_FontColor()


    Set MyPlage = Range("NamesList")
    Application.ScreenUpdating = False
    For Each cell In MyPlage
    Select Case cell.Value


    Case Is = "Alex"
  4. Replies
    2
    Views
    96

    Re: Listing Data based on Dates

    Using Power Query/Get and Transform, here is Mcode


    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column2", type...
  5. Re: delete that entire row if column d has duplicates data

    After the last line of code before End Sub insert the following lines


    ActiveWorkbook.Save
    ActiveWorkbook.Close
  6. Re: delete that entire row if column d has duplicates data

    I am confused by your response. In your first post you ask to have the duplicate deleted. Now are you saying you want to save the duplicate to a new file? You are not clear in your explanation. ...
  7. Re: delete that entire row if column d has duplicates data

    Sub DeleteDuplicateRows()
    '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
    ' DeleteDuplicateRows
    ' This will delete duplicate records, based on the Active Column. That...
  8. Re: VBA code for find keyword in column E if found, change font color in matching B column cell

    Option Explicit
    Option Compare Text


    Sub tkbaty()
    Dim i As Long, lr As Long
    lr = Range("E" & Rows.Count).End(xlUp).Row
    Application.ScreenUpdating = False
    For i = 1 To lr
    ...
  9. Re: convert time to fractions 1/24/ 2/24 etc

    Leza,

    I took the list of hours as shown above. In the format section converted the time to a number (second item in format dropdown). I then converted the number to fraction (from dropdown the...
  10. Re: Obtaining sets of data that fall on a specific date or withing a specific date range.

    A Pivot Table will do exactly what you want.


    v
    A
    B
    C
    D
    E
    F
  11. Replies
    11
    Views
    193

    Re: Autofill dates for specified year

    Here is an alternative solution:


    Option Explicit


    Sub AutoDateFill()
    Dim x As Date
    Dim rn As Long
    Dim cn As String, sn As Long
  12. Replies
    15
    Views
    340

    Re: WorksheetFunction

    Show us some sample data. Macros are specific to your data. Explain your situation using the sample data. Your explanation is far to vague and we cannot see your data layouts. Help us to help you...
  13. Replies
    15
    Views
    340

    Re: WorksheetFunction

    Instead of trying to amend someone else's code that doesn't work, suggest you tell us what issues you are having and let us provide you with a solution that is designed specifically for you.
  14. Re: Code merge data of multiple sheets in one sheet

    Because you are asking for it to update with every change, I have difficulty with providing any kind of code. With PQ, you only have to select the Refresh button on the Ribbon to update the output. ...
  15. Re: Code merge data of multiple sheets in one sheet

    This is a perfect case for Power Query/Get and Transpose. Look at the links in my signature block for further understanding how this works.
  16. Replies
    3
    Views
    130

    Re: Retrieve live data from index fund

    Look at this link. I use this to get stock prices on a daily basis. Not sure if it supports Canadian stocks.
    ...
  17. Re: VBA code already there in brand new file

    Or when you open the VBE, is the Funcres file showing codes.
  18. Re: delete entire column based on color of top cell vba

    Conditional formatting cannot be read by VBA. What you should do is provide information for the basis of creating a conditional format. Then applying that condition to determine which columns...
  19. Replies
    1
    Views
    59

    Re: VBA Row Lock

    https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/146584-locking-rows-from-editing
  20. Replies
    4
    Views
    110

    Re: Data to change from Columns to Rowns

    Data Range

    A
    B
    C
    D

    1
    Cust ID
    Attribute
  21. Replies
    13
    Views
    2,098

    Re: NHL.com website; How to get tables into PQ

    Can you click on the little arrow in left side of the yellow folder? This will open the table list.
  22. Replies
    13
    Views
    2,098

    Re: NHL.com website; How to get tables into PQ

    I clicked on PQ and retrieve from Web and was able to load two tables. They were listed as Table 6 and Table 7. Not sure what issues your were having.
  23. Re: Merging Multiple Text Files into One Excel Sheet

    Show us a couple of lines of data from each file and then what the changes you need to make. Difficult to provide any viable solution without seeing what your data looks like.
  24. Replies
    10
    Views
    140

    Re: delete rows across multiple tabs

    ok. When you get the message, click on Debug and tell us which line of code is highlighted. Without this diagnostic, I have no idea what the issue is. This code was untested as you have not...
  25. Replies
    10
    Views
    140

    Re: delete rows across multiple tabs

    Sub Delete_Rows_ISN3()
    Dim ws As Worksheet
    Dim lRow As Long
    Dim iCntr As Long
    lRow = 390
    For Each ws In Worksheets
    For iCntr = lRow To 1 Step -1
    If...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4