entered

Hi, I am having a bit of trouble with this formula I would like. Columns Q = Start date R = Finish Date T = On/Off When a date is entered into Q, I would like "ON" input into column T. When a date is then entered into R, I would like it to change to "OFF" in T Any help would be greatly...

Hello Can anyone support me and figure out why the formula below is not working? What I want is for the formula to work, dependant on what value is entered in cell O2 on a worksheet =MODE(INDIRECT("C"&ROW()-o2)&":"&INDIRECT("C"&ROW()-1))

Good morning. I am trying to find a way to automatically generate a sequence number when data is entered. I have to report out of a large spreadsheet which tracks tasks completed. The spreadsheet is used by a half dozen people from a shared location. They can be in and out of the...

Hey all, I am new to vba coding and have been trying to figure this one out with no luck. I have an invoice registry workbook that we use to track expenses. I am trying to prevent duplicate invoices from being entered across different sheets. The top of my sheet has formulas that calculate the...

I have my sheet set to "Show a zero in cells that have zero value". I am trying to format a cell so that it displays % in a cell when numbers are entered, such as, 0%, 5%, 10%, 20%, or 50%. I used the formula ##\% in the custom cell format, which works for all numbers except for when a zero is...

Hi folks I have a simple UserForm which has 3 checkboxes. Checkboxes labelled "Good" , "Average" and "Bad" When "Good" is checked, the value "1" is entered into a cell. If "Average" is checked then the value "0.5" is entered and "0" is entered when "Bad" is checked. The problem is this......I...

Your help with this issue is much appreciated... I'm sure there is a simple solution but,I am stumped. I have created a workbook with a Summary worksheet and a macro to create worksheets that are named with a Date (e.g., 27Jan2019). Dates are selected from a drop-down list and the macro is...

Hello all, What I need is a way for a cell to automatically insert the actual time information was entered into another cell, without erasing a previous time already calculated. In the example below, information was entered in B2 at 1:30 PM, so the time showed in A2. At 1:40 PM, information...

Hello, I have values in column A and dates in column B. How can I count the new entries today? What I mean is count the ones that occur today that haven't been entered before. Thank you for your help, XJ

I have the following code in F5 that looks at the EVENT date and checks if each row is in the date range (F:G), then counts each unique ID number and this works great. However, I now want to add another check to this, which is if the "check days" (D) is >=5 it should ignore that row (ID) (or <5...

I have a worksheet comprised of columns A, B and C. Column A is the date, column B is the student initials (which are entered AFTER they read the comments), and column C is the instructor comments. The comments in column C for each date are normally at least 2 rows however, they can be as long...

What I am trying to do is have cells that accept numerical values only. If an alpha value is entered I want a message to appear stating that only numeric values can be entered. Can someone please help me with this., Phil

Excel 2016, Windows 10 I am trying to find a way to delete any data entered into a row if specific text (130 0r 911) in entered into a cell (A4) unless another cell (A1) contains specific text (5). So if the users enter 1 in A1 and then a name in A2 and address in A3 and the 130 in A4 it...

I need a macro to change the color of a cell based on the value in another cell. I have data in range C4:L4. The user will review the content of the cells in the range, and may enter the letter Y or the letter N in C5 or D5 or E5 and so on. If Y is entered in C5 I want the cell color for C4 to...

Hi all, would appreciate a little help here. I have a sales sheet that once the completion date is entered i would like certain info automated to an invoice form on another worksheet same workbook and automated to send by email. Cell F needs to be the trigger as it will not always be the last...

Hey all, I am wondering if it is possible for a macro to be called upon when a key state is Up. It can be done in a user Form but I would like to achieve that in a sheet without any userform. But if a value is being entered in a cell and/or the formula bar is in active mode, then bypass/avoid...

I'm trying to do follow-ups by calculate 5 business days between two columns and does not want to include holidays for ex: Entered Date 5 day FU 12/17/2018 12/24/2018 (did not include Christmas and weekend) 12/24/2018 1/2/2019 (did not include New Years or...

Hi I am trying to add up all occurrences in cell G2 across multiple sheets where F2 contains "4303". I have entered a "Start" tab and "End" Tab, between the relevant sheets, if this helps

When the data is entered in c,d and e in sheet 3 it immediatly updates the average column on the collation sheet. Is there a way to delay the update where the 114.833 value is until the data entry is complete for the three entries? As soon as the 104 is entered it changes the 114.833 to...

Hello, I'm looking to use a combination of index and match to do the following: Cell B1 contains a row number that is editable. I have it so once the row number is entered, cell B2 returns the first value completed in the given row. Now, I just need cell B10 to return the 'week' that the first...