Hi,
Let me see if I can describe this correctly. I have a series of worksheets that utilize macros to unprotect sheets, utilize lookup and pivot tables, refresh, clean data from columns, and then reprotect sheet. Everything with the macros is working fine. My data is doing what I want it to...