Copy rows to Excel

Gethro

New Member
Joined
Mar 24, 2022
Messages
1
Office Version
  1. 2010
Platform
  1. Windows
Dear All, I am struggling with this issue for a while.
In the attached file, Question 19 corresponds to the quantity of product found at a customer's during the inspection (each product is on a line); therefore, as many products found at the customer, we will have as many lines for this customer. From this, I would like the answers for the other questions of the survey for each customer inspected to be repeated on all the lines referring to the different products found at the same customer.

How can we make it possible automatically in Excel?

Thank you very much for your help

A3.xlsx
AHAIAJAKALAMANAOAPAQAR
1Q14. Source d'approvisionnement du POSQ15. Selectionner le type de commerceQ16. Disponibilité des produitsQ17. Indiquer la provenance des produits observésQ19. Choisir les produits présents chez le clientQ20. Choisir l'emballage du POSQ22. CDE BRA?Q23. CDE COMPETITION?Q24. COMMUNICATION PRIX?Q25. PEINTURE LOS?Q26. ELECTRICITE?
2CAMION-DEPOTDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEAAMIXTEOUINONNONOUINON
3BB
4CC
5DD
6EE
7FF
8GG
9HH
10II
11CAMIONDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEJJMIXTEOUINONNONOUINON
12KK
13MM
14LL
15NN
16WW
17EE
18DEPOTBOUTIQUE-BAZARGLACEMIXTEDDMIXTEOUINONNONNONOUI
19EE
20II
21JJ
22CAMION-DEPOTBOUTIQUE-BAZARGLACEMIXTEKKMIXTEOUINONNONOUINON
23OO
24UU
25RR
26ZZ
Export



EDIT:
To add to the post above.
I would like to automatically switch from the file downloaded before to this file attached to this post.

A4.xlsx
AHAIAJAKALAMANAOAPAQAR
1Q14. Source d'approvisionnement du POSQ15. Selectionner le type de commerceQ16. Disponibilité des produitsQ17. Indiquer la provenance des produits observésQ19. Choisir les produits présents chez le clientQ20. Choisir l'emballage du POSQ22. CDE BRA?Q23. CDE COMPETITION?Q24. COMMUNICATION PRIX?Q25. PEINTURE LOS?Q26. ELECTRICITE?
2CAMION-DEPOTDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEAAMIXTEOUINONNONOUINON
3CAMION-DEPOTDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEBBMIXTEOUINONNONOUINON
4CAMION-DEPOTDEPOT DE BOISSONS GAZEUSESMIXTEMIXTECCMIXTEOUINONNONOUINON
5CAMION-DEPOTDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEDDMIXTEOUINONNONOUINON
6CAMION-DEPOTDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEEEMIXTEOUINONNONOUINON
7CAMION-DEPOTDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEFFMIXTEOUINONNONOUINON
8CAMION-DEPOTDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEGGMIXTEOUINONNONOUINON
9CAMION-DEPOTDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEHHMIXTEOUINONNONOUINON
10CAMION-DEPOTDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEIIMIXTEOUINONNONOUINON
11CAMIONDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEJJMIXTENONNONOUIOUIOUI
12CAMIONDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEKKMIXTENONNONOUIOUIOUI
13CAMIONDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEMMMIXTENONNONOUIOUIOUI
14CAMIONDEPOT DE BOISSONS GAZEUSESMIXTEMIXTELLMIXTENONNONOUIOUIOUI
15CAMIONDEPOT DE BOISSONS GAZEUSESMIXTEMIXTENNMIXTENONNONOUIOUIOUI
16CAMIONDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEWWMIXTENONNONOUIOUIOUI
17CAMIONDEPOT DE BOISSONS GAZEUSESMIXTEMIXTEEEMIXTENONNONOUIOUIOUI
18DEPOTBOUTIQUE-BAZARGLACEMIXTEDDMIXTEOUINONNONNONOUI
19DEPOTBOUTIQUE-BAZARGLACEMIXTEEEMIXTEOUINONNONNONOUI
20DEPOTBOUTIQUE-BAZARGLACEMIXTEIIMIXTEOUINONNONNONOUI
21DEPOTBOUTIQUE-BAZARGLACEMIXTEJJMIXTEOUINONNONNONOUI
22CAMION-DEPOTBOUTIQUE-BAZARGLACEMIXTEKKMIXTEOUINONNONOUINON
23CAMION-DEPOTBOUTIQUE-BAZARGLACEMIXTEOOMIXTEOUINONNONOUINON
24CAMION-DEPOTBOUTIQUE-BAZARGLACEMIXTEUUMIXTEOUINONNONOUINON
25CAMION-DEPOTBOUTIQUE-BAZARGLACEMIXTERRMIXTEOUINONNONOUINON
26CAMION-DEPOTBOUTIQUE-BAZARGLACEMIXTEZZMIXTEOUINONNONOUINON
Export
 
Last edited by a moderator:

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Hi & welcome to MrExcel.
How about
VBA Code:
Sub Gethro()
   With Range("AH2:AR" & Range("AL" & Rows.count).End(xlUp).Row)
      .SpecialCells(xlBlanks).Formula = "=r[-1]c"
      .Value = .Value
   End With
End Sub
 
Upvote 0

Forum statistics

Threads
1,223,886
Messages
6,175,198
Members
452,617
Latest member
Narendra Babu D

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top