VBA autofill info down to bottom of data set

I've got a macro where I'm trying to do the following:

1. Format the information in the "CleanData" tab
2. Copy the data into the "Raw Data" tab at the bottom of the current data set
3. Input a value into the "Week" and "Year" column of the "Raw Data" tab and then copy those values to the bottom of the data set that I just copied down

the following VBA code is what I have so far:

Please Login or Register  to view this content.

The issue I'm having is once I get to the "Selection.AutoFill Range(ActiveCell.Address..." - I can't find a way to select the two cells I've just input data for and then autofill the data in those cells to the bottom of the current data set. Note that I'd like to be able to do this several times so the data set will continue to grow and grow. Any help is appreciated - thanks in advance!!

Well that did it, thanks so much!!!