ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Delete or Add Data into as per Codeno. (https://www.excelbanter.com/excel-programming/345530-delete-add-data-into-per-codeno.html)

Tiya

Delete or Add Data into as per Codeno.
 
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

Any help

Thanks

Tiya




All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com