Forum Discussion
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 a...
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?
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?
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
- 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.- Hi, yes I know a little about macros.... might be able to manage it thank you