microsoft excel training - Excel cell references with a skip

Hi Minnaar. Sorry for the delay. The simplest way to achieve this would be to create the following list in a text editor:

=Sheet2!A1
0
=Sheet2!A2
0
=Sheet2!A3
0

(You could create the A1-A100 list in Excel, paste that out into Word and then using find & replace, replace every "A" with "=Sheet2!A". Then replace every paragraph mark with a paragraph mark followed by a "0". Sounds fiddly, but it's the quickest way to create this list)

Then select A1 in Excel and paste as text from the clipboard. The formulae should be active. Then do using find and replace, replace the 0 with " ". Then you have you worksheet.
Hope this helps

Anthony