everyday

I am trying to lock/protect certain cells so that they can't accidentally be deleted or changed, yet still be able to edit the other cells. I don't want to use a password to unlock the sheet everyday, just if I need to adjust those protected cells. For example, I want B3:B34 to be locked but I...

Hi looking to use a formula that started on 11/24/2018 adding 27 everyday to cell and going forward. So right now it would probably look like 1019 since then. Then tomorrow when i open sheet should be 1046 then etc. Regardless if i open sheet everyday or not would like it to add up 27 a day...

I understand that it is frowned upon, and in some places, considered 'bad practice', but how else can you do this? I have a .xlsm file that runs competently unattended. I want to be sure that it runs everyday. How else can I do this if not on a server?

I have the equation: =today()-row()+3 starting in cell A3 and continuing down column A. Everyday I am manually inserting numbers within row 3 in columns B-Q. What I am looking to do is to have excel automatically shift that row down everyday so that I can enter new numbers into row 3 (next to...

Can you build a formula to only pull data associated with the most recent date? Example: A1 - A100 has dates ranging from 06/25/18 - 08/11/17 I only want the data from the most recent date. This report will be updated everyday so I was hoping to have a formula that I can use everyday. Thank you

I need to open a folder with the name "File_Name_23Jan18" in that format.The Date changes everyday. Also, can i open the file with just the "File_Name"? Any help would do thanks.

Hello, I have a Macro called WeatherData which I would like to have run everyday automatically at 7:00am in the morning. If the workbook is left open, does anyone know how to easily automate this process? Thank you.