Xc3l3r4t0r
New Member
- Joined
- Apr 8, 2015
- Messages
- 4
Hi all, appreciate any help you can muster.
I am looking to deploy a macro that would utilize checkboxes built into every row of data, that would enable the user to select specific rows to be copied over into the next sheet. The source sheet (Sheet 1) has 24 rows of data (through column X) and unique data begins in row 2 with column headers in row 1. I am considering placement of the checkboxes in either row A or row Y.
The second sheet (Sheet 2) would have the same column headers populated in row 1, with four additional column headers in columns Z through AC. Once all applicable rows have been selected via checkbox, the user would press a VBA-enabled button that would copy only the selected rows into Sheet 2, without producing any row gaps in the data.
The idea behind the macro is to enable users to select a specific set of data from a much larger population, then answer questions / assign attributes about only the selected data set on Sheet 2.
I'm sure I'm omitting relevant details, so please feel free to ask questions to fill in the blanks. THANK YOU!!!
I am looking to deploy a macro that would utilize checkboxes built into every row of data, that would enable the user to select specific rows to be copied over into the next sheet. The source sheet (Sheet 1) has 24 rows of data (through column X) and unique data begins in row 2 with column headers in row 1. I am considering placement of the checkboxes in either row A or row Y.
The second sheet (Sheet 2) would have the same column headers populated in row 1, with four additional column headers in columns Z through AC. Once all applicable rows have been selected via checkbox, the user would press a VBA-enabled button that would copy only the selected rows into Sheet 2, without producing any row gaps in the data.
The idea behind the macro is to enable users to select a specific set of data from a much larger population, then answer questions / assign attributes about only the selected data set on Sheet 2.
I'm sure I'm omitting relevant details, so please feel free to ask questions to fill in the blanks. THANK YOU!!!