Automatically extract data with the same date to another worksheet

[danallamas]

We are currently working on a sales report. I'm using excel 2010 and I could not seem to figure out how to copy and paste the rows on the same date to another worksheet. I've attached the file I am currently working on and I hope you guys could help me.

Also, is it better if I select the date it would automatically direct you to the the Raw sheet (that contains all the data) and filters it. How? Thank you in advance

[smuzoen]

The easiest way to be to Autofilter the data in place then copy the visible cells to the destination sheet. Autofilters will often fail on exact date hence filtering on >= date and < date +1 so you need two criteria in autofilter. In this case I have hard coded a date but I would pass it to the sub as a parameter - to use the date (passed as a string) as a filter criteria convert it to a "long" and use this as the final criteria for the filter

Please Login or Register  to view this content.

[apo]

So you want to be able to Select a Date.. and then copy all the rows that have that date from the "Sales Report (RAW)" sheet to another sheet.. is that correct?

Which sheet do you want these rows copied to?

[danallamas]

Yes I need to be able to copy all the rows from Sales Report Raw to MPA. The data must be copied below the date. if its possible, still below the date but to another column. I hope I was able to make myself clear