PDA

View Full Version : copy and paste based on a value present in two sheets



emjaywil
11-15-2018, 04:33 PM
Hi.

I have a worksheet (sheet1) and wish to copy a section of data (B4:Q5) andpaste this into another sheet (sheet2)
The destination is where I am stuck.


Each test has a unique ID, this will be present in sheet1– but will change depending on whos results are in sheet 1


Sheet2 is a full list of results for every test, eachwith its unique ID (A1:A700)


I have been trying to find a way to copy the values from sheet1 and paste them into sheet2- one cell to the right of the correspondingunique ID (so as to not paste over the top of it).





Any help would be much appreciated!
I have greatly simplified this all, but this will at least give me a start.