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,