Extracting specific date from Inventory list

Keeping it simple I would just filter on the sheet you have.

To get list

Please Login or Register  to view this content.

to return the sheet to normal

Please Login or Register  to view this content.

and maybe add the code to a couple of buttons one to format, one to set make to the original

obviously the data range can be expanded from 2000 if needed

Dav

You guys are awesome! I hope I can get it done from here, wouldn't know what to do without the support I can get here.
Thanks to both of you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Hi bakerman2,

I am sure my next little problem will be easy to solve but I am having a hard time.
I am using your code to gather data from 3 sheet (I just copied the code and changed the sheet name). My problem is that at this point I am setting the start place for the next sheet by typing the cell (A289) ect.
But I don't always have that many rows filled. Thus, how do I make the makro find the next empty cell by its self?

Thanks Amy

Maybe after the end with replace the line with this

Please Login or Register  to view this content.

Thanks, works great. I had it the wrong way around when I tried it myself