Forum Discussion
How to create a log of responses dependent on cell entry
Bluntly stated, you must provide a walk-through of the results you want to achieve along the way. Thereby, I can somehow suggest a way for you to get there.
Twifoo
Do you see the picture that was in the original post? Ignoring the Line No column, what I am looking to do is populate these line items. In column one will be a clause reference from a document, next column will be the requirement from that document, the next three columns will be depend if it has a commercial impact or its a technical impact. Ignoring the column between these two there will be a response that goes into the internal column or the reply to customer column.
There could be upto 30 line items per sheet, with columns 1, 2 & 4 being populated on every line item. Each line item will have either a comment in column 3 or 5 in addition to the others but never both. After I have populated the whole worksheet with say 30 line tiems, I was wondering if there is a way to create a log on separate worksheets from the information depending on which column is populated, so if column 3 is populated on say 6 items it creates a log of only that line items and vice versa for if column 4 is populated.
I am not looking for someone to do it for me just some pointers in what we could be looking at if it is possible?
Thx NR