Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
returning back to loop check condition without completing the loop | Excel Programming | |||
Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
(Complex) Loop within loop to create worksheets | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming |