Insert a row with simaler data using a function
 

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.

Insert a row with simaler data using a function
 

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.