I have a spreadsheet that is protected because of the formulas I have in the
cells so the ones using the sheet wont overwrite them and this works great
because the only cells actively used are the ones unlocked for use. We have
hundreds of entries in several different columns with headers. My question is
how can we autofilter without unprotecting the sheet and keeping the orginal
by having to save the filter, I do not want to loss the orginal sheet because
it contains a huge amount of info that could be lost if the filter is saved
verses save as. The majority of the ones using the sheet has NO computer
skills and we need to make it as simple as possible.