"DrB" wrote
Now I want to paste into cells but keep B2 the same and allow A to change
as I paste along the row...

Use Biff's 2nd option, with the point to B2 fixed
In the starting cell: =INDEX(A:A,$B2)
Copy across
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---