D
deen
hi all,
i need to update the excel data tru user form,
i have data like,
product no. name amt
11 soap 10
12 towel 15
13 powder 40
this are the data i need to update in excel sheet,
1. i need to create the user form in excel,once the excel is activate
automatically userform will open , i need make the 2 command button ,
1.new entry and other is 2.update
2. once i will click the new entry , the new entry data list will show
like product no. name amt ,and then click update button
its automatically saved in excel sheet.
3.once i will click the update , the update data list will show like
product no. name amt ,and then click update button its
automatically saved in excel sheet.(it will update data is already
stored) eg: enter the product no.11 it will show the name and amt once
i was change the amt its automatically update in same product amount.
pls do the needful.
Regards,
deen
i need to update the excel data tru user form,
i have data like,
product no. name amt
11 soap 10
12 towel 15
13 powder 40
this are the data i need to update in excel sheet,
1. i need to create the user form in excel,once the excel is activate
automatically userform will open , i need make the 2 command button ,
1.new entry and other is 2.update
2. once i will click the new entry , the new entry data list will show
like product no. name amt ,and then click update button
its automatically saved in excel sheet.
3.once i will click the update , the update data list will show like
product no. name amt ,and then click update button its
automatically saved in excel sheet.(it will update data is already
stored) eg: enter the product no.11 it will show the name and amt once
i was change the amt its automatically update in same product amount.
pls do the needful.
Regards,
deen