Cleaning up my codes to ensure a faster and smaller sheets

[SteynfaardtD]

Hi There

Please can Someone assist me with my sheet. I have my macros and I am new to VBA and need to clean up my codes. My sheet still needs to get few sheets with 2000+ rows and 10 rows of raw data..

I know it is a lot to ask but please if someone can assist.
There is a few Hidden tabs as well.

Thanks in advance.

[jmac1947]

Hello,

it may be a "dumb question" but does your macro actually work at the moment and you simply want to refactor it to produce a smaller code base or is your request broader than simply refactoring your existing code?

[jindon]

No way to test, but shorter based on your code is correctly working and all the sheet structures are the same.

Please Login or Register  to view this content.

[SteynfaardtD]

it works great but i still need to add al the raw data and this will push the size up more than 10mb.

[SteynfaardtD]

No way to test, but shorter based on your code is correctly working and all the sheet structures are the same.

Please Login or Register  to view this content.

Hi Jindon

Thanks for the feedback. This is the code that i should use in my "Summary" worksheet to populate my dash.

All of my sheets are duplicated based on structure and design. all that differs is the raw data that gets imputed.

I am really new to vba and therefore only know codes based in single events and not multiple events like arrays ext.

If I can get a description of what the above code actually does, then i might understand the structure behind the string.

[SteynfaardtD]

Hello,

it may be a "dumb question" but does your macro actually work at the moment and you simply want to refactor it to produce a smaller code base or is your request broader than simply refactoring your existing code?

correct. So all my macros works. Took me a day to do though HAHA, But I know there should be a better way to code the macros instead of the way I did it.

Please if I can get an example as all my different color tabs works the same except for the "Purple" Tabs. They are my master overview tabs of all the tabs