To summarize I have a excel spreedsheet that lists customer status's. I have an access data base that I query to get a $$$ amount associated to every customer (this is put in a new sheet onto the workbook).

what I would like to do is automatically name the $$$ amount cell for each customer so I don't have to define the name for 300+ records myself. Then when I hit the REFRESH data field each week, all $$$ are updated on all other sheets (of course after I change the reference on the other sheets.

then I will use the customer define cell names to automatically change the $$$ for customers on the status sheet in the workbook.

I'm not sure if this is the best way to do this or there is a better way to do it.

Hope this makes sense and thanks for any help
z