orange12345
New Member
- Joined
- Jan 25, 2016
- Messages
- 40
- Office Version
- 365
- Platform
- Windows
Hi there,
Hope all is staying well and healthy.
I have a worksheet A and worksheet B. Worksheet B is the source excel file where customer comments are saved. customer Name, date, category and their comments. Examples are below. For each quarter, each customer will have only 5 rows.
Worksheet A is a display file, if an user selects name and Date, in a fixed range (B1: G5), the information of that customer for that quarter should show like below.
I want the vba to search the worksheet B and if it finds the row where the Name and Date matches the user selection on Worksheet A, it will copy the 5 column next to it and also the four rows below.
Thanks for all the help in advance and happy to explain.
Hope all is staying well and healthy.
I have a worksheet A and worksheet B. Worksheet B is the source excel file where customer comments are saved. customer Name, date, category and their comments. Examples are below. For each quarter, each customer will have only 5 rows.
Name | Date | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 |
Jean | 2020 Q1 | like it | bad | bad | great | great |
Jean | 2020 Q1 | good | good | good | good | good |
Jean | 2020 Q1 | bad | bad | bad | bad | bad |
Jean | 2020 Q1 | good | good | good | good | good |
Jean | 2020 Q1 | bad | bad | bad | bad | bad |
like it | bad | bad | great | great |
good | good | good | good | good |
bad | bad | bad | bad | bad |
good | good | good | good | good |
bad | bad | bad | bad | bad |
I want the vba to search the worksheet B and if it finds the row where the Name and Date matches the user selection on Worksheet A, it will copy the 5 column next to it and also the four rows below.
Thanks for all the help in advance and happy to explain.