Macro needed to pull data from one worksheet and enter it in anoth

[bigproblem]

if a checkbox is selected how can i move data from one worksheet (1) into to
another worksheet (2).

if b9 is checked (or any checkbox in column b). i want to copy the data in
that row to sheet2.

is there a macro that i can use?

 

[Dave Peterson]

Are you going to put a checkbox on every row you want copied?

If you are, then how about an alternative?

Add an extra indicator column (new column A???) to your data.
Put an X in that column if you want to copy the row.
Then apply data|filter|autofilter to that column.
Show the rows with X's
Copy the visible rows and paste to the new worksheet.
===
Select the range to copy
in xl2007, hit F5|Special|visible cells only
Edit|copy
then off to the new sheet and Edit|paste

If you really need a macro, you can record one when you do it manually.

 

[bigproblem]

all rows will have the checkbox but they may or may not be checked.

are you saying record a macro using the autofilter?