Hello
I need to bring in data from 1 sheet into another sheet. Simple enough...but the "feeding sheet" "Specifications" has blank lines...I do not want to bring in the blanks into the sheet I am feeding into...as an example cell A8 has data....but A9 - A19 are blank...the next cell with data is A26...below is what I am using...how can I accomplish this?
=IF(Specifications!A8<>" ",Specifications!A8,ELSEIF(Specifications!A9<> " ",Specifications!A9,ELSEIF(Specifications!A10< >" ",Specifications!A10,ELSEIF(Specifications!A11 <>" ",Specifications!A11, ELSEIF(Specifications!A12<>" ",Specifications!A12,ELSEIF(Specifications!A13 <>" ",Specifications!A13,ELSEIF(Specifications!A14 <>" ",Specifications!A14,ELSEIF(Specifications!A15 <>" ",Specifications!A15,ELSEIF(Specifications!A16 <>" ",Specifications!A16,ELSEIF(Specifications!A17 <>" ",Specifications!A17,ELSEIF(Specifications!A18 <>" ",Specifications!A18,ELSEIF(Specifications!A19 <>" ",Specifications!A19, ELSEIF(Specifications!A26<>" ",Specifications!A26,ELSEIF(Specifications!A27 <>" ",Specifications!A27, ELSEIF(Specifications!A28<>" ",Specifications!A28,ELSEIF(Specifications!A29 <>" ",Specifications!A29," " ))))))))))))))))