Excel sheet : dynamic with three drop down lists issues (1 Viewer)

[a7mad1990]

hello
I'm not managed VBA Code

I need To add some Fields "Villa Location , Villa Number, vendor name , changing points , Quantity , Price , Total Value , Date, invoice number " to the table and edit them when i highlight the selected row

This excel sheet is to dynamic with three drop down lists and i need to add some fields to the table in the "item" sheet only

The Sheet is Coded By VBA


Plz Help me

 

[June7]

Are you trying to use Excel as a database?

What's preventing you from adding columns as you wish?

 

[a7mad1990]

1.yes
2. i don't perfect in vba cods

 

[June7]

1. I would advise against using Excel as a database and instead migrate to Access.

2. Why not? That statement does not make sense.

 

[Isaac]

1.yes
2. i don't perfect in vba cods

2, understatement.
Please narrow the problem down to something more reasonable to ask for help with rather than just asking for the whole script to be written.

 

[a7mad1990]

2, understatement.
Please narrow the problem down to something more reasonable to ask for help with rather than just asking for the whole script to be written.

Hello dear

i need to edit the code not written from beginner
i tried from edit it but errors is much

thanks for help

 

[June7]

So you want someone to rebuild this for you. To add columns and fix all relevant code. We are volunteers here, maybe someone will tackle but don't hold your breath. If you are not capable of this fairly simple programming, pay a consultant.

Maybe time to rethink approach. I already advised using a database app. If Excel file gets very large it will begin to perform poorly.

 

[a7mad1990]

PLZ i need someone to help me