Formula for All invoice numbers in Drop down list for specific company

[rajeshn_in]

Hi friends,

I have a sheet with many companies and invoices numbers, I want specific company invoices numbers in drop down list.

Please see attachment for better understanding.

Thank you.

[BadlySpelledBuoy]

In the attached I've used the below formula in cell N2 and copied down:

Please Login or Register  to view this content.

This is an array formula and needs to be confirmed with Ctrl+Shift+Enter.

It creates a list of Invoice Nos. based on the buyer selected in H1.

This list is then used in a dynamic named range (Press Ctrl+F3 to bring up the name manager to see details on that) which is used to drive the data validation in H2.

Hope that helps.

BSB

[Greg M]

Hi there,

See if the attached workbook does what you need.

It uses the following code in a standard VBA CodeModule:

Please Login or Register  to view this content.

and the following code in the VBA CodeModule of the worksheet which contains your data:

Please Login or Register  to view this content.

The highlighted values may be changed to suit your own requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[tim201110]

=OFFSET(INDEX(l!$M$2:$M$26,MATCH(l!H1,l!$M$2:$M$26,)),,1,,SUM(--(LEN(INDEX(l!$M$2:$AI$26,MATCH(l!H1,l!$M$2:$M$26,),))>0)))

[rajeshn_in]

Thank you friends.

[Greg M]

Hi again,

Many thanks for the Reputation increase - much appreciated

Best regards,

Greg M