Help, please with my dillemma... this particular project is almost finished and this is the final hurdle.

I currently have two worksheets within a workbook. I key a number of pieces of information into worksheet (A) and then use an macro to copy a number of ranges from Worksheet (A) into Worksheet (B)

My problem is that the macro is constantly overwriting the previous information it has pasted into Worksheet (B), I was wondering - whether anyone knew of any neat tricks - to get all of the data into Worksheet (B) safely (when the sheet is updated). I have attempted to create a number of rows at the top of Worksheet (B), to avoid the problem. However the code takes it a bit extreme and loops, constantly based on the range I selected on the previous sheet. Any help would be appreciated.

Dim Mycell as Range

For Each Mycell In Selection

Range("B7").Select

Selection.EntireRow.Insert

Next Mycell