# Search:

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

Page 1 of 6 1

1. ## Thread: Auto populate holiday tracker from year planner

by jeffreybrown
Replies
2
Views
187

### 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. ## Thread: Drop down list linked to Worksheets

by jeffreybrown
Replies
12
Views
641

### 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. ## Thread: Carry Over Data from Previous Row

by jeffreybrown
Replies
1
Views
197

### 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. ## Thread: Sum formula

by jeffreybrown
Replies
13
Views
520

### 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. ## Thread: Turning Multiple Columns into a Single Column

by jeffreybrown
Replies
3
Views
536

### 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. ## Thread: Dynamic Vlook up

by jeffreybrown
Replies
7
Views
191

### Re: Dynamic Vlook up

Since the initial question has been asked and answered, please start a new thread for this new question.
7. ## Thread: Dynamic Vlook up

by jeffreybrown
Replies
7
Views
191

### 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. ## Thread: Dynamic Vlook up

by jeffreybrown
Replies
7
Views
191

### 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. ## Thread: Dynamic Vlook up

by jeffreybrown
Replies
7
Views
191

### 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. ## Thread: VBA UDF return multiple results

by jeffreybrown
Replies
6
Views
289

### 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. ## Thread: VBA UDF return multiple results

by jeffreybrown
Replies
6
Views
289

### 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. ## Thread: VBA UDF return multiple results

by jeffreybrown
Replies
6
Views
289

### Re: VBA UDF return multiple results

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

Weird!
13. ## Thread: VBA UDF return multiple results

by jeffreybrown
Replies
6
Views
289

### 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. ## Thread: VBA to fill formula until last row

by jeffreybrown
Replies
4
Views
149

### 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. ## Thread: Learning macro

by jeffreybrown
Replies
2
Views
368

### Re: Learning macro

This could be a start...

https://www.mrexcel.com/forum/general-excel-discussion-other-questions/614277-learning-vba.html
16. ## Thread: Dynamic range for VLookup

by jeffreybrown
Replies
3
Views
208

### 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. ## Thread: Dynamic range for VLookup

by jeffreybrown
Replies
3
Views
208

### 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. ## Thread: Hide rows based on multiple cell content in row

by jeffreybrown
Replies
27
Views
516

### 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. ## Thread: Counting duplicates in a list according to dates

by jeffreybrown
Replies
17
Views
872

### Re: Counting duplicates in a list according to dates

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

by jeffreybrown
Replies
27
Views
516

### 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. ## Thread: Counting duplicates in a list according to dates

by jeffreybrown
Replies
17
Views
872

### 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. ## Thread: Lookup to find first non-blank cell

by jeffreybrown
Replies
5
Views
388

### Re: Lookup to find first non-blank cell

x-posted

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

23. ## Thread: Combining two subroutines

by jeffreybrown
Replies
11
Views
369

X-Post
24. ## Thread: Line Graph dropping to zero

by jeffreybrown
Replies
9
Views
8,539

### 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. ## Thread: Line Graph dropping to zero

by jeffreybrown
Replies
9
Views
8,539

### 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