View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default enter data once... copy to multiple cells on other worksheets

No need to copy. Just link:

If data is entered in A1 on Sheet1 and on Sheet2:

=Sheet1!A1
--
Gary''s Student


"Larry G" wrote:

I am working with a mutliple worksheets in an Excel workbook and I can't
change design. I want to enter data once in worksheet #1 without having to
enter identical data into cells on 12 other worksheets in the same workbook.
It's crunch time... I can't remember how to do this. HELP!!