View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bourbon84 bourbon84 is offline
external usenet poster
 
Posts: 7
Default For Next Loop...Copying from a cell one column to another...

Hi all. I am brand new to VBA, and am fumbling my way thru this. Any help
is appreciated. I have one worksheet with several thousand rows, and about
10 columns. I need to loop thru all the rows in column 5 to see if each cell
meets a certain criteria (is the text there = "Person" or "Place" or
"Thing"?)

If R2, C5 = "Person", then copy "Person" to R2, C4.
If R2, C5 = "Place", then copy whatever is in R2, C6 to R2, C4
If R2, C5 = "Thing", then copy whatever is in R2, C7 to R2, C4

You'd think, with all the Excel help pages and example code out there, that
I could figure this out. But apparently, I can't.