Macro to populate adjacent cell but if already populated leave cell alone if false

I am VERY inexperienced with VB. That being said, I have a spreadsheet that I've coded to put a value in one cell based on a value in another cell:

Please Login or Register  to view this content.

The problem is, besides not knowing how to code, when I place other data in column T, the code overwrites it when I run the macro.

To clarify - I have five columns in a spreadsheet and, based on what goes in the first column (the first column will either be blank or contain "N/A"), I want the second, third, fourth and fifth columns to auto-populate (if there's nothing, it remains blank, if it's "N/A", then "N/A" ). The reason these columns would otherwise remain blank is that I need to populate them with dates.

My macro works well initially, but if I place dates in the second, third, fourth or fifth columns, the next time I run the macro this data gets overwritten.

I'm obviously in way over my head.

Hope this is clear enough.

ANY help at all would be appreciated.

Thanks.

Cindy

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Your post does not conform with the Titles Rule as well