Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: What do you Do with Excel and in What Context?

    G'day Richard

    Came across this old post of yours mentioning your Football Tipping spreadsheet?
    Don't suppose you would still be able to locate it and be prepared to share it?
    I have an old...
  2. xlsm workbooks much slower than xls workbooks

    Can anyone explain why I find it so much faster to run my workbooks created in Excel 365 in Excel 2003 compatibilty mode?

    Even with some complicated and very long VBA macros including colour...
  3. Replies
    12
    Views
    587

    Re: VBA Magician required again

    THANK YOU EVERYONE!

    Working like a charm this morning.

    Mike.
  4. Replies
    12
    Views
    587

    Re: VBA Magician required again

    Michael M

    It would improve my operation even more if you could modify the following to only add the Date to the Offset 4 column O if the cells were empty because I do have a heading and other info...
  5. Replies
    12
    Views
    587

    Re: VBA Magician required again

    G'day Fluff, My answer is and Michael M

    Thank you all very much everything working perfectly and I am actually using some of each of your suggestions.

    Another 5 - 10 minutes a day saved and at...
  6. Replies
    12
    Views
    587

    Re: VBA Magician required again

    WOW - My answer Is and Michael M - so quick so complete and so simple!

    Many thanks to you both and tomorrow I will advise that it is working perfectly.

    Mike.
  7. Replies
    12
    Views
    587

    VBA Magician required again

    I have had such success on this Forum that I will cheekily test your generosity once again!

    Each day I import several hundred rows of data in columns A:K of a xlsm workbook interspersed randomly...
  8. Replies
    3
    Views
    106

    Re: Date formula required - simple?

    Dave, many thanks for your quick response and perfect solution.

    Greatly appreciated

    Best regards

    Mike.
    Tasmania.
  9. Replies
    3
    Views
    106

    Date formula required - simple?

    G'day Magicians

    I have a column with around 100,000 dates in it mostly from the last one year period.

    I would like a formula to put into the next column that returns an "O" if the day was an...
  10. Replies
    3
    Views
    237

    Re: VBA Magician required

    jolivanes

    You are a true magician!
    Once I corrected my Desktop location your simple VBA worked an absolute treat.
    I am so grateful and can't wait to exploit your work which will save me much...
  11. Replies
    3
    Views
    237

    VBA Magician required

    I use Excel for Office 365 in Windows 10.

    I have a spreadsheet called C:/Desktop/tkxl_f.xlsm which can have from two to twenty five sheets each with different and variable names and always located...
  12. Replies
    13
    Views
    243

    Re: Fancy Formula Forthcoming?

    Beautiful work Fluff!

    Many thanks much appreciated.

    Mike
    Tasmania.
  13. Replies
    13
    Views
    243

    Re: Fancy Formula Forthcoming?

    G'day Fluff

    The formula you provided is doing exactly what I required and at the risk of frustrating you can I ask for a slight modification in the light of my further experience?

    Instead of......
  14. Replies
    13
    Views
    243

    Re: Fancy Formula Forthcoming?

    Peter

    Many thanks for your interest and if I ever build a data set of past history I will come back to you for further assistance.

    Mike.
  15. Replies
    13
    Views
    243

    Re: Fancy Formula Forthcoming?

    OK the Fluff option appears to be working perfectly for me so I will close this thread and once again thank everyone (and especially Fluff) for theior asistance.

    Well done all!

    Mike.
  16. Replies
    13
    Views
    243

    Re: Fancy Formula Forthcoming?

    I will test the suggestion by Fluff now.
  17. Replies
    13
    Views
    243

    Re: Fancy Formula Forthcoming?

    Peter

    Data set varies a little Columns always run out to "K" but rows can vary from 8 to 80

    Mike.
  18. Replies
    13
    Views
    243

    Re: Fancy Formula Forthcoming?

    njimack

    Many thanks for your very prompt response with the above code, much appreciated.

    However I am having a aproblem with it that I am not capable of fixing sorry.

    It is removing the rows...
  19. Replies
    13
    Views
    243

    Fancy Formula Forthcoming?

    G'day Magicians

    I require a fancy formula to include in a macro?
    I wish to Delete all Rows where both Column B (Track) and Column C (RN) are identical AND Delete all Rows where Column G (SB1W)...
  20. Replies
    9
    Views
    454

    Re: Tricky little Colour macro needed

    G'day again Fluff

    Truly MAGICAL!

    In lieu of the gift you deserve can I ask that you please take a moment to smell the roses from your garden (or Avatar)?

    I remain indebted to you....

    Mike.
  21. Replies
    9
    Views
    454

    Re: Tricky little Colour macro needed

    Thank you Fluff but no sorry that one is colouring the whole of column U and none of the Cells in Col J instead of just those sells in the rows that are coloured in both Cols U and AF?

    Mike.
  22. Replies
    9
    Views
    454

    Re: Tricky little Colour macro needed

    Many thanks Fluff however that colours all the cells showing a zero in Col U instead of only those that are in rows 2 to 6 and so coloured in Col AF?

    With thanks

    Mike.
  23. Replies
    9
    Views
    454

    Re: Tricky little Colour macro needed

    Steve

    Cells AF2:AF6 are permanently coloured and the piece of code selecting which cells in Col U will be similarly coloured is...

    64: Next rw_v

    For rw_w = 2 To rw_s
    If...
  24. Replies
    9
    Views
    454

    Tricky little Colour macro needed

    G'day Magicians

    Can someone please help me with this one?

    I have a macro that colours cells AF2:AF6 with lime green (65250) and also colours some of the cells in U2:U6

    I want to add to that...
  25. Re: Magician required for multiple Criteria Extraction

    Thank you very much Peter, adding that additional column required for multiple Criteria solved my problem nicely.

    Happy Easter

    Mike.
Results 1 to 25 of 70
Page 1 of 3 1 2 3