#1
|
|||
|
|||
How to omit blank cells from 1 sheet to another
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," " )))))))))))))))) |
#2
|
|||
|
|||
Maybe like the attached.
|
#3
|
|||
|
|||
Thank you!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to populate cells from 1 sheet to another | dnh4wk | Excel | 2 | 12-16-2015 02:33 PM |
Help with Subtotal(103, ) formula and blank cells | zhl203 | Excel | 1 | 07-30-2014 03:40 PM |
Join cells together separated by ; when some are blank | leemoreau | Excel | 3 | 11-03-2013 11:22 AM |
Look up cells in one sheet and add to another | aulrich28 | Excel | 2 | 02-26-2013 10:27 AM |
Selecting blank cells in criteria | apolloman | Excel | 6 | 08-24-2011 05:38 AM |