View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
juan juan is offline
external usenet poster
 
Posts: 29
Default Find data in Column D, add L in Column A

Hello All,
I have a sheet that in Column A the default value will be
L for those rows that contain information. I'm creating a
macro so would like to put a code in there that will put
an L in Column A if there is data in Column D.
Example
Column A ColumnD
L MICROTEST
L LECTRATEST
L SAMPLE
Since total rows will change on a monthly basis I can't
have a specific range.

Would appreciate the help.
Thanks,
Juan