Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. 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. 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. 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. 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. 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. 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. 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. Replies
    2
    Views
    308

    Re: Countif not working in a table

    Ah!! it worked!
  9. 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. 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. 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. 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. Re: How to use relative reference in a formula using vba

    People like you deserve Nobel Prizes!
  14. 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. 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. 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. Re: Using a macro to refresh Investran OLE DB reports using specific parameters

    Bumping this topic
  18. 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. 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. 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. 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. 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. Re: Coloring every other row gray troubleshooting

    omg silly mistake.
  24. 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. Replies
    1
    Views
    148

    Re: Every other column gray

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