From: Rick on 9 Oct 2009 17:39 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
|
Pages: 1 Prev: IF and VLOOKUP formula combined together Next: Counting coloured cells |