auto delete

Hello! I am trying to find a way to delete certain cells based off a check box in another. For example if H3 (which has a checkbox) is marked as true, then I would like B3,C3,E3,F3,G3, and I3 to have their contents cleared. Is this possible with a formula or script? I have attached a photo...

Okay, I am beginner/intermediate Excel user for work. Working with Excel 2010. I have a thought process in my head for what I want to happen, but cannot figure out how to execute it. I am tracking employee attendance over a 12 month rolling calendar. Here is my spreadsheet; Basically I have...

So I'm trying to create a leave/vacation tracker for my employees/coworkers, and I want to automate the worksheet so it automatically deletes(and shifts) certain cells every day. This is so the tracker remains up to date without anyone having to physical delete the cells themselves. There is a...

Aloha all!! Thank you for reading. I have a form on our company server. It's for people to select their break and lunch hours. Everything on the form is protected except for the areas they can fill in. At the end of the day, say midnight, I'd like the form to clear all contents inputted...

I apologize in advance if this has been covered in a previous post... I have a couple hundred pages of trend data (in notepad) and I would like to move it into Excel. However, at each page break there is an automated message/header repeated. I do not want this information to come over. I...

I've tried searching for answers for this but I just don't seem to find exactly what I'm looking for. So, I have list of content in cell A1, B1, C1 & D1 etc and as I fill in that same content from those cells into other cells I'd like to have the exact content in A1, B1, C1, D1, etc. auto...

I have an excel sheet that has 11 columns just as follows: <tbody> PLU Description Dept UOM Cost Retail Margin Inv Sales Sales2nd Supply 12345 Jack Dan 135 750 1.11 1.99 22.14 0 0 0 0 20151 Cuervo 136 750 1.13 1.99 22.51 3 1 1 3 50364 Jim Beam 136 175 1.43 2.49 22.54 0 0 0 0 </tbody>...

I am having a hard time figuring this out and was hoping for a little help. I need a macro that looks at a specific calculated cell and deletes all data past that row. I have been looking and trying to write code to do this but can't seem to get what I want... Any ideas