Good afternoon everyone,
I'm trying to create a summary sheet in excel based on a view I have in an SQL server. I can link the data to the "data" tab and do sumproduct formulas based on the 2 criterias but not 3 if the third can be "null".
I'm attaching a zip file of the excel spreadsheet, a PDF of what MS ACCESS gives me and the VB code I have to populate the text boxes in ACCESS.....but they would rather have it in Excel (not everyone has ACCESS)
the data tab are the 0's, 1's, Hospital names and unit names and date
the summary tab is where I want them to choose the criteria and click a button called "Refresh" to show their data.
Then they would have to enter their missing links.'
Any help would be appreciated!
Larry
Bookmarks