Hi all,
I'm new here and also new to VBA so any help would be greatly appreciated.
I have undertaken a bit of a task at my workplace to help myself further develop my skills and knowledge but I seem to have hit a massive roadblock in it that I can't seem to overcome. As stated, I am new to VBA having never used it prior to now so I have probably gone about this in an extremely difficult way.
Basically I have set up an excel spreadsheet to help monitor a bunch of information. Within this spreadsheet, I have inserted a button that will copy and paste a table from a hidden sheet as each day a new table will need to be inserted. My issue is that none of my macros will be applied to this new table. I have set up another button that will open a user form to filter certain columns by different categories then opening another user form to apply a checkbox (checkbox will only work once, I'm yet to work out how to use it to toggle a filter on or off) but when inserting a new table, my filtering macro won't be applied to this new table or any subsequent macros.
Lastly, one of the categories I have set up applies to three different columns that could all apply as they all come under the same condition. I basically need this one to be able to search all 3 columns for the same condition and/or apply 3 different conditions to each column.
These have all been setup using the record macro feature. I have spent several hours trying to find these answers but I can't seem to find them.
Edit: I did have a look to see if I could find the answer to these questions before posting but I couldn't see anything that seemed to answer my question accurately. This could also be a case of not really knowing what I'm looking or so I apologize if that's the case.
Thank you very much for any help anyone is able to provide.
Bookmarks