Hi guys,
Haven't been logging-in here for some time as my current role doesn't involve as much VBA as the previous ones. That also means that I've got rusty and now I found myself in a dead end.
I have a following template sheet with data entries:
<tbody>
</tbody>
There is a userform with checkboxes associated with it. Based on what checkboxes are ticked by the user I need the macro to copy specified rows from template sheet into new one.
Example 1:
User ticks Checkbox 1 only and clicks "OK" on the form. Macro searches for value R1 in column A and copies entire row where R1 is found into new sheet. After macro is done, new sheet should look like:
<tbody>
</tbody>
Example 2:
User ticks Checkbox 1, 3 and 5 and clicks "OK" on the form. Macro searches for values R1, R3, and R5 in column A and copies entire rows where the R1, R3 and R5 values are found into new sheet. After macro is done, new sheet should look like:
<tbody>
</tbody>
Any tips on how to tackle this will be appreciated.
Thank you!
Haven't been logging-in here for some time as my current role doesn't involve as much VBA as the previous ones. That also means that I've got rusty and now I found myself in a dead end.
I have a following template sheet with data entries:
A | B | C | D | E | |
1 | R1 | Data | Data | Data | Data |
2 | R2 | Data | Data | Data | Data |
3 | R3 | Data | Data | Data | Data |
4 | R4 | Data | Data | Data | Data |
5 | R5 | Data | Data | Data | Data |
<tbody>
</tbody>
There is a userform with checkboxes associated with it. Based on what checkboxes are ticked by the user I need the macro to copy specified rows from template sheet into new one.
Example 1:
User ticks Checkbox 1 only and clicks "OK" on the form. Macro searches for value R1 in column A and copies entire row where R1 is found into new sheet. After macro is done, new sheet should look like:
A | B | C | D | E | |
1 | R1 | Data | Data | Data | Data |
<tbody>
</tbody>
Example 2:
User ticks Checkbox 1, 3 and 5 and clicks "OK" on the form. Macro searches for values R1, R3, and R5 in column A and copies entire rows where the R1, R3 and R5 values are found into new sheet. After macro is done, new sheet should look like:
A | B | C | D | E | |
1 | R1 | Data | Data | Data | Data |
2 | R3 | Data | Data | Data | Data |
3 | R5 | Data | Data | Data | Data |
<tbody>
</tbody>
Any tips on how to tackle this will be appreciated.
Thank you!