Hello!

I am trying to auto generate lists on one sheet (B), based on information from another spreadsheet (A).

So on Spreadsheet A, There is a column with text in it (Column A). In a cell next to it there is a Data validation list with options (Column B).

So effectively what I want to do in Spreadsheet B is create a cell that says this:

If B1 on Sheet A=Hard Limit then list A1 on Sheet A in the below Cell on Spreasheet B.

A copy of the spreadsheet is uploaded, the content is NSFW (no images, just text. It's a BDSM Checklist).

I want to create four lists total at least, A hard limit list, a soft limit list, a curious list, and an essential list.
Checklist - No Macro.xlsx