Posts by ajrilo

  • Dynamic drop down menu

    I have a spreadsheet which has 6 different events titled 18-01 thru 18-06 (year and event) across the top (starting in column C). Listed in column A going down are check point events, column B has various numbers 180-1 (counting backwards) which represent the number of days prior to the start date these tasks must be accomplished. Column C has a formula to calculate the today's date minus the number in B so I can track stuff by actual date. So listed under the 18-01 thru 18-06 are various dates. I have manually built drop down boxes for each cell in the spreadsheet, well over 500 of them (time consuming) The drop downs contain (complete, working, overdue, N/A, the original date calculated for that cell and a blank so I can change a date due to holiday or weekend) Is there a way to have the standard (complete, working, overdue, N/A and blank) items but dynamically add the correct date (depending on which column it falls in) so I can set up in the first cell a drop down and simply copy to all the remaining cells?

  • adding dynamic items to a drop down list which contains standard items

    I have a spreadsheet which has 6 different events titled 18-01 thru 18-06 (year and event) across the top. Listed in column A going down are check point events, column B has various numbers 180-1 (counting backwards) which represent the number of days prior to the start date these tasks must be accomplished. Column C has a formula to calculate the todays date minus the number in B so I can track stuff by actual date. So listed under the 18-01 thru 18-06 are various dates. I have manually built drop down boxes for each cell in the spreadsheet, well over 500 of them (time consuming) The drop downs contain (complete, working, overdue, N/A, the original date calculated for that cell and a blank so I can change a date due to holiday or weekend) Is there a way to have the standard (complete, working, overdue, N/A and blank) items but dynamically add the correct date (depending on which column it falls in) so I can set up in the first cell a drop down and simply copy to all the remaining cells?

  • adjust auto calculated date to meet specif days of that week

    I have a spreadsheet which returns dates to me in 30,60 and 90 day increments prior a specific due date.
    Some of these auto calculated dates fall on weekends, I don't know how to have the date automatically adjust to meet specific days of the week.
    (which might actually be 1 or 2 days before or after the 30,60 or 90 day window)
    is there a function or formula that will accomplish this, without me manually changing the dates?

  • Return a holiday name if holiday falls within range of dates

    column A lists the dates of federal holidays. Column B lists the name of that holiday. I have 6 events which are 10 days long. I am trying to have excel determine if any of the holiday dates fall within any of the 10 day events and than return the name of the holiday that falls within the event dates. I am stumped. I need a formula to perform this action.

  • changing cell color and text by clicking on cell

    Drop down lists


    I have added a drop down list to cell A1. Cell A1 already contains data (a date). The date was derived from a formula.The drop down choices are the words completed, in progress and over due. I used conditional formatting to change the cell color to green, yellow or red, but I would like the date already in cell A1 to be an option in the drop down list. A2 will have a different date as will all the other cells, so eventually each cell will have a drop down that has different data from other cells. Is there some way I can have excel add ,the data already in a cell,to a drop down list so that original cell data is an option in the drop down list?.

  • changing cell color and text by clicking on cell

    Re: changing cell color and text by clicking on cell


    only saw the last sentence of your reply, I could probably add a new blank column next to the date cell, but I still just want to click and have the green,yellow or red options so I can update status quickly. I still don't even have a starting point, any suggestions, formulas.....

  • changing cell color and text by clicking on cell

    I want to add either a scroll button or a check box that allows me to select 1 of 4 values for a cell. The cell also has a formula which displays a future date. I want to be able to select my choice of completed, working, overdue and have the cell color change to green,yellow or red respectively. But if no action is required yet to just display the future date with a white background.
    I will have 6 rows and 100 columns that I want to be able to update the status on, so will I be able to just copy and paste the formula to all the cells?
    I thought this would be easy but realized I have no clue how to do this!!

  • Adding numbers seperated by commas in a single cell

    Hello,


    I am trying to enter numbers seperated by a comma in to a single cell and have excel total the numbers. i.e. cell A1- 12,13,15 cell B2 totals them and reads 40. some cells could have two entries some could have 5. is there a formula that could do this? I am not good at all at VBA and would need a walk thru if that was the best way to do this. Thanks for the assistance

  • drop down list help

    I have a drop down list I made using data validation. the list are the numbers 1 to 12. I want the drop down to be in cell B1. once a number is selected, I want cell C1 to have a drop down list the goes from 1 to what ever number was just selected in B1. How do I do that?