Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    95

    Re: Sort multiple tabs

    Brilliant, that works fine - puts all tabs in timed order just as I wished.
    Thanks for doing this so quickly - provided a very convenient feature.
  2. Replies
    3
    Views
    95

    Sort multiple tabs

    Thank you in anticipation.

    I have multiple tabs on a worksheet that are ordered thus (the numerals are times but set as text):

    Bus 14.10 Bus 14.40 Bus 15.10 Car 14.15 Car 14.45 Car 15.15...
  3. Thread: Blank Rows

    by BakerBaker
    Replies
    6
    Views
    249

    Re: Blank Rows

    Thank you very much MickG - works exactly as I would wish.
  4. Thread: Blank Rows

    by BakerBaker
    Replies
    6
    Views
    249

    Re: Blank Rows

    Thank you very much - works exactly as I would wish.
  5. Thread: Blank Rows

    by BakerBaker
    Replies
    6
    Views
    249

    Blank Rows

    Would very much appreciate assistance with the following.
    I have a long list of data most of which is separated into blocks of 6 with a blank row in between. Occasionally, I encounter a block of 5...
  6. Replies
    8
    Views
    253

    Re: Copy Multiple Worksheet contents

    Thanks "Fluff". The existing "Combined" sheet was generated by the previous macro. Deleting that sheet and running your script actually produces a better result; I hadn't noticed, but the previous...
  7. Replies
    8
    Views
    253

    Re: Copy Multiple Worksheet contents

    Thanks. Got a run-time error 1004. "That name is already taken. Try a different one." On debug - Sheets.Add(Sheets(1)).Name="Combined" is highlighted.
    However, the previous answer worked OK and am...
  8. Replies
    8
    Views
    253

    Re: Copy Multiple Worksheet contents

    That does exactly what I want to achieve! Thank you very much for your prompt reply.
  9. Replies
    8
    Views
    253

    Copy Multiple Worksheet contents

    Thanks in advance.
    This is a copy of part of worksheet 1 which is a horse racing rating method:


    <tbody>
    Chelmsford City 16.45 (in cell A1)



    Horse
  10. Re: RANK variable blocks of cells between BLANK cells

    That's the one. Once again, thank you for the help.
  11. Re: RANK variable blocks of cells between BLANK cells

    My initial question received an excellent answer. As an additional question - What needs changing in the formula to sort lowest to highest?
  12. Re: RANK variable blocks of cells between BLANK cells

    Absolutely excellent! Thanks for the time spent looking into this. Will save me a LOT of time
  13. Re: RANK variable blocks of cells between BLANK cells

    RANK as in sort to order.
    A B
    1 22 =RANK(A1,$A$1:$A$4,0) (Result is 2)
    2 46 =RANK(A2,$A$1:$A$4,0) (Result is 1)
    3 10 ...
  14. RANK variable blocks of cells between BLANK cells

    I would like to RANK individual blocks of cells within a column which will be a variable number between BLANK cells. In the (simple) example I wish to RANK A1 to A4 and then A6 to A11. A formula in...
  15. Replies
    3
    Views
    110

    Re: Sort variable number of rows by column

    Works a treat! Thanks for the fast reply.
  16. Replies
    3
    Views
    110

    Sort variable number of rows by column

    Help greatly appreciated on this. Below is a simple representation of a larger data set. I wish to sort each block of rows by column with the numerical value in Col. B descending from Largest to...
Results 1 to 16 of 16