Basically, what I'm trying to figure out is a way to generate the customer name, address, and their bills using a single identity, which is invoice number.
I have the master data which looks like this (Lets say this is Sheet1):
<tbody>
Invoice Number
NAME
ADDRESS
WITEL
BILLS TOTAL...