Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro needed to pull data from one worksheet and enter it in anoth
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro needed to pull data from one worksheet and enter it in a
all rows will have the checkbox but they may or may not be checked.
are you saying record a macro using the autofilter? -- problem "Dave Peterson" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to select cells in column enter data then press enter | New Users to Excel | |||
Enter date on one worksheet, pull data from another | Excel Discussion (Misc queries) | |||
Enter date, then pull data from another sheet | Excel Discussion (Misc queries) | |||
macro needed to compare value and copy data underneath it to anoth | Excel Discussion (Misc queries) | |||
how do I enter more data to an already made pull down menu | Excel Discussion (Misc queries) |