Copy formula down a table column, but skip used cells in that column

[sspatriots]

Hi,

I'm not sure this is even possible and I'm at a loss on where to start on this one. I have a table column that I need to copy a formula down, but only into the blank cells in that table column. If there is a value in that column I don't want the formula to overwrite what is in that cell. Any ideas on how I can do this would be greatly appreciated.

A little background: The formula is a Vlookup reference to find a date in another spreadheet that I have imported as a table. The person that owns the source worksheet I'm pulling from moves that data off this worksheet to another worksheet in the same workbook when a job has shipped. Therefore, when they do that my date will be gone from my workbook if I were to just copy the formula all the way down my column if a job has shipped.



Regards, Steve

 

[awoohaw]

Have you considered a new column in the table for that formula? and wrap that formula with an if reading the existing column for blanks or not?
IF(VALUEINOLDCOLUMN="",NEWFORMULA,VALUEINOLDCOLUMN)?

 

[Peter_SSs]

Are the blank cells completely empty or do they contain "" from the result of an existing formula?
If it is from a formula, can you post the current formula for the column?
If the column in question are just constant values, please confirm that.
Are the dates 'true' dates (numbers) or text values?
Are you looking to do this manually or by a macro?

 

[johnnyL]

I'm glad that I am not the only with followup questions.

 

[sspatriots]

Have you considered a new column in the table for that formula? and wrap that formula with an if reading the existing column for blanks or not?
IF(VALUEINOLDCOLUMN="",NEWFORMULA,VALUEINOLDCOLUMN)?

That worked exactly as I needed. Thank you.