Forum Discussion

Rebecca Oates's avatar
Rebecca Oates
Copper Contributor
Mar 09, 2018

Transfer data from one workbook which constantly changes to another

Hi

 

i have a worksheet that i have set up to look like a form and i fill it in giving it a unique number and then PDF to keep on file. i then reopen the same worksheet and give it a new number and then repeat the process.

 

I have a formula to pick up the data from the original worksheet but as i am constantly changing it i am unsure how to do it?

 

Ultimately i want to end up with an automatically generated list of the unique numbers with the associated info copied across

 

Thanks in advance

 

thanks in advance for any help.

excel
Formulas and Functions

4 Replies

  • Jamil's avatar
    Jamil
    Bronze Contributor
    Mar 09, 2018
    So, if I understood correctly.

    In one single sheet you want to have in a column list of unique numbers and then in the next columns of this MainSheet the associated info from those files in folder to be populated. Did I understand it correctly?
    • Rebecca Oates's avatar
      Rebecca Oates
      Copper Contributor
      Mar 09, 2018

      Hi

       

      thanks for your reply, i have attached basic info from the two files for you to view.

       

      So in the one names "Form" i would input a unique number next to DPS/HWL/TRN/#### (highlighted in red) so for example the first one will be DPS/HWL/TRN/0001

      i would then contiune to fill out this form adding date and details etc

      The sheet "summary" would then pick up that unique number and all the corresponding info i have listed in the separate columns. However i would then PDF the "form" and then start again on the same on but with a new number.... this means "summary" will overwrite what it picked up from 0001 with info from 0002.... is there a formula i can use so it keeps 0001 info then adds 0002, 0003 etc underneath ?

       

      thanks

      • Jamil's avatar
        Jamil
        Bronze Contributor
        Mar 09, 2018
        if you want this automated, can you work with macros?

        I can write some code for you that when you complete your form, it automatically add the details in the summary list and everytime you add new DPS/HWL/TRN with new sequence, it will add it to the list and will not overwrite it.