I'm running Excel 2010 and think I need a small macro to enforce several rules in a spreadsheet. I have a spreadsheet that consists of two columns and 180 rows broken down into 12 sections of 15 associated rows per section. I have attached a sample of the spreadsheet with 15 rows to keep it simple and than plan to apply the Macro for each section. I need to have a macro that allows for input in the first column (A) and based on that answer, either restrict or allow additiional input both in the adjoining column (B) or in the rows below. Here are the rules I'm trying to enforce:
If data in column A = "True", than you cannot input any data into adjointing cell B
If there is no data in column A or data = "N/A", than no data can exist in the adjointing cell B
If data in column A = "Partial" or "False", than data in cell B can be inputed from the dropdown list
When 3 false answers are created in a sequence (i.e. FALSE, FALSE, FALSE) in column A, than no more input is allowed in any of the cells below the third "FALSE" in sequence, within the cell range (i.e. A19:B33).
That's it! "Thank you in advance".