Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deletion Of Cells
Say i had a cell (E.g K1) that has a forumla within it which gives a number
as an answer. i also have a number of records in the same worksheet e.g. A1:C10. Is there any way i can make specific cells be deleted when cell K1 has a certain number within (A result from the forumla it contains). e.g. Everyday, the number within cell K1 decreases by 1. When the number within K1 reaches 0, delete cell A1 & C1 (Keep B1) & then move all cells underneath A1 & C1 up one row (B column is not affected in any way). This will make A2 & C2 replace A1 & C2. A3 & C3 will replace A2 & C2 & so on If this could be done without the use of VB, i would be most grateful |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deletion Of Cells
Going out on a limb here...
This can NOT be done without using VBA "DDD" wrote: Say i had a cell (E.g K1) that has a forumla within it which gives a number as an answer. i also have a number of records in the same worksheet e.g. A1:C10. Is there any way i can make specific cells be deleted when cell K1 has a certain number within (A result from the forumla it contains). e.g. Everyday, the number within cell K1 decreases by 1. When the number within K1 reaches 0, delete cell A1 & C1 (Keep B1) & then move all cells underneath A1 & C1 up one row (B column is not affected in any way). This will make A2 & C2 replace A1 & C2. A3 & C3 will replace A2 & C2 & so on If this could be done without the use of VB, i would be most grateful |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
name deletion | Excel Discussion (Misc queries) | |||
simple row deletion | Excel Discussion (Misc queries) | |||
how do I highlight duplicates cells in excell prior to deletion | Excel Worksheet Functions | |||
Automatic deletion of specific cells from multiple sheets | Excel Worksheet Functions | |||
Merge two files and then allowing deletion of duplicate cells? | Excel Worksheet Functions |