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

G

Gord Dibben

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 <[email protected]> wrote:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a Macro to combine 1-5 sheets in one sheet 1
how do i loop thru all the worksheets in 2 files one by one 0
How to automatically paste cells from one sheet to another sheet? 1
i need to save the same header to use on all worksheets in a workb 0
how do I merge total from many pages into one main page in excel? 0
how do i combine data from multiple sheets into one sheet? 3
How do I reference the same cell in all previous sheets? 3
Assign a macro so I can just single click it to run it 0

Top