Hi,
I have a file with scattered data. In column A, customer name, product name and sales date are available. And in column B, sales volumes are available.
I need to impose the sumif formula to check the product-wise total sales volume. To do that, I need to get all the products name just beside the sales volume cell.
Since doing that manually is very time consuming (having 4000+rows in total), I need to have all the product name in column C using macro (beside the sales volume). In Column A, the products name are in bold.
Input:
Expected output
I am trying to above expected result using VBA. Could you please help to have that macro to solve the problem ?
Thanks in advance for your effort.
Shazzad
I have a file with scattered data. In column A, customer name, product name and sales date are available. And in column B, sales volumes are available.
I need to impose the sumif formula to check the product-wise total sales volume. To do that, I need to get all the products name just beside the sales volume cell.
Since doing that manually is very time consuming (having 4000+rows in total), I need to have all the product name in column C using macro (beside the sales volume). In Column A, the products name are in bold.
Input:
Column A | Column B |
ABC Customer | |
Product A | |
01.01.2022 | 10 |
02.01.2022 | 15 |
03.01.2022 | 24 |
04.01.2022 | 23 |
Expected output
Column A | Column B | Column C |
ABC Customer | ||
Product A | ||
01.01.2022 | 10 | Product A |
02.01.2022 | 15 | Product A |
03.01.2022 | 24 | Product A |
04.01.2022 | 23 | Product A |
I am trying to above expected result using VBA. Could you please help to have that macro to solve the problem ?
Thanks in advance for your effort.
Shazzad
Last edited: