Saturday, May 10, 2014

yogi_ From Table Of Invoice Information With Names In Columns Pull Invoice Info By Specified Name

                                         Google Spreadsheet   Post  #1633
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May-10-2014
post by: Daniel Abud (!category-topic/docs/spreadsheets/YYCic9dW63g)
Filter + HLOOKUP to sort data by date
So I have customer information and quantities that each customer has purchased or used. I need to create invoices for each customer. I currently have a filter function that only kicks back the days that are relevant to each customer. Here is my data:
                Bilbo   Rohan
12/9/2013        1        5
12/12/2013                5
12/16/2013        2        5
1/7/2014                5
1/8/2014        1        5
1/10/2014                5
This is my filter:
These are my filtered dates and customer hours (essentially an invoice):
12/9/2013        1
12/16/2013        2
1/8/2014        1
Is there any way that I can automate the filter so that all I have to do is type "Bilbo" into a cell and it will automatically give me Mr. Baggins' invoice?? I currently have to go into each individual invoice and change the cell number - which is very time consuming when you're trying to just spit out invoices for multiple customers.
Thank you!