Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Formula/macro/VBA to match top 5 outstanding amounts to an offset name.

    Omigosh. Thank you! It works perferctly.

    Is this a stupid question? Can you explain the formula entered into AB2? I am always trying to learn new formulas/functions/macros/VBA in excel, but I'm...
  2. Formula/macro/VBA to match top 5 outstanding amounts to an offset name.

    <colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
    Hello all. I have a head banger issue. Any and all help is a greatly appreciated.
  3. formula to enter a % based on a word that appears in a cell

    Hi all

    I can't even begin to determine how to approach what I would like to happen. Can I use a formula or should I use code?

    I have an Inv # in col "A" and a Description in col "I".
    I also...
  4. Re: VBA to copy a closed workbook range to the currently open workbook

    I figured out a solution - see below.

    [CODE]/
    Sub CopyGLdetail()
    '
    ' CopyGLdetail Macro
    '


    '
  5. VBA to copy a closed workbook range to the currently open workbook

    I am trying to write a code to copy a range from a closed workbook to the current open workbook.

    The closed workbook is the source data. .../GLDetail-ICSales.xlsx"

    The current open workbook...
  6. Re: VBA Coding or macro to pull out sum for a specific account and vendor

    Thank you KWeaver.

    The VBA coding works perfectly.

    I appreciate your input!
  7. Re: VBA Coding or macro to pull out sum for a specific account and vendor

    So, I tried to clean up the report to give you a better picture of what I am trying to get to. I didn't include the account number 4114-04.
    I inserted a row between each account number.
    Row 1...
  8. VBA Coding or macro to pull out sum for a specific account and vendor

    Hello to all

    I'm not sure how to approach this problem.

    This first table is the end result I am looking for.

    The data I pull down from my accounting system is in the second table below. It...
  9. Replies
    11
    Views
    210

    Re: VBA with sumif syntax issues

    You're wonderful. Thank you!
  10. Replies
    11
    Views
    210

    Re: VBA with sumif syntax issues

    Oh, I just realized that my sumifs is only picking up the first account number value and not adding all the accounts together.

    Basically, the totals for the following cells should be:
    G6 I should...
  11. Replies
    11
    Views
    210

    Re: VBA with sumif syntax issues

    Thank you so much. It works now.
  12. Replies
    11
    Views
    210

    Re: VBA with sumif syntax issues

    Sorry for the bother but I am still getting errors with the sumif formulas. Below is the following:
    1. code for sumifs
    2. result of formula inserted into cells
    3. formulas entered into the cells...
  13. Replies
    11
    Views
    210

    Re: VBA with sumif syntax issues

    Is there a certain keystroke I need to use for the curly brackets (CTRL-Shift-Enter) or just select the {}brackets?
  14. Replies
    11
    Views
    210

    VBA with sumif syntax issues

    Hello

    I did my best to post using everything suggested but this is the best I can do.
    Here is a spreadsheet I am trying to work with.
    It is basically up to 200 rows and using columns A:H.
    I am...
  15. Replies
    6
    Views
    190

    Re: VBA - row deletion variables

    I would like to delete the entire row.
  16. Replies
    6
    Views
    190

    Re: VBA - row deletion variables

    Thank you for the help! this works splendidly. However, after the code is run I would like to also delete any non 4 digit number in column A.

    Is this even possible?
  17. Replies
    6
    Views
    190

    VBA - row deletion variables

    Is it possible to delete multiple rows based on the following?

    My original file is about 50,000 lines and each of the scenarios below could have hundreds of rows each.

    1) If the first digit of...
  18. Revising workbook templates without affecting formulas

    Hello all. I'm not sure what I need to do to fix my problem.

    I had a master data template which I copied and renamed with different entity names. So all worksheets are basically equal as far as...
  19. How can I increment alphabetically - problem with skipping rows.

    Here is what I am trying to fix.
    I want the formula to ignore blank rows and then continue the alpha increment. See column I for desired results.
    All help is appreciated



    <colgroup><col...
  20. Re: VBA to find Last Row to Copy and Past as value. VBA mess. Please help!

    Thank you and I will be sure to use the tags correctly next time.
  21. Replies
    3
    Views
    125

    Re: copying to next row not working

    Thank you.
  22. Re: VBA to find Last Row to Copy and Past as value. VBA mess. Please help!

    Thanks to you both for the help. I tried Footoo's suggestion and it worked like a charm.

    I am wondering if Footoo's code and another code I have can be combined since they are related.

    My code...
  23. Replies
    3
    Views
    125

    copying to next row not working

    Here is my issue.
    Line 2 is all set values.
    Line 3 is formulas.
    I already have a code to copy and paste as a value the last row (ie: Row 3).
    I am now trying to copy cells in the range...
  24. VBA to find Last Row to Copy and Past as value. VBA mess. Please help!

    Hello,
    I've been trying to create a macro to find, copy, and paste as a value the last line of this table.
    However, I also want to copy the formulas in the last row to the next line in preparation...
  25. Replies
    0
    Views
    259

    VBA Coding help.

    I have a workbook with multiple sheets. Excel 2016.
    I basically feed data from sheets 1 and 2 into a worksheet called "Prelim Estimate" (a1:f45).
    I have another worksheet (worksheet5) called...
Results 1 to 25 of 143
Page 1 of 6 1 2 3 4