Marcos and Validations

[Andy Whittaker]

I am trying to create a spreadsheet with a validation table in it tha
when I choose one of the items in it, it will run a macro to fin
certian info in a seperate table below.

I have put the autofilter on the second table but can't work out how t
link the macro and the validation table.

Someone please help!!!!!!!

Regards

And

 

[Anne Troy]

You don't need a macro, Andy. Usually, we create a table and use a vlookup
with a dropdown. Please see this tutorial:
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Andy Whittaker"