VBA Excel, group rows and perform an action for each group

[Lara465]

Hello!

I have an excel like this:

So I have column A, I want column B to complete automatically. I though that by entering a blank row between groups it will be easier to separate groups.
So it will go down the column A and for each not empty row it will write Iph in column B, when it finds an empty row on column A, it writes nothing in column B. Then continues and writes Sms for next group untill emply row, and so on.
I know how to write something for each non empty row, but it will write the same thing for the whole excel sheet, like this:

My question: is there a way to write something different after each blank row found?

Thank a lot guys.

 

[alansidman]

How many different categories do you have? I am thinking the best way to do this is create a table and then use Vlookup

time.xlsx
	A	B	C	D	E
1	Brand	Code		IPhone 11-10	iph
2	IPhone	iph		IPhone 11 fff pret	iph
3	Samsung	sms
4	Motorala	mot		Samsung 23	sms
5	Verizon	vrz		Samsung hhh pret	sms
6	ATT	att		Samsung eee	sms
7	Other	oth
8				Motorala 12	mot
9				Motorala 13	mot
10
11				Verizon 4	vrz
12				Verizon 5	vrz
Sheet2

Cell Formulas
Range	Formula
E1:E12	E1	=IF(D1="","",VLOOKUP(LEFT(D1,FIND(" ",D1)-1),$A$2:$B$7,2,FALSE))

 

[Lara465]

Not many categories, the problem is I can't use the Brand. For ihpone 11 it needs to write something different than from Iphone 8. and so on, I can't group it by brand.

 

[Lara465]

So I can group only how it comes in column A. First group untill blank row -> write iph
Next
Second group untill blank row -> write .......
next..
So I need a way fom when it finds a blank space to continue and I will put the code again. Not necessarily a loop for entire excel. Just a piece that I will copy and paste as many times as I need, for as many groups. But I can;t make it to go on after the blank row...

 

[alansidman]

Cannot manipulate data in a picture. Upload using XL2BB a before and after sample so that we can work with it without having to retype your data. Make sure your data is representative in your sample of your actual file.