cellhelp
New Member
Hi There,
First time poster looking for some advice/insight. I have a workbook (1000+ rows) that contains various elements in columns. These are exam questions (so there are question body, 5 answers possibilities, explanations, etc. One of the columns has descriptive tags that I'm using to identify that specific question. Most questions have 2-4 tags, so in that cell you'd see something like
"chapter 2100,AIA,35 USC 102"
What I need to do is search through each row of the main sheet, and sub-divide (copy) the row into other sheets if the appropriate tag is found.
For example, if the question is tagged "chapter 2100" then that entire row would be copied into a sheet labeled "chapter 2100". If that same question also contained "AIA", the entire row would be copied into a separate sheet titled "AIA".
I know there is a way to create a formula or macro, but I'm having trouble with the logic/process. I attached an example workbook of what I'm working with.
First time poster looking for some advice/insight. I have a workbook (1000+ rows) that contains various elements in columns. These are exam questions (so there are question body, 5 answers possibilities, explanations, etc. One of the columns has descriptive tags that I'm using to identify that specific question. Most questions have 2-4 tags, so in that cell you'd see something like
"chapter 2100,AIA,35 USC 102"
What I need to do is search through each row of the main sheet, and sub-divide (copy) the row into other sheets if the appropriate tag is found.
For example, if the question is tagged "chapter 2100" then that entire row would be copied into a sheet labeled "chapter 2100". If that same question also contained "AIA", the entire row would be copied into a separate sheet titled "AIA".
I know there is a way to create a formula or macro, but I'm having trouble with the logic/process. I attached an example workbook of what I'm working with.
