ExcelBanter - How do I get info from one sheet to autopopulate into all sheets?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get info from one sheet to autopopulate into all sheets? (https://www.excelbanter.com/excel-discussion-misc-queries/149264-how-do-i-get-info-one-sheet-autopopulate-into-all-sheets.html)

Mary

How do I get info from one sheet to autopopulate into all sheets?

Gord Dibben

How do I get info from one sheet to autopopulate into all sheets?

Add links from Sheet1 to the other sheets.

Select all sheets other than Sheet1 by selecting next sheet then SHIFT + click
on last sheet.

In a cell on activesheet enter =Sheet1!A1 and drag down and across.

Ungroup the sheets when done.

Gord Dibben MS Excel MVP

On Fri, 6 Jul 2007 15:20:02 -0700, Mary wrote:

All times are GMT +1. The time now is 11:45 PM.