Extracting data from one sheet to another between 2 dates.

**redoscar** · 06-04-2013, 06:23 AM

Hi everyone

I need a little help.

I have data sitting in a sheet that I would like to copy through into another sheet. I would like to be able to enter 2 dates and for only the data between those 2 dates to come through.
I would then like something resembling a tick box next to the information. When I tick the box next to any row, that row changes colour and cannot be altered without a password.
Also, when the row changes colour, it moves to the bottom of the list.

Any help on this would be extremely appreciated.

Regards

Andrew

**Will B** · 06-04-2013, 06:50 AM

You're going to need some VBA for that by the sounds of it! I would suggest posting your question in there very clearly stating your aims and possibly uploading an example,

**redoscar** · 06-04-2013, 07:33 AM

Thanks Will

I'll do this now

**redoscar** · 06-04-2013, 07:34 AM

Can someone tell me how to close this thread please

**Gopinathak** · 06-04-2013, 08:46 AM

1. If your question is resolved, mark it SOLVED using the thread tools
2. Click on the star if you think some-1 helped you

**arlu1201** · 06-04-2013, 09:16 AM

WillB and Redoscar,

In future, you can send a PM to a moderator / admin to move the thread for you or you can click on the black triangle below the 1st post asking the thread to be moved. Do not create the thread in multiple forums.

Duplicate thread, hence closed.