Drag and drop,VBA

[luis87]

I have several mickey mouse formulas in different rows that take different data from the file, i usually select all the formulas and do a drag and drop to the last cell, is it possible to select all those formulas and determine the range of used cells in the filesand copy them to the last range of cells with info. I don't know if i made myself clear or need further explanation. Of course i'm trying to do this with a VBA code.
Thanks in advanced

[rwgrietveld]

The last cell is defined, so that is possible.

What kind of info. Should this be a Comment in those cells?

[luis87]

So this i how i got the report, in the yellow range are a bunch of cells with formulas that i use the get mora data, in the gray range there are cells and that is the column that will define the last to which the yellow cells will be copied. Now i need to know if it can be done to copy that range of yellow cells(the first row is the header)with formulas automatically in a way that the macro detects the last cells with data and copy that selection of cells.

PS: Couldn't upload the file but here is the link to the info
http://rapidshare.com/files/340917507/Book.zip.html

[luis87]

No ideas?,at least a theoretical procedure?

[Markusc]

To find the used portion of a spreadsheet you can use activesheet.usedrange