Macro needed to pull data from one worksheet and enter it in anoth
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 wrote:
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?
--
problem
--
Dave Peterson
|