Share this Job

Job Details

Category:IT/Web/Programming > General Programming

ID:10491

Title:Excel Macro to automate data entry to printable form

Location:Anywhere

Job Description

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.
cheers!
Jt

Job Budget

Type:Fixed Price

Budget:Up to £250 (Approx Up to $392)

Additional Information

Attached Files:
Project-dummy catalog.xls
Project-subpub notif... (Brisker, Magitman).xls
Project-subpub notif...ES (Hawkins, Zidane).xls

Bidding ends:Bidding Closed

Job Posted:15/08/2009 16:33

Bidding activity on this Job

Bids:19

Who has Bid:

Clarification Board

D. C. on 18/08/2009 11:14
Hi John

Looks like a relatively simple excel requirement. But just want to clarify a few things:

1. When you say "selected records" are you imagining a query facility that will select a sub-set of catalogue records to print or is this more like visually inspecting the contents of the database and tagging a number of records for printing?

2. Once printed would the rows in the database need to be "tagged" as printed -say using a date/time stamp?

3. Very approximately how many rows will there be in the catalogue?

4. Are all rows in the catalogue potentially eligible for printing at some stage?

5. Is there one field (or, combination of fields) that defines uniqueness within the catalogue? Looks like MCPS_TUNECODE might be a candidate?

Thanks

M. L. on 27/08/2009 09:03
Hi John,

Any news on this project,
its fairly simple project, automation should avoid manual copy pasting of data.

I have done this kind of work earlier, I can deliver Solution... within a week, well tested, for £65.00

Let me know your thoughts.

Thanks & regards
Manjunath