Default value in cell depending on other cell value

[Bill Morris]

Hi

I have posted something similar to this before.

I have a spreadsheet whereby I want a formula or <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code to apply depending upon if another cell contains anything.

For example

On sheet "Data", Range "C38nwards" may contain text. In N38: the user can add text, but if it is left blank then I want a dash ("-") as the default value. This applies to C39 (N39), C40 (N40).....etc

If any of the cells in the C38: range are blank then I want the corresponding (offset (0, 11) cell in the N column to be left blank.

I need the code to check column "C" from cell C38 until it reaches a blank cell.




Thanks

 

[Bill Morris]

Thanks. It does.....but I'm still getting dashes in cells N1-N37.

 

[DILIPandey]

Correct and that is what the macro should be doing.
as you said in post #5:-

starting at C38. Where cells in this range are not blank I require the corresponding cell in column N to contain either the default "-" or the user can input text in this cell.

Or you need anything else ?


Regards,
DILIPandey

 

[Bill Morris]

I'm trying to get the dashes in cells N38 onwards. At the moment I get them in cells N1-N37 too.

 

[DILIPandey]

Because your data starts much above then row 38.

See, the code looks data in "c38 to end cell" containg data in that c column and since it is not finding that (the end cell in c with data after c38), it starts populating data on the above side.


Regards,
DILIPandey

 

[Bill Morris]

Oh I understand now.

I'll work on this. Thanks again for your help!