Columns repeat on different sheets

Copper Contributor

Hi.  I want to have the first two colums of the front sheet repeat on all of the subsequent sheets.  How do I make this happen?  

Thank you in advance.  

1 Reply
Could you just link the cells? So in your second sheet have A1 be =Sheet1!A1 and A2 be =Sheet1!A2 and so on? Do they need to be dynamic? Copy and pasting would be easier. You can highlight (control click) multiple sheets to make changes to multiple sheets btw.