Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy if true
Have a column with names in A and numbers in Columns B and C I want the activecell to start in A4. IF B4=B5 and C4=C5 Then I want the activecell in A4 to copy itself, Insert Shift:=xlDown, and paste in cell A4,which is empty now because the cell contents were shifted down.Then I want the active cell in A4 offset(1). Else Just offset(1) when the if statement is false. Then I want the process repeated till the last name in column A is used in a relative way.In other words the next sequence would start with activecell in A5 due to the offset and if B5 = B6 and C5=C6 Then etc.I've only had partial success writing this. -- light ------------------------------------------------------------------------ light's Profile: http://www.excelforum.com/member.php...fo&userid=7228 View this thread: http://www.excelforum.com/showthread...hreadid=399525 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare a value and if is true copy the line to other worksheet | Excel Worksheet Functions | |||
copy an entire row IF a statement is true | Excel Worksheet Functions | |||
Copy between workbooks if statement is true | Excel Programming | |||
Compare,copy and paste if true | Excel Programming | |||
if statement is true, copy data to another location | Excel Programming |