Spread sheet # 1 DATA SHEET
<tbody>
</tbody>
Spread sheet # 2 Sheet with info to use
<tbody>
</tbody>
Spread sheet # 3 Gathe information from Sheet 1 & 2
<tbody>
</tbody>
The data sheet (# 1) has a list of all customers with their data (i.e. 001,002,003,004,005,006 etc) I have a select list of cutomers on # 2 (i.e. Customer # - 002, 004 005 etc) and I want to only show the selected data on # 3 but each cutomer number may have from 0 to 500 invoices and I do not want a total I want all invoices to show. I need the formula to look at sheet 2 and go to sheet 1 for the information and place it on sheet 3. The invoice number is the unique number on the data (sheet 1) sheets. Assume the Customer is Column 1 and the data starts at Row 2
Customer # | Customer PO | Customer Name | Invoice # | Invoice Date | Due Date | Phone | Amount Invoiced | Amount Paid / Credited | Days Past Due | Amount Due |
<tbody>
</tbody>
Spread sheet # 2 Sheet with info to use
Customer # | Customer PO | Customer Name |
<tbody>
</tbody>
Spread sheet # 3 Gathe information from Sheet 1 & 2
Customer # | Customer PO | Customer Name | Invoice # | Invoice Date | Due Date | Phone | Amount Invoiced | Amount Paid / Credited | Days Past Due | Amount Due |
<tbody>
</tbody>
The data sheet (# 1) has a list of all customers with their data (i.e. 001,002,003,004,005,006 etc) I have a select list of cutomers on # 2 (i.e. Customer # - 002, 004 005 etc) and I want to only show the selected data on # 3 but each cutomer number may have from 0 to 500 invoices and I do not want a total I want all invoices to show. I need the formula to look at sheet 2 and go to sheet 1 for the information and place it on sheet 3. The invoice number is the unique number on the data (sheet 1) sheets. Assume the Customer is Column 1 and the data starts at Row 2