[VBA]- Creating a semi - automatic summary/record page.

[RandomInteger]

Hello,

I have most likely a relatively simple problem, however being a novice at VBA, I don't know where to start. Simply I would like to be able to remove data from one dynamic sheet, when a certain colour option/string/checkbox is selected. Then create a summary on a separate page. It has to be able to do it in order, of deletion, so add to the summary page in the order of which it was deleted.
I was thinking that you could just copy everything over and delete repeated and sort by say date, but the code might run too slowly. I'm sure there is a more efficient way.
I have attached an example to as how the data will be lain out. An extra column with a radio button could be added - however if this option is added is there a way to bring up a command box with ok/cancel options? So if you accidentally tick it, it won't automatically delete the entry.


Thank you for any assistance.

[RandomInteger]

Okay I have something that copies, but surely there is a better way. And how do you add that other functionality in. I want to be able to tick them, and then press the summary button and have them deleted and copied onto the other page.

Please Login or Register  to view this content.