VBA check multiple cells if empty put text in cell B

[cizzett]

What I want to do is try to figure out a macro or code that can check if there is data in column D but column Q, R, and T are empty then I want to place the word "New" into column B.

Any Idea's?

Thanks as always

 

[Fluff]

That sounds like, either col D is empty, or columns Q,R & T have something in them.
In an unused cell put
=ISBLANK(Q4)
where Q4 is an "empty" cell, what does the formula return?
Also try it with empty cells in R & T

 

[cizzett]

https://www.dropbox.com/s/6j83qwczezrsdfn/Qlty Workbook Daily.xltm?dl=0<o></o>


Heres a link to a copy of the file, The primary macro etc to import the data will not work outside the local network, but basically once the3 data is imported you will see the formulas are all removed from the cells and I want to check if D has data but Q, R, and T are empty then I want to place the word "New" into column B.

 

[Fluff]

If you are referring to the "Today" sheet then Col T will never be empty, because your formula is adding a space if there is an error.

 

[cizzett]

Right but those formulas are removed by a macro prior to running the macro to add the new so the formula would be gone and should not be an issue should it?

 

[Fluff]

@cizzett
How are you removing the formulae?

 

[cizzett]

Fluff, I just realized you were 100% correct because my macro removed the formulas but left the values so it was in fact reading as a space. ? your the bomb my friend, I appreciate your help with this one

 

[cizzett]

I have been working on this so much I realized my macro for removing the formulas wasnt on the call list for the import button on the one I sent yall. But either way, removing the space has fixed the issue, I really appreciate you and @mumps both, this works perfect now.

Now I just have to streamline my macro for the initial import data task and hopefully find a way to make the file locations changeable in a cell.

Again I appreciate the help.

 

[mumps]

Glad we could help.