Excel 2007 : Column data transfer and automatic data deletion

**shelbert13** · 06-14-2012, 12:37 PM

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.

I'm sure I will have more questions on the project but these are my two main obstacles at this point. I feel like it should be a relatively simple solution I can't seem to find the answer in any resources though, everything else seems to be a higher level code.

Thanks for any and all Ideas/solutions!

**dilipandey** · 06-14-2012, 01:09 PM

Hi shelbert13

Welcome to the forum.

Suggest you to change the title of the thread to reflect the query being asked in there.. see the forum rules:-
http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

**shelbert13** · 06-14-2012, 01:51 PM

Thanks for the welcome! Sorry about that

**shelbert13** · 06-18-2012, 09:32 AM

Hello all,

Still working on my project, ran into another thing I'm not sure about.

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.HandleData (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

**shelbert13** · 06-19-2012, 12:24 PM

Would like to have this thread removed as I feel the Programming with excel/VBA forum is a better venue for this question. Will be taking my questions there.