Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    10
    Views
    806

    Re: VBA to Check/Uncheck Checkboxes

    Working like a dream - Dave you are a genius. One day I hope to be well versed enough in this stuff that I can help people too!!!
  2. Replies
    10
    Views
    806

    Re: VBA to Check/Uncheck Checkboxes

    Amazing - give me an hour to implement and I'll report back - you have saved my bacon! Thank you so much!
  3. Replies
    10
    Views
    806

    Re: VBA to Check/Uncheck Checkboxes

    Hi Dave,

    Will do in future, sorry, newbie error :)

    The cells containing yes are indeed a formula - they display either a blank cell or a YES value depending on whether combinations of cells...
  4. Replies
    10
    Views
    806

    Re: VBA to Check/Uncheck Checkboxes

    Hi Dave

    Thank you so much - this did indeed work, but try as I might I wasn't able to tweak it to extend over the entirety of my range and packages. I tweaked range and array names, but failed...
  5. Replies
    10
    Views
    806

    Re: VBA to Check/Uncheck Checkboxes

    Thanks so much Dave, will deploy it now and report back! Thanks so much for your help - sometimes you just can't see the wood for the trees and I think I'm having one of those mornings :)
  6. Replies
    10
    Views
    806

    VBA to Check/Uncheck Checkboxes

    Hello guys, I've written some VBA to control some checkboxes but it's causing an issue that I can't quite get my head around fixing and was wondering if anyone here had any ideas.

    So basically I...
  7. Re: Reset spreadsheet to its original state upon opening (not revert to blank cells)

    Fabulous, that looks like it should do the trick, I'll give it a go when I'm at that stage (late tomorrow/early next week) and will report back!

    Thanks for your help as always!
  8. Re: Reset spreadsheet to its original state upon opening (not revert to blank cells)

    Thanks Yongle

    Would this be functional if someone wanted to 'reset' the spreadsheet to original values halfway through using it for example?

    ie. this spreadsheet will be being used during a...
  9. Reset spreadsheet to its original state upon opening (not revert to blank cells)

    Hi all

    Does anyone know if there is a way to have a button to 'reset' a spreadsheet to the values it has upon opening?

    For background the spreadsheet will have a number of graphs present that...
  10. Replies
    0
    Views
    617

    Multi Step Sankey Chart

    Hi All,

    So I'm usually posting on here about my Excel exploits, so something a little different today as I'm coming back to Power BI after a couple of years away.

    I'm building a Sankey Chart...
  11. Replies
    4
    Views
    357

    Re: Excel VBA to Google Sheets Script

    Hi Norie,

    Really appreciate you looking into this for me - may have to just bite the bullet and not have it in Google Sheets (less work for me lol)

    Here's the tutorial I followed...
  12. Replies
    4
    Views
    357

    Re: Excel VBA to Google Sheets Script

    Hi Norie,

    I have a map of the UK with all the 400+ local authority districts as separate images, they have all been individually named in Excel (I'm assuming there is a similar possibility in...
  13. Replies
    4
    Views
    357

    Excel VBA to Google Sheets Script

    Hi All,

    So I built this cool VBA coded heat map in Excel BUT...... having moved to a new role they do most of their work in Google Sheets so they can be collaborative.

    Problem is I need to...
  14. Clicking and Dragging enters a random formula - anyone know what is happening?

    Hi All,

    When I try and click and drag to select cells to copy (for example) if I have to drag to make the page scroll down Excel keeps entering this weird formula and it is really difficult to get...
  15. Re: Filtering a Chart - hopefully using a VBA drop-down or pop up rather than filter a table?

    Ooooh thanks thisoldman - sorry, didn't get an email to let me know you had replied so have been struggling on this morning trying to find an easier way to do it!

    I'm following this tutorial by...
  16. Filtering a Chart - hopefully using a VBA drop-down or pop up rather than filter a table?

    Hiya

    Had some great help on here recently and have managed to build exactly what my boss wanted! Problem is they always want more don't they!!!

    I have created an automated and dynamic chart...
  17. Re: Using a Cell Reference rather than a Named Range in a VLOOKUP

    Ooooh thanks Eric (sorry for late reply I was away this weekend) - will try that out. Have never had cause to use INDIRECT before so looking forward to it!
  18. Using a Cell Reference rather than a Named Range in a VLOOKUP

    Hi Lovely People!

    I'm sure I have got this to work before but for the life of me I can't do it now!

    So I have about 8 different named ranges, identical tables but with different data in them...
  19. Replies
    1
    Views
    365

    Re: 3D Map not refreshing

    Ah - no worries I fixed it - there was a random old table in the Data Manager that it was trying to redirect to - removed that and all is now good!
  20. Replies
    1
    Views
    365

    3D Map not refreshing

    Hi all,

    I have been having a play around with the 3D Maps function in Excel and it is doing what I want it to in terms of visualisation.

    It is feeding from a table which will update with...
  21. Replies
    19
    Views
    400

    Re: Conditional Copying and Pasting of a Row

    Worked like a charm Fluff - you really are all big Stars on here aren't you?

    Big Brownie points for me this end :)

    Thank you so so much!
  22. Replies
    19
    Views
    400

    Re: Conditional Copying and Pasting of a Row

    Thank you so much to both mumps and Fluff yesterday - my spreadsheet model is now complete and is doing everything I want it to!!! I'm so pleased. I've managed to write Step 4 and a macro to 'reset'...
  23. Replies
    19
    Views
    400

    Re: Conditional Copying and Pasting of a Row

    We have lift off!!!!!

    That is populating correctly now, fantastic work mumps you're a star!

    Now I have to try and work out how to return the sheet to its native state for when I pick a new...
  24. Replies
    19
    Views
    400

    Re: Conditional Copying and Pasting of a Row

    Thank you so much! I've got it kind of working now, but it's pasting all of the rows with zero values rather than the rows without zero values - I'm quite enjoying this sleuthing!
  25. Replies
    19
    Views
    400

    Re: Conditional Copying and Pasting of a Row

    Unfortunately I don't think I can - it has a lot of sensitive data in there that will take me forever to redact and if I just delete it the whole workbook will break. Let me have a play around with...
Results 1 to 25 of 56
Page 1 of 3 1 2 3