Hi,
I am relatively sure this can be done, I just haven't figured out the right way to do so yet, I guess. I have a sheet, Sheet1, with 16 columns. Other than the first row, Column B can have three valid inputs (X, Y, and Z) not counting a blank row due to Data Validation. I would like to create three new sheets, one for each of the valid inputs on Sheet1. So one is called X, a second called Y, and a third called Z. The three new sheets have 15 columns, basically replicating what's on Sheet1, but without Sheet1's Column B as that'd be pointless since there's only one value that can take in each of the new sheets.
Yes, I realise we can just have Autofilter on Sheet1's Column B and then filter it to be X, Y, or Z, but I'd like separate sheets for ease.
Also related to this project I'm trying to create, but on a different topic and I don't want to create two threads, I was wondering if someone could explain dependent lists a bit. I'm dealing with lots of columns that have possible answers as Yes, No, and N/A, but one column also has another potential response. So I can't use INDIRECT, I don't think. Basically Column H can have Yes or No. If Column H is No, then Columns I, J, K, L, and M become N/A. If Column H is Yes, then Column I can be Yes, No, or the random response. (It's not really random, just doesn't fit with the others. This is just temporary as it will be eventually changed to Yes or No before moving onto the next column.) If Column I is No, then Columns J, K, L, and M become N/A. If Column I is Yes, then Column J can be Yes or No. And so forth down the line.
Oh and Column N can be Yes or No. It's Yes if there's a No or N/A in at least one of Columns H, I, J, K, L, and M. It's No if Columns H, I, J, K, L, and M all say Yes.
Thank you! I just want to be sure I don't accidentally write in some wrong data when I'm writing in the data.
Bookmarks