Hi folks,

I've got a bit of code (see below) that looks up sheet "manacs figures" in
workbook A, copies a range, finds sheet X in workbook B and pastes the
values. It then goes back to the same sheet in workbook A and copies another
range (usually column next to it etc) and then pastes to sheet Y in workbook
B.