Forum Discussion
relationship between pop up window and sequential data
Hi Everyone.
I wonder if someone can help.
I am busy creating automated invoice. i need to know how to create relationship between pop up window / list and sequential data?
for example: if I select a company name on my window, I need physical address, email address, contact number to automatically appear.
You may create table with all customer data (company name, address, etc). Company name column could be used for data validation drop-down list in some cell within invoice. Other fields could be filled by any lookup formulae (e.g. XLOOKUP) from that table.
1 Reply
You may create table with all customer data (company name, address, etc). Company name column could be used for data validation drop-down list in some cell within invoice. Other fields could be filled by any lookup formulae (e.g. XLOOKUP) from that table.