sspatriots
Well-known Member
- Joined
- Nov 22, 2011
- Messages
- 570
- Office Version
- 365
- Platform
- Windows
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
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