Calendar & Buttons

I would like to help you with this, it sounds like a userform would help. Could you post a sample of what you are doing?

Send a sample file and we'll see

Not sure how to post an example, but here it goes:

Re: #1, the coversheet. The corresponding labels dictate what goes onto the coversheet. Say a label has the following information.

Barsol A-3488
332 Lbs./Drum
RM##-####-####-#
Lot # CB021309
PO USMMMFR###
Rel. # 18-Mar-09

Then in the rows that are referenced from this information would look like this:

Re: PO No. USMMMFR###
Release No. #
Product: Barsol A-3488
RM: ##-####-####-# Issued 01/05/99
Quantity: 48 Drums (15,936 Lbs.)
Lot Number: CB021309

It was told to me that macros should be able to do this. Do I need to physically type out exactly what I want macros to record for each product (there are 9 of them) and, if so, is there a way to print out the coversheet with the formulas displayed so I can type that in without flipping back and forth to the other tabs while I'm recording the macros?

Re: #2, the calendar. The datasheet dictates what appears on the calendar. The datasheet would look something like this:

Customer City Profile # P/U Date Driver Qty
International Sensor S Aurora 97120119 5-Mar Tony 1
Knight & Carver Howard 2007110136 5-Mar Gene 7
Midland Packaging Lincoln 98040206 5-Mar Nick 2

Then I would want my calendar, for example, on the 5th of March, show me
International Sensor S, Aurora, 1
Knight & Carver, Howard, 7
Midland Packaging, Lincoln, 2

This one, I'm being told, is easier to do than the other idea I have. It was also suggested that I may be able to easily use Outlook instead of Excel. I use the calendar feature in Outlook often, but I don't know how to reference off of a spreadsheet onto this calendar.

For your first sheet, try adding a column in front of the data with the customers name and then go to the Data menu and choose Filter->Autofilter, you can then choose which customer or customers to print.

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.

Originally Posted by Everstrivin

For your first sheet, try adding a column in front of the data with the customers name and then go to the Data menu and choose Filter->Autofilter, you can then choose which customer or customers to print.

I'm sorry, I'm not seeing how it allows me to cancel out this block of cells to be excluded from the printout. It gives me dropdown tabs and asks which ones I want, but not an option to clear all. Is there a way, when you open the document, to have cells specified to include or not include?

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.

Yeah, I got it now. In reply to your query about the product vs. PO, I could use whichever one you wanted to sort by. Just let me know.

Originally Posted by Everstrivin

Yeah, I got it now. In reply to your query about the product vs. PO, I could use whichever one you wanted to sort by. Just let me know.

It looks great Everstrivin. Can you sort by product name, i.e. Barsol A-3488, Propylene Glycol, Toluol, etc.?

It's been fun, I have one other project before I can get to your calendar problem. Enjoy!

Originally Posted by Everstrivin

It's been fun, I have one other project before I can get to your calendar problem. Enjoy!

That's awesome man. Thank you so much for your help. Do you think you could do the same thing with this other one? Same customer, different location, fewer products.

Here you go. Also, if you wouldn't mind clicking on the scales for this thread and give me a nice rating, that would be cool. You can wait until I finish with the Calendar before you mark this thread as solved, though.

Have a great day.

Originally Posted by Everstrivin

Here you go. Also, if you wouldn't mind clicking on the scales for this thread and give me a nice rating, that would be cool. You can wait until I finish with the Calendar before you mark this thread as solved, though.

Have a great day.

I didn't know about the scale rating, but I will definitely be tipping it in your favor.

Is it possible to insert calender controls in comboboxes....????????///

excelkeechak what exactly are you looking to do? You can make a range containg dates be the rowsource for a combobox, or you can just use a calendar control.

Omaha,

I hope you are still checking for this. I finally got the calendar working. I put it on one sheet, you just need to select the right month from the drop down, then you can see the results for that month.

The filesize is a bit larger. I sure hope this works for you. I designed it using Excel 2007, but I'm pretty sure the formulas I used are available in Excel 2003 as well.

Enjoy!

Ok, I can't figure out how to tie this in with Outlook or how the other calendar works.

I'm sorry, I have no idea how to tie things into outlook, I don't use outlook except at work because I have to. If you can generate for of those waste logs then this calendar will work for those. I designed the calendar to work for a list from any source with the data you had in your waste log list. It is possible that on a slower machine the calendar will not work. To make it work, it should ask you to find the linked workbook, which should always be open when using the calendar and the filename on the right should match the cell below it. If this continues to not work for you, please describe what is happening. I will see about integration with Outlook while I'm at work.

Cool. I'll tinker with it here at work and see what I can figure out. Thanks again man, this is awesome.

Using the Coversheet/Label spreadsheet for the first time today (officially ).

Would you take a look at this when you get a chance? For some reason the window pops up, but the options are missing.

Originally Posted by Everstrivin

Omaha,

I'm sorry, I haven't logged in for a while. Would you still like me to have a look at what is happening to your workbook?

Basically, when we save it after updating things, it gets messed up. The window doesn't pop up properly. I'm not having any problems as long as I don't save it, but once I do it gets funky after a while. It might be more complicated than you want to deal with since there's shortcuts on different networks that a few people are working off of.

Originally Posted by Everstrivin

Omaha,

Sorry for taking so long, but I think this should work well, let me know if there are any issues. Test it for a while, if you like it, then I will do the other workbook. Also, if you would like me to streamline the code in the other macros, I can do that for you.

Take care,

You're awesome man. Let me give it a test drive and see how it goes and I'll let you know. Thanks a million dude.

Everstrivin, hate to bring this up yet again, but the 3M Valley spreadsheet is throwing me fits now. When I pull it up, the first menu screen doesn't give me any options to have show up on the first coversheet. Not sure where they went or how to fix.

Originally Posted by Everstrivin

Have you managed a solution? I only just noticed your post, sorry.

I have, but others who have access have had trouble. I think it's a shared issue on the server. Doesn't save correctly or the micros get funky when it gets resaved in different shortcut folders that are shared on the server. Still working good for me though!

Thanks!

I need to create a spreadsheet that has 2 workbooks in it. One workbook would be the information that I need populated into a calendar. The problem is, I have 16 departments that I needed color coded or separated somehow to show on one master calendar. I would like it to look like an actual calendar instead of a list. The calendar needs to be a monthly calendar. I know it's possible but I don't know how to do it. I was playing with a pivot table but it's just not what I want.

Can someone please help me?! PLEASE>!

hai...i've been giving an assignment to autopopulate the calendar in excel...let say an employee want to take a leave, the person can just click the date on the calendar and automatically it will show in the excel. how can i do that? all i know is that it needs to be done using VB.

I also have been trying to make a schedule automatically dump into a simple monthly calendar.
I have personnel traveling during the month for different reasons and need a simple calendar showing the number of people gone each day and where they are.
The data comes from a log into which travel requirements are added as they are identified, rather than by date. So everytime I get an additional person going to a location previously logged, I have to resort the log and redo the subtotals in the calendar I so far came up with.
In addition, I frequently send multiple people to workshops/conferences which last several days, but not all persons have to attend every day therefore there is overlap of some days, but not others. I've used an if formula, subtotals, and graded conditional coloring to show when more empoyees are out at one time.
my issues are as follows:
1. every month I redo a new calendar to replace the dates in row 2 for my IF calculations
2. additions to the log do not auto-update the calendar
3. refresh does not work here
4. log data is not continuous because events outside of the current month would take rows in the calendar, although the days would be blank. I have to keep a separate log of all events, and then only dump events that contain any days within the month I am working on.

I am attaching the file (fictitious data used) of my best attempt to illustrate the distribution of out-of-office personnel. Any help/tips in making this automatic, or 'refreshable' would be great.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.