Using checkboxes to delete specific ranges of cells via command button

Hello everyone,

I am quite new to the forum, and although I have read the rules, please do let me know if I am breaking any. This is my first post, after all.

I am extremely new to VBA and excel formulae and until very recently the most advanced procedure I was able to complete with Excel was sketching a scatter plot. I am compiling a database of sorts to serve me during my PhD. Through browsing the net for tutorial videos and forum posts, I was able to put together a VBA advanced filter, create a dynamic scatter plot and box plot with several useful functions, and a few very very simple macros to tidy the whole thing up.

I am finding it difficult to navigate through my filtered data at times because there are simply too many columns. Sometimes I want to delete certain columns (not entire columns but cell ranges starting at row 29) so that I only have the data I need. This is simply enough done manually, however, I am not the only person to use the database, therefore I want to make it as straightforward as possible. What I want is to have checkboxes above each column header of my filtered data which I could check and then use a command button to delete the selected columns/cell ranges and shift the remaining cells left so there are no blank spaces. Needless to say, I need my advanced filter macro to still function after the columns have been deleted.

I found a similar solution to what I want, which deletes entire rows in this thread. I don't know, however, how to adapt the solution to my needs.

I have uploaded my current database for anyone to have a look.

Any and all help would be much appreciated