Automating datasheet stuffing

[kwinsw]

Hi,

One of the jobs my department has to do is stuff excel datasheets with data from text files (tab separated values files). I want to automate this process, but I’m not sure the best way of doing it.

Basically I need something (a macro a script, I’m not sure) that looks a column A of the source document, if it sees a particular value, for instance the words “Product Name”, it should then take the value in the corresponding cell from column B and copy that value from the source file to a specified cell in the datasheet. If the macro/script or whatever can’t find a value it’s looking for, I need it to populate the relevant cell of the datasheet with the letters TBA.

Can anyone tell me how I can go about this? Any and all help very gratefully received.

Thanks

kwinsw

 

[SkipVought]

Hi,

If the entire text file can fit in a sheet (less than 65,536 rows and 256 columns), import the entire file -- Data > Get External Data > Import...

Then you can use LOOKUP functions to get data into other sheets.

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}