Spread sheet # 1 DATA SHEET
[TABLE="width: 842"]
<tbody>[TR]
[TD="class: xl74, width: 66, bgcolor: #66FF99"]Customer #
[/TD]
[TD="class: xl66, width: 131, bgcolor: #66FF99"]Customer PO
[/TD]
[TD="class: xl75, width: 238, bgcolor: #66FF99"]Customer Name
[/TD]
[TD="class: xl74, width: 81, bgcolor: #66FF99"]Invoice #
[/TD]
[TD="class: xl76, width: 75, bgcolor: #66FF99"]Invoice Date
[/TD]
[TD="class: xl76, width: 75, bgcolor: #66FF99"]Due Date
[/TD]
[TD="class: xl74, width: 89, bgcolor: #66FF99"]Phone
[/TD]
[TD="class: xl77, width: 110, bgcolor: #66FF99"]Amount Invoiced
[/TD]
[TD="class: xl77, width: 95, bgcolor: #66FF99"]Amount Paid / Credited
[/TD]
[TD="class: xl78, width: 50, bgcolor: #66FF99"]Days Past Due
[/TD]
[TD="class: xl77, width: 110, bgcolor: #66FF99"]Amount Due
[/TD]
[/TR]
</tbody>[/TABLE]
Spread sheet # 2 Sheet with info to use
[TABLE="width: 326"]
<tbody>[TR]
[TD="class: xl66, width: 89, bgcolor: yellow"]Customer #
[/TD]
[TD="class: xl66, width: 89, bgcolor: yellow"]Customer PO
[/TD]
[TD="class: xl66, width: 256, bgcolor: yellow"]Customer Name
[/TD]
[/TR]
</tbody>[/TABLE]
Spread sheet # 3 Gathe information from Sheet 1 & 2
[TABLE="width: 845"]
<tbody>[TR]
[TD="class: xl66, width: 66, bgcolor: #66FF99"]Customer #
[/TD]
[TD="class: xl67, width: 133, bgcolor: #66FF99"]Customer PO
[/TD]
[TD="class: xl67, width: 256, bgcolor: #66FF99"]Customer Name
[/TD]
[TD="class: xl66, width: 81, bgcolor: #66FF99"]Invoice #
[/TD]
[TD="class: xl71, width: 75, bgcolor: #66FF99"]Invoice Date
[/TD]
[TD="class: xl71, width: 75, bgcolor: #66FF99"]Due Date
[/TD]
[TD="class: xl66, width: 89, bgcolor: #66FF99"]Phone
[/TD]
[TD="class: xl69, width: 110, bgcolor: #66FF99"]Amount Invoiced
[/TD]
[TD="class: xl69, width: 78, bgcolor: #66FF99"]Amount Paid / Credited
[/TD]
[TD="class: xl68, width: 50, bgcolor: #66FF99"]Days Past Due
[/TD]
[TD="class: xl69, width: 110, bgcolor: #66FF99"]Amount Due
[/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 842"]
<tbody>[TR]
[TD="class: xl74, width: 66, bgcolor: #66FF99"]Customer #
[/TD]
[TD="class: xl66, width: 131, bgcolor: #66FF99"]Customer PO
[/TD]
[TD="class: xl75, width: 238, bgcolor: #66FF99"]Customer Name
[/TD]
[TD="class: xl74, width: 81, bgcolor: #66FF99"]Invoice #
[/TD]
[TD="class: xl76, width: 75, bgcolor: #66FF99"]Invoice Date
[/TD]
[TD="class: xl76, width: 75, bgcolor: #66FF99"]Due Date
[/TD]
[TD="class: xl74, width: 89, bgcolor: #66FF99"]Phone
[/TD]
[TD="class: xl77, width: 110, bgcolor: #66FF99"]Amount Invoiced
[/TD]
[TD="class: xl77, width: 95, bgcolor: #66FF99"]Amount Paid / Credited
[/TD]
[TD="class: xl78, width: 50, bgcolor: #66FF99"]Days Past Due
[/TD]
[TD="class: xl77, width: 110, bgcolor: #66FF99"]Amount Due
[/TD]
[/TR]
</tbody>[/TABLE]
Spread sheet # 2 Sheet with info to use
[TABLE="width: 326"]
<tbody>[TR]
[TD="class: xl66, width: 89, bgcolor: yellow"]Customer #
[/TD]
[TD="class: xl66, width: 89, bgcolor: yellow"]Customer PO
[/TD]
[TD="class: xl66, width: 256, bgcolor: yellow"]Customer Name
[/TD]
[/TR]
</tbody>[/TABLE]
Spread sheet # 3 Gathe information from Sheet 1 & 2
[TABLE="width: 845"]
<tbody>[TR]
[TD="class: xl66, width: 66, bgcolor: #66FF99"]Customer #
[/TD]
[TD="class: xl67, width: 133, bgcolor: #66FF99"]Customer PO
[/TD]
[TD="class: xl67, width: 256, bgcolor: #66FF99"]Customer Name
[/TD]
[TD="class: xl66, width: 81, bgcolor: #66FF99"]Invoice #
[/TD]
[TD="class: xl71, width: 75, bgcolor: #66FF99"]Invoice Date
[/TD]
[TD="class: xl71, width: 75, bgcolor: #66FF99"]Due Date
[/TD]
[TD="class: xl66, width: 89, bgcolor: #66FF99"]Phone
[/TD]
[TD="class: xl69, width: 110, bgcolor: #66FF99"]Amount Invoiced
[/TD]
[TD="class: xl69, width: 78, bgcolor: #66FF99"]Amount Paid / Credited
[/TD]
[TD="class: xl68, width: 50, bgcolor: #66FF99"]Days Past Due
[/TD]
[TD="class: xl69, width: 110, bgcolor: #66FF99"]Amount Due
[/TD]
[/TR]
</tbody>[/TABLE]
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