Forum Discussion
Solved
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 selec...
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.
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.