# Search:

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

Page 1 of 2 1

1. ## Thread: Insert Rows Based on criteria (or CountIf?)

by hutch27
Replies
10
Views
349

### Re: Insert Rows Based on criteria (or CountIf?)

Great, this one seems to be working as intended - I appreciate the quick follow up and I hope I was clear with my explanations!
2. ## Thread: Insert Rows Based on criteria (or CountIf?)

by hutch27
Replies
10
Views
349

### Re: Insert Rows Based on criteria (or CountIf?)

To answer your last question, yes, I would only want it to look to row 300.

However, it seems the code is not working properly. I re-tested it and am able to confirm that the number of rows added...
3. ## Thread: Insert Rows Based on criteria (or CountIf?)

by hutch27
Replies
10
Views
349

### Re: Insert Rows Based on criteria (or CountIf?)

I believe this function of the code is deriving an answer from the Summary Tab - how would i change it so that the answer counts all values > 0 on the Data tab?
4. ## Thread: Insert Rows Based on criteria (or CountIf?)

by hutch27
Replies
10
Views
349

### Re: Insert Rows Based on criteria (or CountIf?)

Sorry,

After re-reading my initial question I may have been a little too vague on my request. Let me try re-phrasing again!

I have two tabs, a summary tab and a data tab. The Summary Tab is...
5. ## Thread: Insert Rows Based on criteria (or CountIf?)

by hutch27
Replies
10
Views
349

### Insert Rows Based on criteria (or CountIf?)

Hello,

I have two tabs, a summary tab, and a Data Tab. The Data Tab is organized like this (from rows 2 to 300 - with each person having a different number in Column E).

<tbody>
Column B...
6. ## Thread: How to question: Break External Links ONLY on specific tabs

by hutch27
Replies
0
Views
118

### How to question: Break External Links ONLY on specific tabs

As the title reads, i'm looking to see if there is code to break external links only on specific tabs in a workbook. I have found a few codes on this forum, however, they all break external links in...
7. ## Thread: Break All External Links only on specific sheet

by hutch27
Replies
0
Views
141

### Break All External Links only on specific sheet

Hi, i have this code that i've been tinkering around with - i'm trying to have it work so that it removes all external links only on a specific tab (Summary Tab). Am i headed in the right direction...
8. ## Thread: Countif not working in a table

by hutch27
Replies
2
Views
308

### Re: Countif not working in a table

Ah!! it worked!
9. ## Thread: Countif not working in a table

by hutch27
Replies
2
Views
308

### Countif not working in a table

So I have a table in which i'm trying to add a check to see if any values in the last column of this table return a value of "FALSE" (it's worth mentioning that this "FALSE" is not strictly text -...
10. ## Thread: Using VBA to Print standardized documents from different file paths

by hutch27
Replies
0
Views
127

### Using VBA to Print standardized documents from different file paths

Hi,

I have a question that i'm hoping someone has a solution for.

Suppose an investor owns 3 companies:

Company A
Company B
Company C.
11. ## Thread: IF column "I" contains certain text, move to cell below and replace the original cell with "Total"

by hutch27
Replies
3
Views
144

### Re: IF column "I" contains certain text, move to cell below and replace the original cell with "Total"

Sorry - I messed up my question a little bit:

Here are my criteria:

Column "I" contains only one instance of the word "Final Difference (after factoring in Distributions/Withholding Taxes...
12. ## Thread: IF column "I" contains certain text, move to cell below and replace the original cell with "Total"

by hutch27
Replies
3
Views
144

### IF column "I" contains certain text, move to cell below and replace the original cell with "Total"

Hi all,

So I'm stuck with getting my cut/paste vba to work as well as a separate question. Here are my criteria:

Column "I" contains only one instance of the word "Final".
Need to cut/paste...
13. ## Thread: How to use relative reference in a formula using vba

by hutch27
Replies
3
Views
241

### Re: How to use relative reference in a formula using vba

People like you deserve Nobel Prizes!
14. ## Thread: How to use relative reference in a formula using vba

by hutch27
Replies
3
Views
241

### How to use relative reference in a formula using vba

Hello -

I'm using an If-Then function in vba to insert a formula into specific cells based on the function. However, I'm having trouble with vba using an absolute rather than relative reference....
15. ## Thread: IF column C contains value, then populate column G

by hutch27
Replies
3
Views
178

### Re: IF column C contains value, then populate column G

Got it - thank you.

The first portion of the code is running fine, however, the second portion (moving the cell 1 up) is getting the Application defined or object defined error. Any insight on...
16. ## Thread: IF column C contains value, then populate column G

by hutch27
Replies
3
Views
178

### IF column C contains value, then populate column G

Hi all -

As the title reads, if column C contains certain text, then populate column G with specific text. Additionally, move the newly created text in column G up 1 cell. I'm getting the code to...
17. ## Thread: Using a macro to refresh Investran OLE DB reports using specific parameters

by hutch27
Replies
1
Views
528

### Re: Using a macro to refresh Investran OLE DB reports using specific parameters

Bumping this topic
18. ## Thread: Using a macro to refresh Investran OLE DB reports using specific parameters

by hutch27
Replies
1
Views
528

### Using a macro to refresh Investran OLE DB reports using specific parameters

Hello all,

I work as a fund accountant in the private equity industry and we rely heavily on Investran OLE DB reports for financial data. To best ask my question I think I should give a scenario:...
19. ## Thread: Beginner VBA question

by hutch27
Replies
3
Views
522

### Re: Beginner VBA question

Something is wrong when applying it to mine and I'm looking at your code to try and figure it out. There's two things that aren't working: 1) the order ID's arent matching & 2) the amounts arent...
20. ## Thread: Beginner VBA question

by hutch27
Replies
3
Views
522

### Beginner VBA question

I have an "orders" and "results" worksheet and am having trouble with the code.

<tbody>
The "Orders" worksheet contains the info about order date, customer identification & order amount. Since...
21. ## Thread: Beginner VBA quesetion

by hutch27
Replies
1
Views
301

### Re: Beginner VBA quesetion

This is the second code and this isn't working either

Option Explicit

Sub LargeOrder()

Dim cell1 As Range
22. ## Thread: Beginner VBA quesetion

by hutch27
Replies
1
Views
301

### Beginner VBA quesetion

I have an "orders" and "results" worksheet and am having trouble with the code.

<tbody>
The "Orders" worksheet contains the info about order date, customer identification & order amount. Since...
23. ## Thread: Coloring every other row gray troubleshooting

by hutch27
Replies
2
Views
216

### Re: Coloring every other row gray troubleshooting

omg silly mistake.
24. ## Thread: Coloring every other row gray troubleshooting

by hutch27
Replies
2
Views
216

### Coloring every other row gray troubleshooting

So, I have titles from from B1-M1 and row descriptions from A2-A41. I want to color every other row (B3:M3, B5:M5, B7:M7, ect..) gray.

I applied conditional formatting "=MOD(ROW(),2)=1" and ran...
25. ## Thread: Every other column gray

by hutch27
Replies
1
Views
148

### Re: Every other column gray

Nevermind, problem solved
Results 1 to 25 of 33
Page 1 of 2 1