Excel vba

[Ghanumant]

I have created an excel project in which in sheet 5 customer,vendor,contractor database has been created by different id like VEN0001,CUST001,CNTR001. All this data is in column A. each one There are three different user farms. Suppose I make a customer entry with CUST001 but then make a vendor entry it is saved with VEN002... Not so What code should be written to save it with VEN001.
If contractor entry is made then it is saved as CNTR003 and if returned to customer it is as CUST004. What code can be written for the sequel entry of each category
Can someone help me

 

[zero269]

Can someone help me

I think it would help if you used this forums Excel Add-in to share some sample data. I'm personally having a hard time visualizing what you're describing.
You can find the add-in here. Be sure to read about to use it. It's pretty basic, but extremely useful when requesting or providing support in this forum.
Best of luck...

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

 

[Ghanumant]

Hi, Sharing Some Images here.