Mar 09 2018 07:00 AM
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.
Mar 09 2018 08:01 AM
Mar 09 2018 08:15 AM
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
Mar 09 2018 08:31 AM
Mar 09 2018 10:17 AM