New to Excel Programming and need help making my macros more efficient

Dear all,

Based on what I have learned from this forum and other learning sites I had created a user form to enter data in three worksheets.
1-Data
2-Summary
3-Eligibility Data.
How this work: The userform populate all the information to ws1 and some of the information to ws2 and ws3.
The main objective of ws2 is to summarize the number and type of error and base on that give me accuracy rate, also it will allow me to customize pivot table reports in the future.
The ws3 is the reporting worksheet which have the same information from ws2.
How I made it: after the ws1 is populated from the user form it call a macro called EnterFormula located in module 2 to calculate and populate the fields on ws2 and ws3 fields in blue color on the spreadsheet)
The Problems:
1-whe I added module 2 it became very slow to run and with a lot of data it goes to extremely slow, looking for solution in other threat I have added screenupdate =False at the beginning and true at the end but it is the same, on other mention to create an arry, but I do not know how.
2-because this data will be increasing daily, I want to be able to load it daily to an archive folder similar to this one and get it clean for the next day data.
I want to thanks in advance for any help on this; it’s a time consuming doing it manually.
This is great forum, I had made this far and love to learn from all of you.

I want attach the file it is 3.2 Mb when Zip but still is to large, and idea how to make it smaller. I need help with this asap.


Thanks,

Thanks Norie for your response, Ill look into that right now.


Thanks again

Hi Norie,

It went from 3.0 MB to 2.20, but still too large.

Thanks for your help.

Did you try saving your workbook in .xlsm format instead of .xls?

Hi Exceloub,

Yes, it is save in .xlsm, just deleted one more module and now is 2.19 Mb

Thanks,

Dear All,

I can e-mail my file to anyone to take a look at it, and help me to reduce the file size.

Thanks in advance.

Check your inbox