Dear Team,
I need code for edit the existing data filtering by dropdown and save it again on the same .
I am having three sheets ( Inward_New, Inward_Edit, Inward_View & Inward_print).
I am entering all the data on sheet "Inward_New". Once i select the Save button it will save all the details to sheet "Inward_View" and convert&save pdf file to folder through sheet "Inward_print'.
In sheet "Inward_Edit" if I select the JOB No from Cell "D7" (dropdown), it should display all the fields as per the JOB No which is available on the sheet "Inward_View".
After I edit the required field once I click the "Update and Save" button, it should over write the data in sheet "Inward_View" and pdf file also and all the files should go to blank except JOB No.
I am getting confusion how to do this. Can any one please help me how t do this.
I am attaching my file here for your reference.
Bookmarks