C
Clinton W
I would like to copy particular cells from nine different worksheets and
paste (value only) to another sheet named “Printâ€. All the sheets are within
one workbook.
The contents of the cells I need to copy are activated by check boxes. The
check box cell links are all in column O.
For example, if O10, O15, and O135 are TRUE, I need ranges (D10:H10),
(D15:H15), and (D135:H135) to be copied and then pasted as values only to the
“Print†worksheet, into cells (A1:E1), (A2:E2), (A3:E3), and so on.
I would like to be able to tick the appropriate check boxes and then perhaps
have a button named “export†to run the copy/paste macro.
Please note that while the check box cell links are in named ranges, there
are many empty cells between the ranges, so cells containing the word “TRUEâ€
in column O would need to be searched for, either from O1 to the bottom, or
perhaps a predefined range like (O1:O300) if that’s easier or more efficient.
Only the active worksheet needs to be searched.
I’ve looked long and hard for a solution in this discussion group, and I’ve
experimented with lots of the answers I found, but I don’t have adequate
skill to adapt them to what I need.
I would really appreciate advice on this.
I hope I’m not asking too much.
Thank you
Kind regards
Clinton
paste (value only) to another sheet named “Printâ€. All the sheets are within
one workbook.
The contents of the cells I need to copy are activated by check boxes. The
check box cell links are all in column O.
For example, if O10, O15, and O135 are TRUE, I need ranges (D10:H10),
(D15:H15), and (D135:H135) to be copied and then pasted as values only to the
“Print†worksheet, into cells (A1:E1), (A2:E2), (A3:E3), and so on.
I would like to be able to tick the appropriate check boxes and then perhaps
have a button named “export†to run the copy/paste macro.
Please note that while the check box cell links are in named ranges, there
are many empty cells between the ranges, so cells containing the word “TRUEâ€
in column O would need to be searched for, either from O1 to the bottom, or
perhaps a predefined range like (O1:O300) if that’s easier or more efficient.
Only the active worksheet needs to be searched.
I’ve looked long and hard for a solution in this discussion group, and I’ve
experimented with lots of the answers I found, but I don’t have adequate
skill to adapt them to what I need.
I would really appreciate advice on this.
I hope I’m not asking too much.
Thank you
Kind regards
Clinton