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