Thread: inserting a row into a column that is read on another worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default inserting a row into a column that is read on another workshee
For a neater look in Sheet5,
we could suppress the display of extraneous zeros in the sheet
via clicking Tools Options View tab, Uncheck "Zero values" OK
(as zeros will be returned for blank source cells in Sheet4)

Or alternatively, we could use instead in B2:
=IF(OFFSET(Sheet4!$A$2,ROW(A1)-1,COLUMN(A1)-1)=0,"",OFFSET(Sheet4!$A$2,ROW(A1)-1,COLUMN(A1)-1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote