Hi,

My department has just taken over responsibility for the creation of a
number of datasheets in several languages. These are all produced in Excel.

We draw our data from tab separate value text files. These contain lists of
specifications that shouldnt vary from one file to another. However, the
order the specs are in does vary, and sometimes a given spec is missing.

What we want to do, is find some way to automate the stuffing of datasheets
by getting Excel to look for the name of each specification, then to copy the
data in the cell seven cells to the left into the right field in our data
sheet. And we need to do this for all languages

So, instance, we have our template datasheet and our source text file open
in the same instance of Excel. Excel looks at the document and sees that cell
J6 contains the value €œProduct Name€�. In response, Excel copies the value in
cell Q6 of the source document to cell B1 of the template datasheet. It then
carries on and does the same for all the standard values it can find in the
source, population the datasheet with all the required values that can be
found in the source document.

In the best case scenario we need the script, or batch file or whatever tool
we need to start with one source document, stuff the relevant language
template, then move on to the next source document and language template. We
also need to it not to get stuck and just stop if it doesnt find the source
document and template for a given language €“ sometimes we dont have
datasheet for every language.

I know this is incredibly complicated €“ but if anyone could even tell me
what I need to learn to find a solution that would be great.

Thanks

Karl