Data handling and VBA functions (Automation of task questions)

Hello everyone, brand new to excel coding and VBA and I had a few different questions I was hoping I could find some help with.

1. How would I transfer a column using VBA from one worksheet to another.

( I was planning on looping through the column and ending once I reach a blank cell, then transfering the data over, but I'm not entirely sure how to do this because I have very limited knowledge of the VB language.)


2. I'm importing data from a sharepoint calender, how could I have it import the data, then automatically delete the data I don't need.

Is there a way to automatically have my functions called and ran as soon as the data is refreshed? I suppose that would be the same as deleting the data I don't need automatically.

I was thinking having a button to refresh data, and then when pressed doing something like (pardon my syntax this is rough conceptual code and in no way actual VB)

on click

worksheet1.delete(,"D","E")
call function.SplitNames (It's a bit of code I figured how how to seperate data inside of my column C into 2 seperate columns which become C and D)

Thats the point at which I'm stuck as it now gets really difficult. My manager wants to be able to input all of the names of his employees into this calender, so I need to allow that to be feasible, then I need to be able to have my program cross reference Column C of Raw Data, with Column A of Displayed data, and if they match then it will have to cross reference Column D of Raw Data, with Column A of Legend, and if they match display the marker in Column B. Then I need figure how to display that marker in the appropriate dates from Columns A and B of Raw Data.

Also in the mockup, would anybody know of a good way to automatically generate that calender?

If anybody has any solutions/feedback or a direction to head for sources that may help I'd greatly appreciate it.