VBA to automatically fill cell based on value in another cell

[mweick]

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

[RHCPgergo]

Hey,

how about something like this? This macro should be run when the active sheet is the one you want to sort. Save a copy of the file before you run it!

Please Login or Register  to view this content.

[mweick]

RHCPgergo, thanks for the quick reply! I forgot to tell you that row 1 has headings in it so start at row 2, but somehow you already knew that and compensated for it, well done! Worked great but I forgot to mention 1 thing if it can be added to this VBA.

I also need Column L to equal whatever is in column F only if there is data in column F, starting at row 2 and below again

Than

[RHCPgergo]

Here's the modified macro.

Please Login or Register  to view this content.

[mweick]

Worked great, awesome.

I have another request for this worksheet but it's kind of different so I'll start another thread.

Thanks again!