Thread: Difficult Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pluggie Pluggie is offline
external usenet poster
 
Posts: 23
Default Difficult Macro


Hi,

I have 3 sheets.
Sheet 1 contains a 1-Column list of Customer_ID's
Sheet 2 contains a 2-Column list of Product_ID's and Product_Descriptions
Sheet 3 is empty.

The result of the macro I want is (in Sheet 3)
A 3-Column list of Customer_ID, Product_ID and Product_Description where
each customer has a full set of products.

Unfortunately, the list of customers, aswell as the list of products will
vary in length each time the macro has to be run.

How do I do this?