Videos | Books | What's New | FAQ | Testimonials | Buy Credits | Support | Login | My Account

Dynamic References to External Spreadsheets Added to Library on 23 May 2007 Length: 5 mins View Tutorial Movie Download File Used This tutorial show how you can create a dynamic reference to another spreadsheet based on parameters in your spreadsheet. The example uses the results from an Excel based questionnaire and fills all the results into a single spreadsheet without any cutting and pasting of data. All 3 files used in this tutorial are available for download. Feedback for this tutorial: "I can't wait to go and practice this so if and when I do find a need to use this function, I will have it nailed down!" "Fantastic. You put your examples in a very clear manner. I will certainly try this at the next opportunity All we want now is to ensure the user/s does not modify the cells etc.... Cheers Pikey" "Nifty trick done with excel without VBA!"