Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop until a condition is False
Data
A1 - 10.01 A2 - 10.02 C1 - Capture Party Details C2 - Capture Party Details C3 - Capture Party Details C4 - Capture Party Details C5 - View Transaction ------------------------------------------------------- What i want to do is in activecell 'Cell A3' compare cell C3 to C2. I they match then put 10.02 into Cell A3. Move to A4. If C4 and C match then put 10.02 into Cell A4. Move to A5. If C5 and C4 match the put 10.02 into Cell A5 else if they don't match (and in this case the don't) insert a new row with the value in A5 to be 20.01. Make sense? The row with xx.01 in column A signal a sub heading -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT with condition FIND(text) is false | Excel Worksheet Functions | |||
VBA - Do Loop or SaveChanges = false | Excel Discussion (Misc queries) | |||
Keep cell blank if condition is false in IF function | Excel Discussion (Misc queries) | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
two-condition loop | Excel Programming |