Update data in one sheet and automatically update the same data on another sheet

    Hello,


    I need help with a couple things...


    1) - I have a workbook that contains work order templates. I need certain information from the templates to go to another workbook called "Job Schedule". That information needs to save to 2 sheets in the "Job Schedule" book, in sheet called "All Jobs" and the job type department sheet. (Steel Siding work order information saves to "All Jobs" and "Steel Siding" sheets).


    Save Steel Siding Work Order information from cells...


    A2 Job Type
    G6 Date Sold
    A8 Customer Name
    D8 Contact Person
    F8 Phone Number
    G8 Cell Number
    A10 & G10 Job Location (These 2 need to save in one cell)


    To Workbook "Job Schedule" sheets "All Jobs" and "Steel Siding" cells D:K in the next row available.



    2) - Once the jobs are in the "Job Schedule" book I need to go back to update the job status according to the progress and enter some additional information. I would like it to automatically update the same job in the "All Jobs" sheet when I update the it in the "Steel Siding" sheet.



    I hope this makes sense...

    Re: Update data in one sheet and automatically update the same data on another sheet


    The one thing that seems to be missing is a unique identifier... How will you identify which rows to update?

    Re: Update data in one sheet and automatically update the same data on another sheet


    Currently I am entering the jobs manually in the "All Jobs" sheet where I give it a number in column B. From there I copy and paste it with the number onto the corresponding department sheet.

    Re: Update data in one sheet and automatically update the same data on another sheet


    One thing that is necessary is to fully explain the scenario - otherwise how can anyone help?


    I could make a suggestion based on what you've said, along with the further explanation that there's an number in Col B which can be used to identify the record, but what else has been unsaid? I also don't understand why you need 2 workbooks. On the face of it, 1 workbook, filtered by department when necessary could possibly do what you need.


    Upload a sample workbook including sample data (anonymised if necessary)

    Re: Update data in one sheet and automatically update the same data on another sheet


    Quote from cytop;743631

    One thing that is necessary is to fully explain the scenario - otherwise how can anyone help?


    I could make a suggestion based on what you've said, along with the further explanation that there's an number in Col B which can be used to identify the record, but what else has been unsaid? I also don't understand why you need 2 workbooks. On the face of it, 1 workbook, filtered by department when necessary could possibly do what you need.


    Upload a sample workbook including sample data (anonymised if necessary)



    It won't let me upload sample workbooks.

    Re: Update data in one sheet and automatically update the same data on another sheet


    The example file may be too big, so try zipping it before uploading.


    If that fails then up;oad the file to DropBox, OneDrive or similar then provide a download link here

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login