Hi Guys, a little help please!
I have 2 sheets, on called 'section 2' and one called 'action to be taken'.
both sheets have the same column headings, as follows...
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col></colgroup>Users fill out the report completley in the 'section 2' sheet
now if someone puts any data in the 'Action' column i need it to be copied accross to the 'action to be taken' sheet.
so the end result for me needs to be one complete report and one with just the questions where action needs to be taken...
how can i do this?
I hope ive explained that clear enough
i really need help with this please guys
I have 2 sheets, on called 'section 2' and one called 'action to be taken'.
both sheets have the same column headings, as follows...
Ref # | Question | Yes/No/NA | Comment/Observations | Action | Named Person Responsible | Completion Date |
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col></colgroup>
now if someone puts any data in the 'Action' column i need it to be copied accross to the 'action to be taken' sheet.
so the end result for me needs to be one complete report and one with just the questions where action needs to be taken...
how can i do this?
I hope ive explained that clear enough
i really need help with this please guys