if a blank cell in column E or F then inputs "MISSING" in column G

Hi,

I'm after a code that will find blank in columns E or/and F to then input the word MISSING in column G.
For example

School	Child Forename	Child Surname	Parent Surname	Parent DOB	Parent NI	Eligible
school1	cforename1	csurname1	psurname1	1/1/1990	JA123456A	Yes
school1	cforename2	csurname2	psurname2		JA123456B	Missing
school2	cforename3	csurename3	psurname3	1/2/1990		Missing
school2	cforename3	csurename3	psurname3	1/2/1990	JC123456A	No

Any help is greatly appreciated!

Thanks Ashley

Hi Etaf,

thanks for the swifty response. The spreadsheet goes into an automated system provided by the government to see if they're entitled to a specific benefit, however it rejects the spreadsheet if there are any blanks, when the spreadsheet comes back it inputs into column G (Yes if they're eligible) (No if they're not)

What I need is some code that will find any blanks and mark them as missing, the reason for this is because I have a macro already on the spreadsheet to find "missing" in column G which then deletes and moves from the original tab to another

Hope this helps

Thanks

1 Thing I forgot, is that the total number of rows, will change on open up as it is an automated spreadsheet from a system I am working on

Hi HahoBe,

That works fantastic!, just a quick one, is there a way of any possibility to create a macro to export to .CSV with selected columns in a different format and with no headers an example is below in the correct format and a blank column in B
i.e.

JA123456A	pleaseleaveblank	19900101	psurname1
JC123456A		19900201	psurname3

please note the date in the original spreadsheet is DD/MM/YYYY and in the .CSV it needs to be yyyymmdd

Originally Posted by etaf

you can use an IF

=IF( OR( E2="", F2=""), "Missing", "what to put if not blank")

What decides on the YES or NO in Column G

Hi etaf,

Not a problem, and thank you for trying, I do appreciate it! (p.s. +rep'd you)