I need a macro which will look up a value in a cell, then copy data from a
range of cells and paste them into a specific location in another worksheet,
delete the original data. I need to do this several times always picking
data up from the same range of cells but pasting into a new location every
time. Please help as I'm bald enough as it is!!