Automatic Update in Multiple Worksheets

R

Rick

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
 

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

multiple worksheets 1
Excel merging and automatic edit of worksheets 0
Auto update worksheets 2
Main Form - copy exact data from multiple worksheets with live lin 1
combining data from multiple worksheets into one 6
Auto update worksheets 6
Syschronizing cells across worksheets 1
Multiple VLOOKUP in an IF statement 2

Top