reached

hi all nice and easy one for you.. I need a cell with a date entered to fill with a colour when that date is reached and remain that colour until a new date is entered into that cell. all help appreciated

Hello, I have a workbook with 25 sheets (tabs), each representing a different project with data reporting the number of people reached by that project for a range of different activities. Not all projects did all activities. I have a consolidated sheet in which I need to count the total number...

Hi gurus, I am trying to find out whether the below 5 goals, named A-E can be met by a specific date each. Based on priority (my company's), they will be ranked 1,2,3,4 and 5 respectively. Then, they will run through a set of database (can't reveal here due to confidential purposes) to...

Hi was wondering can i setup a spread sheet to delete a column of data if one of them coloums is missing say a certain name ie "fred Smith" and also can it delete whole sheets from the workbook when a certain date is reached all without the use of a macro. Regards Mark

Hi all! I have a model that helps me calculate a bonus based on hitting certain ratios. I'm having trouble writing a formula to do the calculation. Here's how one line looks: <colgroup><col><col span="2"><col><col><col></colgroup><tbody> <colgroup><col><col><col><col><col></colgroup><tbody>...

Hi, I've been searching for an answer to this for a while but can't work it out, so I'm calling for help! (BTW, I'm using Google Sheets) I've a list of football results, and I'm trying to calculate the longest unbeaten run. Column A shows the result (Won, Lost, Drawn). I'd like column B to...

Hi, I'm looking for some help please to create an equation that will count the number of days since a minimum value has been reached. I have a list of names in a pivot table that produces a data point of top speed reached each day. I would like to be able to count the number of days it has...

Hi, everything I used to know about VBA I have forgotten, so this simple task is causing me a headache. I want to populate the value of B3 incrementally from the cell right above it IF the value of A3 is the same as A2. ELSE populate as .001 and repeat for B4, and loop until a blank cell is...

Hi Guys, I was wondering if I could find out how long it takes for someone in sales to reach a target of say £1000? My guess is I have to add the sales figures cumulatively and then return the date of when the target was reached? Not sure where to go after that. Any help would be great!

Hi, I have a bit of an odd issue. Ive got a button that is going to open a MsgBox or InputBox and allow the user to enter in information. This information is there stored in a sheet called "Essential Info" and will store to cells "I2:I13" What i am looking to do is display the input question...

Hoping someone can help! In Columns A2:A1000 I have dates. The column is ordered by most recent date first (i.e. A1 being todays date). In Columns B2:B1000 I have a series of numbers labelled with column heading 'High' (in B2). In Columns C2:C1000 I have a series of numbers labelled with column...

Hello everybody, glad to be part of this fantastic forum. as I said above, I would like to find a macro that could highlight a unique value until empty cell is reached and then to begin again till the end of the range. I tried conditional formatting but it doesn't help since it count all the...

Good Afternoon, I have one sheet that holds revision due dates in columns 'D', 'I' and 'N' , when the revision due dates are reached in this column, I would like an email reminder sent out on this date and also 14 days later if the date has not been changed, this will be to multiple email...

Hello! So I have quite a weird problem. In column B and C I both have stuff and a lot of blank cells. What I need to figure out is that I need to fill up column B (not everywhere) the following way (this is just an example, not the real values): What I have: <tbody> Banana A Orange...

Hi, is there a way to automatically update a sheet when a date has been reached. This would be in a money file tracking bank accounts. so if I have a debit going out on the 1st of every month is there a way to automatically populate the next available row with the required data when the date has...

<style></style>I have a cell that has a date in it. I would like that cell to automatically update with a new date once the date in it is reached. Is this possible?

Hi Guys, I want to add a number to each row, starting on A3 with 0, A4 1, A5 2, etc. Until the last row in column B is reached. Can you guys help me?

Hi guys, This must be super simple but I've already spent too much time on it, so I'd be grateful for any help. All I want to do is move the data from one specific column to another until a blank cell is reached. The names of the sheets and the columns always stay the same, so they can just...

Hello Everyone, Is there a VBA script that once a date is reached (date is stored on a worksheet), it will auto-generate an email (email address stored on the same worksheet)? I know that sounds like magic what I am asking for but I believe that there is something out there. I work in...

hello, I am trying to calculate the Ot hours once the Regular Hours have reached 40. If you could help with this that would be amazing!! we work shift work so our hours are from 7-3 3-11 11-7 so the time must be able to calculate into another day. we have figured out a few of the formulas, we...