Sheets 2 and 3 can have formulas that link to sheet1

Select both Sheet2 and Sheet3

In A1 of Sheet2 enter =IF(Sheet1!A1="","",Sheet1!A1) which will also be
entered into A1 of Sheet3

This can be drag/copied around.

When done, ungroup Sheet2 and Sheet3

For more on linking cells, see linking cells in help.


Gord Dibben MS Excel MVP

On Tue, 4 Dec 2007 07:50:01 -0800, Cindy
wrote:

I need the info from page one of the workbook to automatically go to pages 2
& 3 how would i do this