Pulling data into another spreadsheet

  • Hi everyone


    Hopefully I have created this thread in the correct place. I would like to set up a purchase order where you complete the PO number and it pulls all data into each section of the PO from a PO register. I know I could do this with a vlookup for figures but thought there would be a better way to do this as it needs to bring in descriptions as well. I also do not want people to be able to amend anything (as this info should all come from the register).


    Can anyone help me with this?



    Thanks very much in advance

  • It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • Thank you Mumps, sorry for the delay. I have attached a file showing the PO register and the PO itself. I know I could set up vlookups to bring the data in (I don't know if this works on text as well as figures). I think that both files need to be open for that to work though? I want to be able to type the PO number into the PO and it bring all the data in such as qty, unit amount, description, date, code, authoriser etc and for the information to stay there so the PO can be saved as a static file to be sent out. I hope I've explained this ok.

  • Thank you for the post, however, you have posted pictures which are hard to work with. Please post copies of the actual files by clicking the "Attachments" link at the bottom of the response window.

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • Try the attached files. Make sure that both files are open. In the PO template, click on cell H3 and a calendar will pop up where you can choose a date. Next click on H4, enter a PO number and press the RETURN key. Your data will be populated automatically. Please note that I have deleted all the extra empty columns in the Register file. It is now only 21 KB in size whereas your original was 733 KB.

    Files

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.