View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excel Helps Excel Helps is offline
external usenet poster
 
Posts: 27
Default 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.