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)
<tbody>
</tbody>
<tbody>
</tbody>
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
<tbody> </tbody> |
<tbody>
</tbody>