I have been working on this formula for a while but cannot seem to get it correct.
I have 3 sheets.
Sheet 1 - some codes and dates to be used in Sheet 3 in dropdown lists. Simple enough.
Sheet 2 - the data (column A is Family Code, Column B is Item Code, Column 3 is # Sold, and Column D is Date Sold. There are about 200 rows with duplicates of item code.
Sheet 3 - I need a report based on the following:
I would like the user to select the family code, the report start date and the report end date from dropdown lists. This would in turn display the item code and the total number sold (from highest to lowest OR I can sort later).
How complicated is this? I was hoping to keep this simple for the user.
Here is the link to the file: http://www.savefile.com/projects/808690911
Any help would be GREATLY appreciated.