Simplifying VBA to a One Click Button

[wells2014]

Hi All,

I have a member of this forum for a while and have sat on the fringes and "watched" so to speak. I now have a query that I would like some assistance with though;

I have the following VBA code from one that was published here;

Please Login or Register  to view this content.

This is great but I am now handing the project over and would like to simplify the process. At present I have to highlight all the relevant sheets (all but 5)and then run the macro, then convert the consolidated data into a table.

I would like to use a simple button that the new users can use to run this process. Does anyone have any suggestions at to how I might do this?

Thanks for taking the time.

[Fotis1991]

Welcome to the forum.

We'd like to help you but first..

Pls take some minutes to read forum rules and specially-in this case- rule#3 and add code tags around your code.
Then anyone will be able to help you.