View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tiya Tiya is offline
external usenet poster
 
Posts: 44
Default 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