reset

Good afternoon, I have developed a dashboard that tracks daily activity for technicians. It's primary purpose is to see what progress is being made throughout the day and this has been working great. However I am now trying to apply some conditional formatting to the results column. In...

basically what I want to accomplish is a formula that will let me do ( x+y = y ) I want to accomplish this in 2 to 3 cells max <tbody> variable title a changing vairable end total item 1 n current total +n item 2 </tbody> we'll use excel notation and call them Cell A-1,2,3 and Row...

Hi, I have a vba program with publicly declared variable arrays. My program loops around and when it does I need to clear the array and reset all the values to zero. What is the best way to do this? I notice that even when the program ends, the arrays still hold the values. Shouldn't the...

I am looking for a little help here. I'm not a novice, but I am not an expert either. Just need to resolve one issue. I will include as much info as I can during my explanation. I am trying to make a "days since" tracker that shows the days since someone has delivered a certain thing. (not...

I am using the below code to delete all blank rows/columns and then fill all remaining blank cells or cells with value "(blank)" with a dash (-). Is there anything that I can add to reset excels last cell after the extra columns and rows have been deleted? In the past i've used ASAP Utilities...

Hi all, I hope you can help as I am a bit bemused! I am trying to reset cells on two different Sheets on the one Workbook. The item to reset to "OPEN" on the BLT sheet is resetting on the Decking sheet. Can anyone help? Thanks in advance! Private Sub Button51_Click() If MsgBox("Choose OK...

This may be a dumb question, but just as the question states - I have an argument that prevents the user from using Excel commands forcing the user to use vba cmds to save and/or close. I know a Close will obviously reset everything, but does the variable need to be reset after a Save or does...

Morning all, So I have a question about the ROW() function. I'm using it with a combination of LEFT to create a unique REF in column A; for example, ABCD01. It's made up of the first 4 characters of a document name and the ROW. My question is: when the document changes down the list how...

Hello, This may be done someway different, but I am looking for either a formula or VBA to add hours ran on a machine. I have a calendar on a spreadsheet. I will input the hours each day the machine ran. I want to add these hours in a different cell. Once we do a PM on the machine, I want to...

With Formatted Cells, (Borders, Fills, etc.), when you want to drag the contents of 1 cell to the other by just grabbing the edge of the cell, it sometimes erases the formatting of that cell, if it has a color fill it will be reset to white, as well as other formatting is reset. Also the...

Hello all! I am making an attendance tracker that counts the occurrences (entered by date) and would like the "current count" to reset every 6 months, starting with the first entry in cell A11. Below is the formula I am using in cell B7 - however I would like the count to reset 6 months after...

Hello, I am looking for a way to reset all my dropdown lists in a workbook to their top choice. Right now I found the following code, but it is for a certain sheet only, whereas I want all sheets with a dropdown to do this. plus I want this to only work when the sheet is opened automatically...

I have a dropdown with vlookup in a sheet, I used Bill's clear and save , works great. Heres my situation, I want to have the cells with the dropdown go to the top of the list "Select" when I run his macro. Cant find this anywhere. That way when the workbook is open the areas that need to be...

I have a dashboard that displays data by week number. Since the turn of the year my rolling week table needs to reset at week 1. For example I will trend 9 weeks of data today(weekNum()-9) Then the next cell would be +1 Until I get 9 weeks minus the current week Now I get week 52,53,54,55 etc...

Hello, I've been working on a formula to count the amount of consecutive days an employee has worked, and reset the count if a certain amount of days off has been met(criteria below). I need something that can check the previous month which is on a separate sheet to ensure the count isn't...

Need to the sum of Column E totaled until it is >= to a number (ie $5.00). Once that happens I need the difference over the (ie $5.00) to be calculated also and added to once it reaches a set number (ie $5.00). When complete I need the sum of column reset to $0 to start adding again to start the...

Hi All, I have created a exam/test in excel but am stuck in with the below issue, i want that a single user can only have three attempts to clear/pass the test, failing which the user can not take the test unless we do not reset the counter again. It will be a great help if some one can guide...

Hi, I have two worksheets and each worksheet has 2 sets of Yes/No Radio buttons. If I select "Yes" and "No" on one spreadsheet, when I click on the 2nd spreadsheet, the values are reset. If I click new values on the 2nd spreadsheet, whatever I selected in the first spreadsheet is reset. Any...

Hello, I was playing around with cpearson's timebomb at http://www.cpearson.com/excel/workbooktimebomb.aspx . I set Const C_NUM_DAYS_UNTIL_EXPIRATION = 0 and the timebomb worked. I then set it back to 30 but the file still closes. Is there an easy way to reset the expiration date? Thanks...

Good Day, I have a large spreadsheet with multiple columns taken from a data logger. The first column is a timestamp column that logs data every 15 minutes for a full 12 months. I needed to modify this column to reset all data logged between 12:00 and 17:00 so I used this formula...