How to repeat column headings on sheet 2

[wlarson]

I have an Excel workbook with three sheets. On sheet 1 I have about 30 unique column headings in row A1. I would like to repeat these exact 30 unique items on sheet 2. On sheet 2 how can I referance these 30 items.
Thank you - Walt

[VBA Noob]

Try

=Sheet1!A1

then drag down or across as required

VBA Noob