Need VBA for Auto fill of data in respective cell

[Ruban S]

Dear,

I have data like this

SHORT	LONG	NOUN	MODIFIER	ATT N1	ATT V1	ATT N2	ATT V2	ATT N3	ATT V3
CHEMICAL,FAST-DRY SELF VULCANIZING CEMNT	CHEMICAL, TYPE:FAST-DRY SELF VULCANIZING CEMENT, PACK SIZE:236.6ML	CHEMICAL	--	TYPE		PACK SIZE
CHEMICAL,FLUSH,LOCO,236.6ML	CHEMICAL,FLUSH, BRAND:LOCO, PACK SIZE:236.6ML	CHEMICAL	FLUSH	MANUFACTURER		BRAND		PACK SIZE

I Need it like this

SHORT	LONG	NOUN	MODIFIER	ATT N1	ATT V1	ATT N2	ATT V2	ATT N3	ATT V3
CHEMICAL,FAST-DRY SELF VULCANIZING CEMNT	CHEMICAL, TYPE:FAST-DRY SELF VULCANIZING CEMENT, PACK SIZE:236.6ML	CHEMICAL	--	TYPE	FAST-DRY SELF VULCANIZING CEMENT	PACK SIZE	236.6ML
CHEMICAL,FLUSH,LOCO,236.6ML	CHEMICAL,FLUSH, BRAND:LOCO, PACK SIZE:236.6ML	CHEMICAL	FLUSH	MANUFACTURER		BRAND	LOCO	PACK SIZE	236.6ML

This is an example. I have may Rows and columns like this. With respect to ATT N, it has to auto fetch ATT V from LONG. If ATT N is not available in LONG, it has to fill blank or "-" in ATT V
Please help me with some solution.

 

[Fluff]

Duplicate Auto Splitting of Data

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.