range change

Hi All, I've an array in one excel file from which i'm trying to copy rows to other excel files, basically from my source file i'm copying each row to within a table to different destinations Excel files, the destination rows is fix but I need to loop through my roughs on the source file which...

I am trying to use the countif function to gather data, I have a large number of columns that will need to have the countif function. As illustrated when I try to copy the functions across row or columns the range shifts. I tried both copy and paste as well as dragging the functions but neither...

If I have a spreadsheet that sums a column of the rows above it, I obviously have to refer to the starting row/cell, say A3. I then refer to the ending row/cell, say A10. My problem is that my users will insert new rows above row 3, but my formula says start at A3. If there is a value to be...