Import data from sheet into calendar

[squirrellydw]

I would like to be able to import some of the info in the screenshot into the calendar below. The calendar is found in excel, and can be found by typing in Calendar, it's called "Any Year one-month calendar1"

I would like to be able to import the last 3 columns into the correct date on the calendar but I wanna be able to pick what gets imported. For example only Seats 100 or more.

So April 1st, would list
DFW-190-0519
ATL-110-0605
CLT-128-0616 etc.

Is there an easy way I can do this? You guys have helped me in the past and I hope you can do it one more time. I can copy the data onto another tab of the calendar if that make it easier. I'm just looking for an automated way to do this.

Thanks

 

[squirrellydw]

Load the Userform and select the month that you want to show data for.

Where do I find the UserForm? Sorry, I've never did this before

 

[HighAndWilder]

Where do I find the UserForm? Sorry, I've never did this before

Press the ALT key + F11 keys on the keyboard to open the VBA quickly. This will open the window displaying the Visual Basic Application.

See Image below.

 

[squirrellydw]

thank for the help but I can't get it to work. I will just give up on this idea

 

[HighAndWilder]

thank for the help but I can't get it to work. I will just give up on this idea

Don't give up after people have spent time trying to help you.

Have you been able to get into the VBA Editor yet and can you see the frmSelectMonth Userform?

Has the tblFlightData table got data in it?

How many months does this data cover?

 

[squirrellydw]

Don't give up after people have spent time trying to help you. Sorry just frustrating that I can't get it to work

Have you been able to get into the VBA Editor yet and can you see the frmSelectMonth Userform? Yes I can get into VBA but I don't see the userform

Has the tblFlightData table got data in it? I copied my data of to it

How many months does this data cover? I just need one month at a time

 

[HighAndWilder]

See image.

Does what you see in the VBA Editor look like this?

Will your table only have one months data at a time?

 

[squirrellydw]

See image.

Does what you see in the VBA Editor look like this?

Will your table only have one months data at a time?

This is what I see, yes one month at a time

 

[HighAndWilder]

This is what I see, yes one month at a time

You seem to only have the Properties Window open.

Click on View and select Project Explorer.

 

[squirrellydw]

You seem to only have the Properties Window open.

Click on View and select Project Explorer.

ok now i get this

 

[HighAndWilder]

ok now i get this

Cancel that and follow the instructions in Post #22. See the image.