Hi,
I am not having much luck with this:
I am trying to return the top N purchases based on a client ID.
Sheet 1: Account Summary
Sheet 2: Master_Territory contains table Master_Table (Customer #, Name, etc)
Sheet 3: Client_Purchases contains table cPurch (Customer #, Customer_Name, Line_Name, Line Code, Net Sales)
Sheet 1 to display based on Customer Number selected on Account Summary:
Line_Name
Line_Code
Net Sales