Can someone suggest a macro for my 'comments' problem?
I have a repeating resistance template that I use for failure analysis of different samples. I repeat the test and collect the data in one file. The new data is added beneath the old. So for one test, I have a series of 28 rows before the next test starts. If I run across a fail, I remove the resistance data from the cell and insert a comment regarding the fail. I would like to extract the comments into column B of the same worksheet. But when I start a new test (at say column 29 for the next series) I don't want the macro to add the comments data to the next available cell in column b, but rather have it added starting at B29, B57, or B85 etc. whichever test group from which the comment was extracted.
PS~ I'm new to excel, so any help is really appreciated.
Thanks!!
I have a repeating resistance template that I use for failure analysis of different samples. I repeat the test and collect the data in one file. The new data is added beneath the old. So for one test, I have a series of 28 rows before the next test starts. If I run across a fail, I remove the resistance data from the cell and insert a comment regarding the fail. I would like to extract the comments into column B of the same worksheet. But when I start a new test (at say column 29 for the next series) I don't want the macro to add the comments data to the next available cell in column b, but rather have it added starting at B29, B57, or B85 etc. whichever test group from which the comment was extracted.
PS~ I'm new to excel, so any help is really appreciated.
Thanks!!
