Confusion with VBA and macro

[reforming_giant]

Hi All,
First post here. I am having some trouble with a macro I created. Basically I have a table in sheet 1 from A20 - Z20. The figures in that table change daily, I need to copy the figures one column at a time from 1 - 20 and then paste them into the one column on sheet 2. So for example Today I needed to paste A1 - A20 from sheet 1 into E10, then I need to to take B1 - B20 from sheet 1 and paste it directly below the data in column E of sheet 2. This continues for all the data. I have a simple macro that does this automatically, my problem is that in sheet 2 there are WTD and MTD totals and my macro posts the new data after the MTD totals instead of the next available date. Is there a way to make the data paste into the first empty column instead of the next empty column. Here is a sample code that I am using, the cell references don't match what I described above but the code follows the same principal.

Please Login or Register  to view this content.

[stnkynts]

You post contradicts itself on many occurences. Please review your post to ensure its accuracy.