Repeat same data entry to multiple worksheets without Group Functi

  • Thread starter Thread starter vstar
  • Start date Start date
V

vstar

Can anyone help

How can I add data to one column of a worksheet and have the data
automatically add to the same column of several other worksheets without
having to group all the worksheets each time I enter data.

Thanks
 
See help on linking from one sheet to another.

Basics........................

Select Sheet2 through Sheet5

On Sheet2 enter =Sheet1!A1

Copy down as far as you wish.

Ungroup the sheets. Start entering data in Sheet1

If you don't want to see zeros, use =IF(Sheet1!A1="","",Sheet1!A1)


Gord Dibben MS Excel MVP
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Cannot copy worksheet to another file 2
Inserting Columns Across Multiple Worksheets 4
Excel grouped data 2
Combining data from multiple worksheets into one 4
consolidate data in pivot table 1
Lookup Data Across Multiple Worksheets 4
multiple worksheets 1

Back
Top