I have a reference to another sheet and I need to copy the reference like this:
sheet 2
A B
1 ='sheet1'B1 ='sheet1'B2
2 ='sheet1'E1 ='sheet1'E2

if I try to copy/paste or fill I get b1, b2, b3 going down which I don't
want - I know I can do this manually but I have about 100 rows each approx 10
columns to fill like this.