Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add or Delete row as per enter
Hi to All
I have filed like CodeNo.,ItemName,PartyName,Wt,Descrp. I have code more than 3000 which is fix like c1to c300,b1tob300 ps1 to ps250 etc... I have to delete every time when perticular codeno. item is sold but not the codeno. ie. it to delete all ItemName,PartyName,Wt,Descrp.only. When i want to delect c2, c45, b30 etc.. it should ask my code no. and when i enter codeno it should delete than ItemName,PartyName,Wt,Descrp.only and when i i want to enter than codeno i should first ask blank codeno. and add data into than rows I done have any code for this. i have tryed using recode macro but it was not working so is any one can please code this macro for me than i will be grate help to me. Any help Thanks Tiya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to select cells in column enter data then press enter | New Users to Excel | |||
How do I enter a formula that will delete a line when a cell = 0? | Excel Worksheet Functions | |||
Determine if cell was modified by Enter , Paste or Delete | Excel Programming | |||
How can I delete the end of line (result of shift-enter) | Excel Programming | |||
How can I delete the end of line (result of shift-enter) | Excel Programming |