View Single Post
  #1   Report Post  
Sharen
 
Posts: n/a
Default Do I need a formula or Macro?

I want to create a formula or a Macro that will do the following: Look in
cell F2, if it's blank, look one cell to the right, if it contains a value,
copy the value in F1 into J2 followed by the data in F2