Excel: Equal Columns

[Guest_imported]

I have 2 sheets in my workbook. In Column A of Sheet1, I have a list of about 20 names. Is it possible to make Column A in Sheet2 equal to Column A in Sheet1, so that the list of names in Sheet1 automatically updates in Sheet2? I tried just making every cell in Sheet2 equal to the other sheet (i.e. =Sheet1!A1, =Sheet1!A2, etc.), but that causes a problem when I add/delete rows in Sheet1.

Any help would be GREATLY appreciated!

Thanks in advance.

 

[LeKirk]

Click on the tab for Sheet 1, hold down SHIFT and click on tab for Sheet 2. You have grouped the worksheets togeter. Whatever you type into a cell on Sheet 1, will show in the same cell on Sheet 2. BE WARNED. Do not forget to ungroup when you've finished otherwise all your worksheets will be the same. To ungroup, click on a third sheet tab

 

[Dreamboat]

I have a different question. Why would you want to repeat the data? Perhaps you can put the same data in the same worksheet and hide/unhide the columns when desired. Or other alternative we could come up with if we knew why you want to repeat your data.

http://www.TheWordExpert.com