See answer in your other post, and please do not multi-post.

Pete

On Jan 17, 5:18*pm, Excel Helps
wrote:
Is it possible to create alternating lines of data using a function, based
on a preceding line?
I need to add simaler products underneath each line of existing data to add
the wood type oak.

Code * *Name * *Wood * *Wood_Image
A1 * * *Chair * Pine * *pine.jpg

A2 * * *Chair * Pine * *pine.jpg

This line to be added inbetween A1 and A2
A1_OAK * * Chair * * * * Oak * * * * *oak.jpg

Thanks.