Calendar & Buttons

Originally Posted by Everstrivin

for the other spreadsheet insert a column in front of the data and add the following:

MID(B1,IF(RIGHT(LEFT(B1,FIND("-",B1)-2),1)=" ",FIND("-",B1)-1,FIND("-",B1)-2),IF(RIGHT(LEFT(B1,FIND("-",B1)-2),1)=" ",5,6))

in as the formula in column A, then use the same Data->Filter->Autofilter, then as you sort or filter column A by date, you see what you need.

If this is not answering your problems, please attach a workbook containing sample data for us to look at.

Have a great day.

I don't think this did what I was hoping, but I very well might be misunderstanding.

I didn't realize I could attach the document to a post. Can't normally do that in forums. Let me try that and see if it makes more sense that way.

Thanks.

Ok, I think I attached them. These 2 are the calendar and then the datasheet that I want to manage it with.

Ok, and here's the more pertinent of the 2 "projects". You can see on the front page (tab) that there are numerous products, each having their own 6x4 cell range. I want to be able to hide them from the outset of opening the document. Like a button that pops up asking what products (cell ranges) to include or to show.

I have created the userform for the hidding rows workbook. I will look into the calander one later. Overall, I think your spreadsheet needs to be designed better. If you would like some suggestions just let me know.

Forgot to attach it.

Sorry, I ran it a couple of more times and I noticed it was cutting the PO numbers off of the top of some of the entries. Use this one.

Originally Posted by Everstrivin

Sorry, I ran it a couple of more times and I noticed it was cutting the PO numbers off of the top of some of the entries. Use this one.

Man, I love that! Only problem is it's asking for the products, but giving the PO numbers to choose from.

Originally Posted by Everstrivin

Sorry, I ran it a couple of more times and I noticed it was cutting the PO numbers off of the top of some of the entries. Use this one.

One more thing Everstrivin. I messed with it a little and found that the Isopropyl Alcohol 99 stays on there even if it's not selected. This looks great though, man. I think we'll definitely be going with this.