Without using formulas in the actual cells, I need VBA to automatically fill column C with a letter A only if there is any kind of value (letters or numbers) in column B. I also need need column K to be populated with the number 1 only if there is any kind of value (letters or numbers) in column B.

This will greatly help streamline an upload process. I am very new to VBA and I am struggling to get this to work.

Thanks