Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.20 seconds.

  1. Replies
    21
    Views
    221

    How can you know what works or does not work if...

    How can you know what works or does not work if you don't know what the TRUE values are:)

    Based on your description, it should be the technique suggested by RG in his first reply, only including...
  2. There really is no need for the loop. This would...

    There really is no need for the loop. This would be much more efficient, just do the copy and paste values in one-fell-swoop:

    With Range(Cells(9, colNum), Cells(27, colNum))
    .Copy
    ...
  3. colNum =...

    colNum = Application.WorksheetFunction.Match(Range("E5"), ActiveWorkbook.Sheets("Case").Range("F6:AB6"), 0)+5

    The "+5" is to add the columns A:E to the Match value you get starting in Col F...
    ...
  4. Replies
    21
    Views
    221

    RG, I have no accounting degree (nor do I try to...

    RG,
    I have no accounting degree (nor do I try to play one here), so I do not get bogged down in where those expenses are:)

    What you say makes sense. In my limited knowledge (being a development...
  5. Replies
    21
    Views
    221

    RG, in response to your question: This...

    RG,
    in response to your question:


    This happens when your expenses exceed the amount of money you make on the sales. The sales figures must not be gross but must include some decrease for...
  6. How about something like:...

    How about something like:
    =COUNTA(J5:GK5)-COUNTIF(J5:GK5,"*h")/2

    it counts all the leave days, but then subtracts half for the leaves ending in H...

    Steve
  7. But as both Maudibe and I have mentioned, the...

    But as both Maudibe and I have mentioned, the descriptions are not unique. You seem to want them carried over separately and NOT consolidated, but your example gives no indication of what makes them...
  8. Replies
    21
    Views
    221

    Not if the values in your workbook for Cols A,B,...

    Not if the values in your workbook for Cols A,B, and C are accurate, since it doesn't give all the correct results...

    I am saying it depends on what your percent increase or decrease represents....
  9. Replies
    21
    Views
    221

    The formula:" =A5*(1-B5) Will give you the...

    The formula:"
    =A5*(1-B5)

    Will give you the values in C if you use 0.068 in row 16.

    In row 21, AFAIK you can't use % change formulas if the sign changes. they must both be losses or must both...
  10. It is not "Worksheet.Match" but:...

    It is not "Worksheet.Match" but:
    Application.WorksheetFunction.Match ....

    Steve

    PS MATCH only looks in 1 row or 1 column, so I am not sure exactly what you are trying to match, it won't look...
  11. Or just use: ...

    Or just use:

    Range(Cells(9,ColNum),Cells(27,ColNum))

    Steve
  12. Replies
    21
    Views
    221

    RG's formula works in all cases. But remember...

    RG's formula works in all cases. But remember your Col B percent is not really +/-. The 6.8% increase is listed as 106.8% so a 6.8% decrease (a change of -6.8%) would be listed as 100%-6.8% =...
  13. Replies
    29
    Views
    11,075

    You are very welcome. Steve

    You are very welcome.

    Steve
  14. Replies
    21
    Views
    221

    I disagree with some of RG's response. The...

    I disagree with some of RG's response. The original calculation was incorrect, regardless of the rounding. It was calculating the value 6.8% lower than the current value. That is not what you wanted....
  15. Replies
    21
    Views
    221

    The 2 different values comes due to what you are...

    The 2 different values comes due to what you are comparing. The value you calculated ($6354) is a 6.8% reduction from this year. But as RG points out, that is NOT what you looking at, you want to...
  16. Replies
    29
    Views
    11,075

    As I outlined earlier... Option Explicit...

    As I outlined earlier...


    Option Explicit
    Sub CopyWorksheets()
    ' Path - modify as needed but keep trailing backslash
    Const sPath = "C:\Test\"
    Dim sFile As String
    Dim wbkSource As...
  17. If the cond formatting with cells is too...

    If the cond formatting with cells is too difficult, a macro could be created which explicitly does the striketrhough in the cell or you explicitly do it manually...

    Steve
  18. Perhaps it is the addins... If you don't install...

    Perhaps it is the addins...
    If you don't install the addins is there a problem? If so, if you install only 1 do you have the problem?

    Steve
  19. Another alternative to the formula (depending on...

    Another alternative to the formula (depending on the real goal) is if you want it relative to the current selection. In this case you can use R1C1 nomenclature. For example if you want the cell to...
  20. If you name cell N1 "MyCell" then you can use the...

    If you name cell N1 "MyCell" then you can use the line:
    ActiveCell.Formula = "=" & Range("mycell").Address(False, False)

    Steve
    PS instead of using activecell and then copying you could select...
  21. Replies
    29
    Views
    11,075

    Can you attach a sample workbook and explain...

    Can you attach a sample workbook and explain exactly what you want to do?

    in a general sense, instead of looping with the DIR to look for folders on the drive, you would loop through the range of...
  22. But where is the dept information located? How...

    But where is the dept information located? How can one tell from the info in Consolidated Col B what dept it is and where is the dept listed in BR1 and BR2?

    That information is needed for a...
  23. Does it have to be a true strikethrough? Could...

    Does it have to be a true strikethrough? Could you display something like:

    Australian† or foreign† passport produced
    vs
    xxxxxxxxxxxxxforeign† passport produced
    vs
    Australian† xxxxxxxxxxx ...
  24. I am confused. Here are a few of teh things that...

    I am confused. Here are a few of teh things that confuse me:
    1) How are the values in Consolidated col B determined?
    2) When the value is Blank in rows 15, 25, and 26 how would the code know to...
  25. Replies
    29
    Views
    11,075

    Have you tried adapting the generic code in this...

    Have you tried adapting the generic code in this thread? You don't provide specifics so I can only provide general responses...

    Steve
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4