I am copying large summary reports from a stress analysis program into a worksheet, by clicking on cell A2 and pasting from there. The information is overwritten every time you paste the information from the program, at least as much as is copied in.

Say I delete a node of the analysis, now there is one less entry in the list that I copied and pasted. When this happens, I’d have to scroll to the bottom and delete out any information that I know is from the previous run.

Is there a way that I can have this extra information at the bottom deleted when I do my new copy/paste? The only thing I can think would be to delete all inputs each time before pasting the new information, but it makes it harder to see the changes and is extra keystrokes for fast checking.