SOS ~ Retreiving data from access (based on customer id)

[vikash123]

Hi,

I am trying to link my spread sheet with an access file which has details of several customers and each customer has a customer id (customer id is not unique - one customer can have more than one row of data if they buy more than one product) followed by customer details.

I need to ensure that excel asks me to enter the customer id and if a correct customer id is entered, it should pull ONLY that customer id's details.

I am a dud with macro's so if macros are needed to solve this please advice how I write that macros.

I need this tool for a IMPORTANT / URGENT project for work.

Appreciate your help

Vikash

 

[Andrew Poulsom]

Look here:

http://www.dicks-clicks.com/excel/ExternalData6.htm#Parameters

http://www.dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/