Thread: Loop IF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
D@SE D@SE is offline
external usenet poster
 
Posts: 14
Default Loop IF

My sheet is title INPUT, on that sheet, starting at row 20 going to row 3019,
If column B has any letter or letters in it then I want to always copy the
cells on row 19, Range("DB19:BLP19"), this is constant, I always want to copy
this group of cells on row 19; and paste them down on the corresponding rows
where there is anything in column B. I then want that to loop down through
column B starting at 19 and going through 3019, repeating where there is an
entry in column B. Some rows may not have input and then the next one might.

Then I would like code to that will somewhat reverse the above. For any
cells that have input in Column B starting at row 20 looping down through
3019 I want to clear contents from Columns DB through BLP, then I need to
copy Columns B through K from row 3020 which are cells with formulas and copy
those down in all the applicable columns that have anything in them on Column
B. starting at row 19 and looping down through 3019.
Thank you so much to those who will help me!
--
David