Selectively order data from specific customer on a new sheet, effectively creating a mini invoice of a few columns

[milonius]

Hi, I have tried searching the web and here for this problem but none seem to encapsulate all aspects I am looking for.

I want to be able to select a range(customer name) and have it list out each VIN they have, the Date it was entered, and the value for that line. I have attached an excerpt from the main log.

I perform this action weekly. each log entry from the week prior gets highlighted green and then new logs are entered at the bottom. So the solution will need to be able to expand or I should manually be able to select which rows to to incorporate. Ideally the outcome of the solution would be on a separate page in the workbook.

If able to use a drop down in place of the customer name for the solution(A16) this would be best, or I can create unique versions for each customer but that is not as preferred.

I currently use a few formulas that are listed(date entry for when the cell in b* gets created) . Not shown here are vlookup formulas to auto fill-in price and code source based on code type.

My goal with this is to be able to quickly copy and paste this info into an existing invoice on a separate website so the customer can have a more detailed breakdown with their bill.

Not sure if any of this is possible. My skill level for excel is watching videos and duplicating the code with a moderate level of understanding but not fully enough to create a code without guidance.

Thanks for all the help, if more info is needed let me know.

Aaron



ps. this is a minor snippet of the log, it has lots of entries and copy pasting is not viable any longer.
(I have edited out portions of this document due to sensitive nature)

	A	B	C	D	E	F	G	H	I	J
1	Date & Time	Customer Name	Code Type	Code Source	User ID	Vin #	Owner Name	License Plate #	PIN	Customer Cost
2	1/0/00 12:00 AM	Randy	ford	Tech1		1FTRF18	randy	839		35
3	2/11/18 4:16 PM	John	ford	Tech1		1FAFP44	Jonathan	20		35
4	2/13/18 1:31 PM	Randy	ford	Tech1		1fafp55	Mary	rzn		35
5	2/15/18 1:47 PM	Randy	ford	Tech1		2ftrx1cb	josh	282m		35
6	2/17/18 5:35 PM	John	Chrysler	Tech2		1J4GLW	todd	028m		40
7	2/22/18 1:35 PM	Randy	ford	Tech1		1ftrw0k	Travis	17njs		35
8	2/22/18 2:40 PM	John	ford	Tech1		1fafpw1	wendy	09wif		35
9	2/23/18 10:47 AM	Alon	Mitsubishi	site1		4A3AK0	Daniel J.	99zx		25
10	2/24/18 4:15 PM	Edward	ford	Tech1		3FA6P2	Meg	22		35
11
12
13
14
15
16	Randy	140
17		Date	Vin	Cost
18		1/0/00 12:00 AM	1FTRF18	35
19		2/13/18 1:31 PM	1fafp55	35
20		2/15/18 1:47 PM	2ftrx1cb	35
21		2/22/18 1:35 PM	1ftrw0k	35
22
23	John	110
24		Date	Vin	Cost
25		2/11/18 4:16 PM	1FAFP44	35
26		2/17/18 5:35 PM	1J4GLW	40
27		2/22/18 2:40 PM	1fafpw1	35
28
29	ETC ETC
30
31

<tbody>
</tbody>

Sheet8​

Worksheet Formulas Cell Formula A2 =IF(B2 <>"", IF(A2 ="", NOW(), A2), "") A3 =IF(B3 <>"", IF(A3 ="", NOW(), A3), "") A4 =IF(B4 <>"", IF(A4 ="", NOW(), A4), "") A5 =IF(B5 <>"", IF(A5 ="", NOW(), A5), "") A6 =IF(B6 <>"", IF(A6 ="", NOW(), A6), "") A7 =IF(B7 <>"", IF(A7 ="", NOW(), A7), "") A8 =IF(B8 <>"", IF(A8 ="", NOW(), A8), "") A9 =IF(B9 <>"", IF(A9 ="", NOW(), A9), "") A10 =IF(B10 <>"", IF(A10 ="", NOW(), A10), "") B16 =SUM(D18:D21) B23 =SUM(D25:D27) <tbody> </tbody>

<tbody>
</tbody>

 

[milonius]

This is working thank you so much!