Apply Macro to entire workbook

[Msteenbeke]

I have a macro that re-filters the information in the column when I add new information in a different sheet. it works great but i have the code in all 28 sheets that does this and it really slows down my excel is there a way to make it into a macro that will apply to the entire workbook?

Please Login or Register  to view this content.

Moderators Note: Please follow forum rules and use code tags. Added for you this time, but please use them in the future…Thanks.

[Richard Buttrey]

Hi,

It's not clear to me exactly what this is doing apart from creating a View name and then immediately deleting it.

Can you explain the end goal? Ignore what is currently coded, tell us what you want to achieve and upload an example workbook so that we can see the request in context.

[Msteenbeke]

Richard Buttrey,

I have made a sample file with some more information in it I hope it explains what I need

Thank you,
Msteenbeke