Mohamedforse
New Member
Hello everyone,
I'm working on a sheet and I would like someone to help me with this VBA part. I would like to add a button to the "Delivery Transaction" sheet and the "Receiving transaction" sheet. These two buttons are supposed to read a number from a cell and search for it in the "Treasury movement" sheet. One in the "Delivery Number" and one in the "Receiving number" respectively. Then the button is supposed to retrieve the row according to the data saved and fill the form in the sheet it is in. Then this data can be edited and submitted again in the "Treasury movement" sheet.
So basically its a search and edit functionality in both "Delivery transaction" and "Receiving transaction".
Thank you.
note :
password VBA : 16Momi292
unprotect sheet for any sheet : 123456789
I'm working on a sheet and I would like someone to help me with this VBA part. I would like to add a button to the "Delivery Transaction" sheet and the "Receiving transaction" sheet. These two buttons are supposed to read a number from a cell and search for it in the "Treasury movement" sheet. One in the "Delivery Number" and one in the "Receiving number" respectively. Then the button is supposed to retrieve the row according to the data saved and fill the form in the sheet it is in. Then this data can be edited and submitted again in the "Treasury movement" sheet.
So basically its a search and edit functionality in both "Delivery transaction" and "Receiving transaction".
Thank you.
note :
password VBA : 16Momi292
unprotect sheet for any sheet : 123456789