K
Ken Frost
I would like to copy a group of rows from one workbook to another - The
second workbook has formulas along the bottom to do various sums etc on the
block of dat at the top - I want to copy and paste different blocks from
various sheets and the print the new sheet with the sums - The blocks are
always in the same format but have different numbers of rows so when I copy
and paste them I highlight the block to be copied and then highlight the
block of data to be Replaced and then choose Paste - Hoping that the
highlighted block on the second sheet will have it's data replaced with the
new block - but this does not seem to work - if the blocks are different
numbers of rows I either end up with the new data followed by a few lines
of the old or if the new block is bigger it overwrites my sum formulas -
Any ideas would be a grat help.
Thanks
second workbook has formulas along the bottom to do various sums etc on the
block of dat at the top - I want to copy and paste different blocks from
various sheets and the print the new sheet with the sums - The blocks are
always in the same format but have different numbers of rows so when I copy
and paste them I highlight the block to be copied and then highlight the
block of data to be Replaced and then choose Paste - Hoping that the
highlighted block on the second sheet will have it's data replaced with the
new block - but this does not seem to work - if the blocks are different
numbers of rows I either end up with the new data followed by a few lines
of the old or if the new block is bigger it overwrites my sum formulas -
Any ideas would be a grat help.
Thanks