List View Dates into a Calendar Template

[asacco]

Hello,

I have multiple excel spreadsheets with dates and what they pertain to, however I want those dates and important information to go into a calendar template that I have already used in the past. I want to avoid having to manually put these important dates in a Calendar. If anyone has any idea how to do this that would be great!!

 

[baitmaster]

welcome to the board

you'll have to give a clearer requirement. It sounds possible but we know nothing about your files

It would be possible to set up a VBA loop that looks through all the files in a specific folder, or only those with a certain name etc. The code could then look at the file name, or open the file and look at a specific range, whatever, and then pull data out if found and place it somewhere. It may be that this just creates a data table that you then analyse using formulas, or it may be that the code can place the values directly to your calendar - but again, we know nothing about this calendar so you'd have to give more details

Lots of people on here could do this, but you must write a clear and specific requirement. Use e.g. dropbox to share example files if you need to