Help to get data in a table feed through to excel calendar on a separate tab

Copper Contributor

Hi All,

 

I was hoping one of you many experts would be kind enough to help me...or to let me know if what I am trying to do is to complex/can't be achieved.

 

As a student to make life easier (and simpler), with many deadlines and to ensure I am on track to completing assignments, I was wondering if there was a way to input data into a table, with subject name (Cell A1), 1 month to due date (Cell B1) and Due Date (Cell C1) and have this information automatically feed through to a calendar which has been created on a separate tab.

 

I have attached some screenshots of what I am trying to achieve, the calendar screenshot has been keyed in manually but wondered if there was a way this data could automatically be pulled through.

Please let me know if you have any questions or need anything else from me!

Thanks all! :)

0 Replies