autofill based on next cell

[BusMgr]

New to excel programming. I have column ("A&quot that I want to put in a line number only if data is entered in column ("B&quot. I don't want the number displayed in col. A if no data in col B or beyond. Intent is to only print pages with data.

Can this also be carried over to other columns that are based on formulas from previous rows?

Thanks in advance.

 

[DaleWatson123321]

BusMgr,

...noticed you haven't yet received a response.

...suggest it's because your description is not that clear.

Could you clarify further ? ...or better still, if you offered to email a copy of your file, it would make it MUCH simpler to understand your situation, and to email you back a specific fix.

If necessary, replace any "sensitive" data with "dummy" data.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[Dreamboat]

Well, I don't know about printing, but...

In A2, you can put:

=IF(ISBLANK(B2),"",1)

In A3, you can put:

=IF(ISBLANK(B3),"",A2+1)
=IF(ISBLANK(B4),"",A3+1)
and so on...

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[BusMgr]

Thanks for your help. I modified Dreamboat's response to

=IF(B2="","",(A1+1)

I assume that this is MS's "if, then, else" type statement. Does it also work with "ISNOTBLANK(B2)" in your answer?

Thanks for your help.

Busmgr

 

[Dreamboat]

ISNOTBLANK is not an Excel function/expression.

You can try something like <>0 (not equal to zero).

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com