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 thats easier or more efficient.
Only the active worksheet needs to be searched.
Ive looked long and hard for a solution in this discussion group, and Ive
experimented with lots of the answers I found, but I dont have adequate
skill to adapt them to what I need.
I would really appreciate advice on this.
I hope Im not asking too much.

Thank you
Kind regards
Clinton