View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rick is offline
external usenet poster
 
Posts: 334
Default Automatic Update in Multiple Worksheets

I am trying to setup worksheets that stem off of one master worksheet to
automatically update data on all worksheets when entered into the master
worksheet. I don't want to just input =sheet1!A1 because then it returns null
values which mess with another sheet and my charts. Basically I want a way to
update without #NA everywhere and drag and drop through multiple sheets
Thanks