Excel Macro to automate data entry to printable form

  • Posted
  • Proposals 14
  • Remote
  • #10491
  • Archived
Ian M.Paul T.Melanie K.Irina I.Manjunatha L. + 9 others have already sent a proposal.
  • 4


Experience Level: Expert
We have to complete various fields in an excel form, and then print, sign and send it. (old skool!)
The data is sourced from our excel database (dummy version attached). We are currently manually copying and pasting into the relevant fields in the data form ('subpub notifications' attached). Clearly this can be automated - we need your help
I have attached a couple of copies of the form we have to complete, with the fields highlighted which need to be entered.
The data necessary for each form is contained in one horizontal line in our excel database, so the lookup is quite straighforward. It is populating the fields that we need the help with, and automating for bulk output (10s to 100s at a time)
We want the macro to generate forms from selected records in the database at any one time - and to be able to do it to order as when required in the future.
By the way, it is not obligatory to generate an excel file, as long as we end up with a printable form in the same layout as the attached document.

Clarification Board

    There are no clarification messages.