I have a pretty basic understanding of Excel but I'm sure there must be a way to do this: I have a worksheet that is a template for an invoice. And I have a worksheet that has data. What I want to do is have the template populate based on one Customer. So, this is what I'm trying to figure out:
Worksheet A: Template Invoice
Customer: Judy Smith (D2 and D4 only on Worksheet B) WHAT FORMULA WOULD I USE HERE TO ONLY GRAB DATA RELATING TO Judy Smith????
Date: Description: Hours:
='Data'!A2 ='Data'!B2 ='Data'!D2
='Data'!A4 ='Data'!B4 ='Data'!D4
Worksheet B: Data
Colm: A B C D
R1 Date: Description: Hours: Customer:
R2 11/20/20 Housecleaning 3 Judy Smith
R3 11/22/20 Gardening 4 Bob Miller
R4 11/25/20 Weeding 2 Judy Smith
Thanks so much for your help!!
Worksheet A: Template Invoice
Customer: Judy Smith (D2 and D4 only on Worksheet B) WHAT FORMULA WOULD I USE HERE TO ONLY GRAB DATA RELATING TO Judy Smith????
Date: Description: Hours:
='Data'!A2 ='Data'!B2 ='Data'!D2
='Data'!A4 ='Data'!B4 ='Data'!D4
Worksheet B: Data
Colm: A B C D
R1 Date: Description: Hours: Customer:
R2 11/20/20 Housecleaning 3 Judy Smith
R3 11/22/20 Gardening 4 Bob Miller
R4 11/25/20 Weeding 2 Judy Smith
Thanks so much for your help!!