Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.21 seconds.

  1. Replies
    6
    Views
    76

    That warning has nothing to do with the code, it...

    That warning has nothing to do with the code, it has to do with the your security settings. See the article at...
  2. Same principle as forward, just use -1 instead of...

    Same principle as forward, just use -1 instead of +1:
    =DATE(YEAR(A1)-1,MONTH(A1),DAY(A1))

    Steve
  3. Replies
    5
    Views
    565

    Does this do what you want? Select the "Disk...

    Does this do what you want?
    Select the "Disk Type" from Z1 (it pulls from the list in Col AI)

    It pulls the 30 highest batch numbers (or gives a blank if <30 are in the list) for the chosen disk...
  4. Replies
    21
    Views
    10,842

    I would recommend NOT putting them into 12...

    I would recommend NOT putting them into 12 separate files. I would add a column with month to all the data and them combine them into 1 file. Then you can use autofilter to just see a particular...
  5. If you are looking for function you can use this...

    If you are looking for function you can use this UDF:

    Option Explicit
    Function MatchAll(vValue, rLookup As Range)
    Dim rCell As Range
    Dim sAddr As String
    sAddr = ""
    For Each rCell In...
  6. Replies
    6
    Views
    107

    You are very welcome. Steve

    You are very welcome.

    Steve
  7. Poll: I don't see the issue as having anything to do...

    I don't see the issue as having anything to do with the proprietary nature. This could be solved easily enough by creating a representative example with dummy data in it. The problem I continue to...
  8. Replies
    6
    Views
    107

    How about in row 6 and copied into the others: ...

    How about in row 6 and copied into the others:
    ...
  9. You are copying an entire worksheet in your code,...

    You are copying an entire worksheet in your code, not the filtered range. To copy the filtered range you can use:
    If wTarget.Name <> "MKT" Then
    wTarget.Range("B7:K7").AutoFilter Field:=8,...
  10. Replies
    6
    Views
    107

    In the next row you use something like this and...

    In the next row you use something like this and copy it down if there are no blanks in the datarange:
    ...
  11. If you want to keep them as numbers but display...

    If you want to keep them as numbers but display that way, format the cells with a custom number format of 000

    To convert to text you could use a fomula like:
    =TEXT(A1,"000")

    Then you could...
  12. Poll: You are making it very difficult to understand,...

    You are making it very difficult to understand, let alone work on a solution to your project. You keep changing the format and the requirements and you don't answer the questions. I am about ready to...
  13. Poll: How is this different from the thread at...

    How is this different from the thread at http://windowssecrets.com/forums/showthread.php/162993-Macro-challenge!-how-to-pull-information-across-with-certain-limitations?

    Should I stop working on...
  14. Yes, that is correct. And you are very...

    Yes, that is correct.

    And you are very welcome.

    Steve
  15. Poll: You still haven't answered my questions. If you...

    You still haven't answered my questions. If you want help with this problem from me, I need to understand what you are trying to do.

    I ask again, please walk me through the details of what you...
  16. Replies
    54
    Views
    2,067

    You are very welcome. I am glad I could help. ...

    You are very welcome. I am glad I could help.

    Steve
  17. Poll: Please, I need details. Walk me through EXACTLY...

    Please, I need details. Walk me through EXACTLY what you want the code to do. Refer to workbooks, worksheets and cells. What is being compared, what value(s) need to be looked up, etc? What should be...
  18. When you redefine the X/Y range, only the new...

    When you redefine the X/Y range, only the new range is plotted. If you want you can look it as erasing the old and creating a new if you want, but I don't see it that way since the code is using the...
  19. Poll: So which is the start, which is the end and what...

    So which is the start, which is the end and what is the purpose of the 3rd file?

    Walk me through the logic of when you have the start file and the "3rd file", how you would get the end file...
    ...
  20. The code does not erase the old XY graph (it is...

    The code does not erase the old XY graph (it is an XY scatter, not a line). It just redefines the range of the current XY graph.

    The macro only redefines the ranges, it does nothing to the other...
  21. With INDEX, you can give a range and you can...

    With INDEX, you can give a range and you can specify a row and column for an individual cell

    OFFSET can also be used to give a cell (or range) offset from some standard.

    If you want more...
  22. Poll: Is this file meant to represent a before or...

    Is this file meant to represent a before or after? Where is the other?

    You are not answering the questions being asked of you. You don't need a macro if all you want to do is count, a formula can...
  23. Replies
    10
    Views
    179

    But if the goal is essentially autofilter but not...

    But if the goal is essentially autofilter but not displaying all the data, why not keep the autofilter on the database and use a macro to hide the columns you don't want displayed and unhide when you...
  24. Poll: That not only does not answer the questions I...

    That not only does not answer the questions I pose, it raises other questions since you are indicating that the sample files are intermediate files, not the start and not the end.

    At the very...
  25. Replies
    54
    Views
    2,067

    For this you just need to add more rows to the...

    For this you just need to add more rows to the data set in chart extract and expand the chart range to include them


    This should not be an issue, the values are not hard coded, the formulas pull...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4