+ Reply to Thread
Results 1 to 4 of 4

Need code for edit and save the existing data

  1. #1
    Registered User
    Join Date
    10-02-2011
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    19

    Need code for edit and save the existing data

    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.
    Attached Files Attached Files
    Last edited by senthil5031; 09-25-2020 at 06:24 AM.

  2. #2
    Registered User
    Join Date
    10-02-2011
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    19

    Re: Need code for edit and save the existing data

    Can any one pls help me

  3. #3
    Registered User
    Join Date
    10-02-2011
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    19

    Re: Need code for edit and save the existing data

    Dear Team,

    Waiting for your reply. Pls support me

  4. #4
    Registered User
    Join Date
    10-02-2011
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    19

    Re: Need code for edit and save the existing data

    Dear experts,

    Kindly help me to short out my query

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Adapting Existing Code to Offer Option to Save to Existing Folder
    By AliGW in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-28-2019, 07:37 AM
  2. Code to edit existing data instead of just adding when search
    By cloud.arreglado in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2018, 05:29 PM
  3. Edit Existing VBA Code To Send Out Email Confirming Receipt To Suppliers
    By hoofbeat in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-19-2016, 09:52 PM
  4. Modifying existing code to save worksheet
    By Woopwoop in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-26-2015, 08:54 PM
  5. [SOLVED] VBA code to save current worksheet as temporary PDF file and then add to my existing code
    By brianfromla in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-20-2014, 08:35 AM
  6. [SOLVED] Modify Existing Mbr Code to Save to Ext.Workbook
    By Miskondukt in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 03-06-2013, 02:36 PM
  7. Replies: 1
    Last Post: 08-15-2009, 05:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1