I'm pulling rows of data from one worksheet to another (both in the same workbook). I'm using this formula:
=IFERROR(INDEX('Password is cash bank'!A6:A43,ROW('Password is cash bank'!$F$3:$F$40)-ROW('Password is cash bank'!$F$3)+1),ROWS(A$1:A4))
which is working fine BUT the blank rows at the bottom of the spreadsheet are being filled with zeroes. How do I tell it to just leave the rows blank until more data is available?
The simplest is go into your File > Options > Advanced > Display options for this worksheet > Show a zero and disable that.
http://screencast.com/t/6Zp9YZ6l2x
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
It worked! Thanks so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks