Hi all,
I was wondering if there was a way to do this without using a macro, im writing this for use within my company and most employees arent tech savvy.
what i have is a list of faults and actions (columns b & c), column A is a checkbox. all i want is that if the box is checked, it will copy that row to sheet 2 in columns A and B. the problem is i have a list of ~100 rows and sheet two will only have a few of the faults each time they use this document.
Is there a way to do this that can be done simply so that all i have to do check the box and its will instantly appear on sheet 2?
BR
Brothwood
I was wondering if there was a way to do this without using a macro, im writing this for use within my company and most employees arent tech savvy.
what i have is a list of faults and actions (columns b & c), column A is a checkbox. all i want is that if the box is checked, it will copy that row to sheet 2 in columns A and B. the problem is i have a list of ~100 rows and sheet two will only have a few of the faults each time they use this document.
Is there a way to do this that can be done simply so that all i have to do check the box and its will instantly appear on sheet 2?
BR
Brothwood