Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

VB Look up by Table Name

AMN3161
Advocate

VB Look up by Table Name

AMN3161
Advocate
Advocate

Is there a way to specify the table in a sheet you want to do the VB look up to? (see attached)

 

That table a few rows down has a table name as BOM but a VB look cannot find the columns because the table is not at the top of the screen. In excel VB look up you can specify a table name so excel will just find that table on a specific sheet and use that rather needing the table at the top of the workbook.

 

I posted this a few days ago but after speaking to the engineer we really dont want to have to change our BOM templates for the excel documents.

0 Likes
Reply
427 Views
2 Replies
Replies (2)

bronc3buster842001
Advocate
Advocate

Did you ever figure this out. Ive been looking for the same solution.

0 Likes

A.Acheson
Mentor
Mentor

Can you explain a little more of your requirement? The initial post doesn't have an object like a BOM/Partlist for exporting data or any source code involved. 

If this solved a problem, please click (accept) as solution.‌‌‌‌
Or if this helped you, please, click (like)‌‌
Regards
Alan
0 Likes