#1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
returning back to loop check condition without completing the loop ashish128 Excel Programming 13 April 3rd 08 12:53 PM
Loop to Filter, Name Sheets. If Blank, Exit Loop ryguy7272 Excel Programming 3 February 5th 08 03:41 PM
(Complex) Loop within loop to create worksheets klysell Excel Programming 1 March 20th 07 12:03 AM
Advancing outer Loop Based on criteria of inner loop ExcelMonkey Excel Programming 1 August 15th 05 05:23 PM
Problem adding charts using Do-Loop Until loop Chris Bromley[_2_] Excel Programming 2 May 23rd 05 01:31 PM


All times are GMT +1. The time now is 11:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"