Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.15 seconds.

  1. Re: Auto populate holiday tracker from year planner

    Rule #13 :
    We prefer that members do not cross-post questions to other forums, but when this does occur members should do the following:
    - Post the details of your question on our forum. Do NOT...
  2. Replies
    12
    Views
    630

    Re: Drop down list linked to Worksheets

    Rule #13 :
    We prefer that members do not cross-post questions to other forums, but when this does occur members should do the following:
    - Post the details of your question on our forum. Do NOT...
  3. Replies
    1
    Views
    193

    Re: Carry Over Data from Previous Row

    Rule # 13 :
    We prefer that members do not cross-post questions to other forums, but when this does occur members should do the following:
    - Post the details of your question on our forum. Do NOT...
  4. Replies
    13
    Views
    516

    Re: Help with sum formula

    Rule #13 :
    We prefer that members do not cross-post questions to other forums, but when this does occur members should do the following:
    - Post the details of your question on our forum. Do NOT...
  5. Re: Turning Multiple Columns into a Single Column

    Hello lillosca & Welcome to the Forum,

    Since this thread is a couple of years old, it's probably best if you post a new thread with your specific question.
  6. Replies
    7
    Views
    185

    Re: Dynamic Vlook up

    Since the initial question has been asked and answered, please start a new thread for this new question.
  7. Replies
    7
    Views
    185

    Re: Dynamic Vlook up

    Then you need to establish the end of that data set. Let's say you know column B is the end of the data set.


    Sub Macro1()
    Dim LR As Long
    LR = Range("B" & Rows.Count).End(xlUp).Row
    ...
  8. Replies
    7
    Views
    185

    Re: Dynamic Vlook up

    As an example...


    Sub Macro1()
    Range("J1:J37").FormulaR1C1 = "=VLOOKUP(RC[-1],C[-9]:C[-7],3,0)"
    End Sub
  9. Replies
    7
    Views
    185

    Re: Dynamic Vlook up

    The best way to get a formula in VBA is to write it on the spreadsheet first. Get it to work and then...

    Turn on the macro recorder >> select the cell with the formula >> hit the tab key >> turn...
  10. Replies
    6
    Views
    287

    Re: VBA UDF return multiple results

    Awesome, that worked. I could only get the "ConsolidateList" UDF to work, but got me where I needed to be. Thanks.
  11. Replies
    6
    Views
    287

    Re: VBA UDF return multiple results

    I know there isn't any problems with the protections or macros as this macro runs perfectly fine in a new workbook.

    As for the textjoin or a similar UDF, I'm not all that savy with any other...
  12. Replies
    6
    Views
    287

    Re: VBA UDF return multiple results

    I tried that also, but it makes the cell with the UDF turn out as #VALUE !

    Weird!
  13. Replies
    6
    Views
    287

    VBA UDF return multiple results

    I've used this UDF for many years to return all matched results and it works fine. On this one particular workbook it does not immediately return the results until I go to the source tab and...
  14. Replies
    4
    Views
    147

    Re: VBA to fill formula until last row

    Or...


    Sub enter_formulas()
    Dim LR As Long: LR = Range("A" & Rows.Count).End(xlUp).Row
    Range("S7:S" & LR).Formula = "=CONCATENATE(AB7&""-""&T7&""-""&V7&""-""&AD7&""-""&AE7)"
    End Sub
  15. Replies
    2
    Views
    362

    Re: Learning macro

    This could be a start...

    https://www.mrexcel.com/forum/general-excel-discussion-other-questions/614277-learning-vba.html
  16. Replies
    3
    Views
    203

    Re: Dynamic range for VLookup

    I think you explained yourself ok, except for the part where you tell us, are you using a straight worksheet formula or VBA?

    I read you are working with a worksheet formula.

    1) Create a named...
  17. Replies
    3
    Views
    203

    Re: Dynamic range for VLookup

    I'm not sure if you are talking about VBA code here or in a worksheet formula.

    For a worksheet formula you will need to create a dynamic named ranges and for code you will have to find the last...
  18. Re: Hide rows based on multiple cell content in row

    Have you tested the macro in post # 4 with the sample data in post # 6?

    Does the macro run fine or as expected?

    I ran the code posted in # 4 against your small sample data in # 3 and everything...
  19. Re: Counting duplicates in a list according to dates

    Thanks Fluff, this is perfect. Now if only I can understand it. :)
  20. Re: Hide rows based on multiple cell content in row

    You reference L158:L183, but what is the range you need to evaluate. All of column A because we can't use L?


    Sub Hide_Unhide_0300()
    Dim Rng As Range
    Dim cell As Range
    Set...
  21. Re: Counting duplicates in a list according to dates

    Hello Mick,

    Using the macro in post # 8, can it be modified to achieve the results below?

    Data Range

    A
    B
    C
  22. Replies
    5
    Views
    379

    Re: Lookup to find first non-blank cell

    x-posted

    Answer provided at: http://www.msofficeforums.com/search.php?searchid=233299

    Please read: https://www.excelguru.ca/content.php?184
  23. Replies
    11
    Views
    350

    Re: Combining two subroutines

    X-Post
  24. Replies
    9
    Views
    8,088

    Re: Line Graph dropping to zero

    As the samples show, if the date has yet to occur, then why graph it. It's zero.
  25. Replies
    9
    Views
    8,088

    Re: Line Graph dropping to zero

    If the above approach is what not what you need, maybe you are looking for a dynamic chart that will grow as your data grows.

    See...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4