I have a command button on each sheet in a workbook except the last sheet.
How do I code each command button to copy TRUE values from a range of cells
on the same sheet into the last sheet so that the values are displayed
sequentially under a heading that is the value of a specific cell on the shee
from which they came? Or .
On Sheet 1. if any Cells(A3:M50)=TRUE Copy Sheet 1 Cell(A1) to Sheet6 A1 and
the values of the TRUE cells below it
One sheet 2 if any Cells(A3:M50)=TRUE Copy Sheet 2 Cell(A1) to Sheet6 in the
next blank cell in column A and the values of the TRUE cells below it.