Search:

Type: Posts; User: aaronb

Search: Search took 0.01 seconds.

  1. Wonderful, exactly what I was looking for. Thanks...

    Wonderful, exactly what I was looking for. Thanks a lot
  2. If my instructions were unclear I am sorry but...

    If my instructions were unclear I am sorry but the goal of the macro is to edit PortfolioTable (and PortfolioTable2 is just there to show what PortfolioTable should look like after the merging is...
  3. 15 US Dollars For Macro To Merge And Aggregate Data For Same Row Headers

    Description: http://www.excelfox.com/forum/f2/vba-help-merging-rows-in-table-that-meet-specific-criteria-1357/

    I need this by the end of the day (US time) and will pay promptly via PayPal upon...
  4. Correct, since the quarter and year don't match...

    Correct, since the quarter and year don't match the defined ones, it has no effect.
  5. Merging And Grouping Rows And Corresponding Data In Table That Meet Specific Criteria

    Sample workbook attached.

    I have coded a few simple things in VBA so far but not sure how to tackle this one, so code is much appreciated. What I am trying to do is code a way to combine rows in...
  6. Just tried your macro Rick. Worked a treat. Thanks

    Just tried your macro Rick. Worked a treat. Thanks
  7. Rick, Unfortunately that didn't work. It did...

    Rick,

    Unfortunately that didn't work. It did return 4 matches, but not the cells in question.
  8. Macro to get rid of that character in the...

    Macro to get rid of that character in the workbook so the affected cells return true for an ISBLANK check.
  9. Sample workbook attached 1070 Edit: The...

    Sample workbook attached

    1070

    Edit: The cell didn't copy correctly -- ISBLANK returns TRUE. Let me try to get a disfunctional one up.

    Sorry about that, here's a proper copy. The messed-up...
  10. Remove Unprintable Non-Blank Cells Having Zero Length Contents

    Hi,

    I'm importing data into a spreadsheet and what are supposed to be blank cells actually aren't. ISBLANK returns false. CODE(cellref) returns #VALUE error -- in the calculation steps, it looks...
  11. I was having trouble with the code you gave above...

    I was having trouble with the code you gave above and the routine I wrote. Both gave errors when deleting. After trying a lot of different ways I finally found something that works (deletes just the...
  12. Works like a charm, thanks.. never would have...

    Works like a charm, thanks.. never would have thought to use Transpose.
  13. Back to the original question. I have a simple...

    Back to the original question. I have a simple example that I should be able to adapt the solution to my project but need help figuring the formula out.


    I want to sum all numbers in...
  14. Update: Kind of hacky, but I managed to limit the...

    Update: Kind of hacky, but I managed to limit the find/replace to the specific worksheet by doing this before the find/replaces:


    Set Dummy = Worksheets(1).Range("A1:A1").Find("Dummy",...
  15. So I have made a few changes (highlighted) since...

    So I have made a few changes (highlighted) since I got the code from you, and it's mostly working but I got a couple issues.

    1) I do a find/replace in Column B to clear the contents of any cell in...
  16. Yup it works. Thanks again

    Yup it works. Thanks again
  17. EDIT: Ignore the rest, I got it working. I think...

    EDIT: Ignore the rest, I got it working. I think I was just missing the quarter/year reference. Not sure how it worked up through getting the stocks with that in mind but I'm just glad it works now,...
  18. VBA To Extract Data From Multiple Tables Based On Critera

    This wasn't getting too much love in my thread R.E. another issue so I'm posting it titled appropriately.

    Essentially, what I am trying to do is get an automated way to copy all unique stock names...
  19. I decided to display the values separate rather...

    I decided to display the values separate rather than summing them so that problem is resolved.

    That said, I now have a much more challenging problem to tackle and any assistance is much, much,...
  20. Sum Depending On Match Between Value And Its Existence In A Table

    Please see post number 5
Results 1 to 20 of 20