USD $30 to copy data from one sheet to specific rows on another sheet when updated

    Hello, I need to get the following added to this worksheet. I sent the 10% to paypal@Ozgrid


    When a container is assigned a door number on the Inbound Report tab, I need the data copied to the corresponding door number on the Dock Doors tab. Highlighted when Empty, Not highlighted with other status. See the example. This would then change as we update the Inbound report. If there is nothing assigned to a specific Door #, it would remain blank until used on the Inbound report tab. No Manual updating will be done on the Dock Doors tab. Please let me know if more information is needed. The other functions in this worksheet will work the same as they do now.

    Re: USD $30 to copy data from one sheet to specific rows on another sheet when update


    Some questions. Some parts of your request are a bit vague and I like to be specific.


    1. "When a container is assigned a door number on the Inbound Report tab". Do you mean when the user types the door number in the column C cell?
    2. "the data copied". Do you mean the data in cells A, B and D on the same row? In the order B, D, E?
    3. Why is there missing data on the "DOCK DOORS" sheet? For example, door numbers 12, 13, 14, 88, 89 have container numbers on the "INBOUND REPORT" sheet, but they are not shown on the "DOCK DOORS" sheet.
    4. Do you want the updating of the "DOCK DOORS" sheet to be done automatically and immediately when the user types in a door number? Or do you want to let the user enter one or more door numbers, delete door numbers, change door numbers, change status, container number, etc. on the "INBOUND REPORT" sheet and then click a command button to update the "DOCK DOORS" sheet? The latter approach will probably be easier to code.

    Re: USD $30 to copy data from one sheet to specific rows on another sheet when update


    Hello,
    1) Yes a user will type the door number in column C cell.
    2) Yes
    3) the data typed in on on the DOCK DOORS was put in manually by me for example only. to show how it will look
    4) A command button to update would suffice. Like I have on the header row would be fine, next to the Create report one.


    Thank you -

    Re: USD $30 to copy data from one sheet to specific rows on another sheet when update


    Wow that was fast, the only thing i see that it is not doing it not taking it off the DOCK REPORT when the container line item moves to the completed tab after updating

    Re: USD $30 to copy data from one sheet to specific rows on another sheet when update


    I think I understand you. When a row moves (is deleted?) to the Completed sheet, that Door Number will not exist on the Inbound Report sheet and therefore that Door Number record should be empty on the Dock Doors sheet. I've therefore changed the code to first clear all Door Number records on the Dock Doors sheet. With this change some of the previous code is not needed and has been commented out.


    forum.ozgrid.com/index.php?attachment/71549/


    Again, please be more specific if my understanding is incorrect.

    Re: USD $30 to copy data from one sheet to specific rows on another sheet when update


    That did it John, That works as needed. One Small change if possible? on the DOCK DOORS column (E, and K) I need the carrier listed in INBOUND REPORT Column G to populate?

    Re: USD $30 to copy data from one sheet to specific rows on another sheet when update


    Yes Sir, that is what I needed. Thanks for the quick work. Pay pal sent #62A37299YF4203033

Participate now!

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

Register Yourself Login