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]

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

I get this error

 

[HighAndWilder]

I get this error

First try it with the workbook including the data that I gave you and then post a mini-sheet of your data using XL2BB.

 

[squirrellydw]

First try it with the workbook including the data that I gave you and then post a mini-sheet of your data using XL2BB.

that seemed to work, but I can't use the XL2BB at work

 

[HighAndWilder]

that seemed to work, but I can't use the XL2BB at work

I get these Userform month options.

Are you using the workbook that I provided just as I provided it?

See attached image.

 

[squirrellydw]

Yes, I didn't change anything on it. Any other ideas?

 

[HighAndWilder]

Yes, I didn't change anything on it. Any other ideas?

I've never had those opytions come up.

Can you post the workbook back to me somehow?

 

[squirrellydw]

I've never had those opytions come up.

Can you post the workbook back to me somehow?

not from work I can't, when I get home later tonight I might be able to