Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Top N Values - Multiple Worksheets

0

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

excel
MS Office Version: 2016
posted by: Coachbambam on Thu Feb 7, 2019 at 3:24 pm
Answer
Discuss

Discussion

This is too much like work and too little like Q&A. Find one explicity question you would like to have answered and indicate the source of referenced data in your question rather than in some probably faulty formula hidden in a worksheet.
Variatus (rep: 4889) Feb 8, '19 at 8:04 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login