Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies
    2
    Views
    158

    Re: Chart based on Store selection

    I think your problem lies in how you have your data laid out. If it were me, I would have 3 Columns of data. The header row would be STORE#, DATE, SALES. I would then move the sales data to the...
  2. Replies
    5
    Views
    117

    Re: Searching an array for a match

    You're welcome.
  3. Re: Copy rows based on keyword list to second sheet

    I am sorry I could not be more help. At least you got a bump out of it and Fluff got it done for you.

    Thanks for the feedback.
  4. Re: Copy rows based on keyword list to second sheet

    Fluff

    Nice!

    igold
  5. Re: Copy rows based on keyword list to second sheet

    I downloaded your workbook, and it is not as described in your post. You have the software name, version number, department name all in column A separated by commas. I can break that information out...
  6. Replies
    5
    Views
    184

    Re: Why won't this return a BLANK cell?

    Have you clicked on the Fx button to the left of the formula bar while your formula is in the bar to see what each part of your formula is returning...
  7. Replies
    5
    Views
    184

    Re: Why won't this return a BLANK cell?

    Out of curiosity, with the same data that you are using for the IF statement in your OP =IF(OR(F3>0, O3>0,F3-((IF(SUM('Week 42:[Week 52]Week 52'!P3)>0,SUM('Week 42:[Week 52]Week 52'!P3))))), " ") ...
  8. Re: Copy rows based on keyword list to second sheet

    You are welcome, I was happy to help.

    If it does not work for you, let us know and I am sure a solution can be found.
  9. Re: Copy rows based on keyword list to second sheet

    How about something like this. The software list you want to search for should start in Cell A1 on Sheet3.


    Sub GetSoftware()


    Dim ws1 As Worksheet: Set ws1 = Worksheets("Sheet1")
    ...
  10. Replies
    5
    Views
    184

    Re: Why won't this return a BLANK cell?

    I can't say for sure why it is returning zero, you may have a stray character in one of your cells. I can say for sure, that you are missing the "Value if False" part of your IF statement.
  11. Replies
    5
    Views
    117

    Re: Searching an array for a match

    There are lots of ways to get the UPC and Date that you want to search for into the search, I chose an InputBox. This code assumes that your first UPC,Date,Price row starts in Cell A2.


    Sub...
  12. Replies
    6
    Views
    56

    Re: Run formula if text is found in a cell.

    Yongle

    It was the red highlighting that did you in. :stickouttounge:
  13. Replies
    6
    Views
    56

    Re: Run formula if text is found in a cell.

    Is this what you are looking for...

    =IF(L2="open",IF(ISNUMBER(SEARCH("Not used",E2)),"",IF(TODAY()=E2,"Today",IF(TODAY()>E2,"Past Due",IF((TODAY()+7)>E2,"Due Soon","")))),"")
  14. Replies
    2
    Views
    76

    Re: Find Multiple Command For VBA in Excell

    You could use a manual or a VBA AutoFilter with multiple criteria. From this part of your post



    it seems like you are probably wanting to copy the rows to somewhere else, which an AutoFilter...
  15. Re: Vba for each cell in rng insert dynamic formula

    You're welcome.
  16. Re: Vba for each cell in rng insert dynamic formula

    If I understand your requirement, does this do what you want...


    Sub test()


    Dim arr
    Range("B2").Formula = "=sum(B$1,$A2)"
    Range("B2").AutoFill Range("B2:B517")
    arr =...
  17. Re: Vba for each cell in rng insert dynamic formula

    This...


    Sub test()


    Range("B2").Formula = "=sum(B$1,$A2)"
    Range("B2").AutoFill Range("B2:B517")

    End Sub
  18. Replies
    7
    Views
    389

    Re: Help Needed for unique task

    How about the actual line of code. Your line 42 is not necessarily my line 42...

    Also was this the entire error message



    or was there additional info provided...
  19. Replies
    4
    Views
    244

    Re: Which one cost more memory to run?

    You're welcome, and yes the speed difference would be exponential. The reason being that with an array all work is being done in memory, while having your code going back and forth to the sheet to...
  20. Replies
    4
    Views
    244

    Re: Which one cost more memory to run?

    The way you phrased your post, I am not 100% sure of what your asking. You say that you are used to storing data in arrays, but of course when you re-run the macro, the data is erased and re-written...
  21. Replies
    3
    Views
    208

    Re: Returning a Share Price from Google

    You may want to take a different approach...

    I have created a public google spreadsheet which consists of my symbol list and the info I wish to return using the built-in google finance functions...
  22. Replies
    7
    Views
    389

    Re: Help Needed for unique task

    Do you know which line threw the error.
  23. Replies
    5
    Views
    70

    Re: Searching in Excel crashing/Flickers

    Ok, I have no other suggestions. Sorry I could not be any more help.
  24. Replies
    5
    Views
    70

    Re: Searching in Excel crashing/Flickers

    Phantom ranges not phantom links...

    I still say 9mb does not sound right. I have a sheet with over 250,000 rows and 10 columns and it is only 5.75mb. Go to each sheet and hit CTRL+END and see...
  25. Replies
    5
    Views
    70

    Re: Searching in Excel crashing/Flickers

    I can't explain all the different scenarios you have listed, but in your closing you say that your spreadsheet is 9MB with only 6460 rows. That right there sounds awfully suspicious. I would check...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4