Hi, I am looking at potentially automating a process now done manualy.

The Test lab head currently assigns test numbers in an Excel fle. (format:
08 xxx) He enters the test requester and lab Technician name and brief
description of testing to be done. Later on a file folder is opened (in the
2008 folder) under that test number. Into the file goes the test data on a
work sheet with that test number. On the work sheet the test number, and the
other information, gets copied by the Tech.

I would think there would be an elegant way of doing this with Macro
functions. I can think of several ways to copy the data from one spread sheet
to another, but not how to automatically create the file folder and worksheet
with the test number.

We are using Office 2003.
--
Jim, an engineer using Excel not wisely