Hi All,
I am using Excel 2007 and have a test question database that I need some help writing a macro for. In sheet 1, I have the master question list. Each row contains a question and its associated elements. Column A lists the version (A-C) of the test that the question is applicable to. Columns B:F contain the question number, question, answer and so forth. Columns G:I contain an X in the cell if the question applies to one of three departments to which the test given. Sheet 2 is version A of the test which only contains the questions which are applicable to department 1.
My question is, how do I write a macro to copy only version A test questions that are applicable to department 1 from sheet 1 to the list in sheet 2? It would ultimately be best if it would create a link to the original cell. That way, if I needed to make a correction to the original question on sheet 1, it would automatically reflect in the same question on sheet 2. I will be replicating this process for other sheets (version A, B and C tests for each of the three departments).
I’m sure it is likely a simple loop but the actual coding is beyond my skills. Thanks in advance for any help.
Tom
I am using Excel 2007 and have a test question database that I need some help writing a macro for. In sheet 1, I have the master question list. Each row contains a question and its associated elements. Column A lists the version (A-C) of the test that the question is applicable to. Columns B:F contain the question number, question, answer and so forth. Columns G:I contain an X in the cell if the question applies to one of three departments to which the test given. Sheet 2 is version A of the test which only contains the questions which are applicable to department 1.
My question is, how do I write a macro to copy only version A test questions that are applicable to department 1 from sheet 1 to the list in sheet 2? It would ultimately be best if it would create a link to the original cell. That way, if I needed to make a correction to the original question on sheet 1, it would automatically reflect in the same question on sheet 2. I will be replicating this process for other sheets (version A, B and C tests for each of the three departments).
I’m sure it is likely a simple loop but the actual coding is beyond my skills. Thanks in advance for any help.
Tom
