Copy and Paste

[longytravel]

Morning,

I'm new to all this VBA stuff! Very interesting!

I am wondering if someone can help?

I have data that is on a 'Data' tab and a 'Reports' tab

I would like to be able to run reports based on data in the 'data' tab that will get updated weekly

Can someone please help me with the code to do search based on date and then pull all the relevant rows accross to the 'reports' tab?

So, if i want all rows between 29/07/2011 and 01/08/2011 i can search using an input box and then move all the information over?

The 'report' will then be bordered and sorted alphabettically?

I've been pulling my hair out so any help greatly received

Thanks

 

[longytravel]

Its certainly easy when you know how!

Thank you.

What is the value in the autofilter? I guess i dont need it to autofilter the 'data' page after it has copied it - can that element be removed?

Love the way it carries over the titles with it

If i design a user form for selecting the two dates two dates how would that be written in? Should i be using two text boxes for the dates to be added?

Cheers

M.