How to copy the bold value and paste in next column continuously until the next

Topic

New Reply

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 in column B.

Since I have more than 5000 rows of data, I want to have all the product name in column C using macro (beside the sales volume). In Column A, the products name are in bold.

I am trying to above expected output using VBA. Could you please help to have that macro to solve the problem ?
Thanks in advance for your effort.

Shazzad

Reply | Quote

Replies

Put this in column C.
=IF(ISNUMBER(A2),C1,A2)
Fill down.

I have assumed the first product is in row 2 and the date is a number formatted as a date.

It’s not quite what you want, but it may help.

cheers, Paul

Reply | Quote

Hi Paul,

Thanks for your input. Actually there are so many scattering data which is almost impossible to process using formula (though I am bit unsure). Here I am attaching a file with a sheet named “Input” and another sheet named “Expected Output”.

Reply | Quote

My formula works for that data. Follow it with a copy / paste values only and a bold format. Then remove the few values you don’t want manually, or change the formula to put a blank there in the first place.

cheers, Paul

1 user thanked author for this post.

shazzad.arla

Reply | Quote

Based on your sample sheet, put this in C4 and then fill down.
Then bold and copy/paste values.
=IF(ISNUMBER(A4),IF(ISNUMBER(A3), C3,A3),””)

cheers, Paul

Reply | Quote

Cross-posted at: https://chandoo.org/forum/threads/how-to-copy-the-bold-value-and-paste-in-next-column-continuously-until-the-next-bold-value-find.50033/
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

… and https://stackoverflow.com/questions/74626810/how-to-copy-the-bold-value-and-paste-in-next-column-continuously-until-the-next

Reply | Quote