How to use the advanced filter in Excel

How to use the advanced filter in Excel. How to save and move filtered data to another location. Click this link to check out my one-on-one training www.calendly.com/easyexcelanswers
For more help visit my website www.easyexcelanswers.com or email me at [e-mail].
Contact me regarding customizing this template for your needs.
Click for online Excel Consulting www.calendly.com/easyexcelanswers
Are you struggling to update your Microsoft SQL Server data?
I recommend using well-known Excel to update and manage your data in SQL Server using the SQL Spreads Excel add-in.
Click sqlspreads.com/?pid=barbhende... to find out how SQL Spreads works best for non-technical end users and download our free 14-day trial. You will get two months free when purchasing an annual subscription using our link.
I am able to provide online help on your computer at a reasonable rate.
www.amazon.com/shop/barbhende...
I use a Blue condenser Microphone to record my videos, here is the link
amzn.to/37gyyGa
Check out Crowdcast for creating your webinars
app.linkmink.com/a/crowdcast/83
I use Tube Buddy to help promote my videos
Check them out
www.Tubebuddy.com/easyexcelan...
Follow me on Facebook
/ easyexcel.answers
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
ruclips.net/user/timedtext_cs_p...
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I've used or have experience with.
How to insert VBA code in Excel • How to insert VBA code...

[@Rockstar6111]

Hi Barb, thanks for your videos. They have helped in my work. I was wondering if you could help me with figuring out an excel code or feature? I want to auto password protect cells based on color fill. I have found some VBA codes that protect after data entry. However, the staff that will utilize this spreadsheet aren't very experienced with excel. I would like to have a conditional format that will color fill a cell after alphabetic or numeric values are added. Then once the cell is color filled I would like it to be automatically password protected. I specify alphabetic and numeric characters because I expect the staff may accidentally type things like parenthesis, commas, dashes, and characters I don't want. I saw your video with the VBA code that protected cells based on being less than today. So I thought you might be able to help or suggest another option.
This is for archiving banker boxes. I already a column that calculates 10 years from when the box was created. 10 years is our disposal date. However, I don't want staff to go back and edit previously made boxes. But I do want some flexibility for them to correct any typing errors before the spreadsheet is saved or closed.

[@BarbHendersonconsulting]

I have been thinking about this one quite a bit. Let me see what I can come up with