My workbook is made up of 34 sheets which all pull information from different workbooks and 3 different data servers, 2 Informix, 1 SQL. All of this data then populates my main "Scorecard" sheet.
Question is, can I share the "Scorecard" sheet with others and allow them to refresh the data? Or even better, let them select different dates thru a drop down list and have the sheet refresh?
Question is, can I share the "Scorecard" sheet with others and allow them to refresh the data? Or even better, let them select different dates thru a drop down list and have the sheet refresh?