I have worksheet 1 that has some data in a column. I want to copy this
data in to another worksheet 2 that starts on column 4, row 5, but only
the first 4 characters of the data should be put in this cell....and
then I want to have it run in a loop so that it copies the entire
column from worksheet 1 to worksheet 2 in that same fashion (same
column, but increments the row)....How do I do that? Also, how do I
clear out a range of data that starts at B4 and then goes down the
column?

Any help would be appreciated!!! I'm pretty new to excel macro writing