Hi James,

I'm still not clear about your requirements. My questions are below:

------------------------------------------------------------------------------------------
On Mar 24, 4:51 am, James wrote:
The data comes to me in one workbook with multiple sheets. I have a template
that is specified for my oracle uploading. I would like to see the data come

How often do you receive the workbook?

Do you use the data contained in the multiple sheets?

Does your template have multiple sheets?

Is the template file extension ".xlt"?

Earlier you mentioned that you wanted to automate to stop cutting and
copying. Did you try recording these manual actions in a macro? If so,
what does it look like?

from the provided data into my template. My template is set-up so that each
sample has its own row. I do not think a transpose will work for this.

Does the workbook you receive with multiple sheets contain one sample
on each sheet?

It appears the data in the sample has each sample field on a new row.
Your template appears to put all the fields from the sample record in
one row. That seems like a transposition to me.

Below you will find the code I have. This code is only for locating where
the data is coming from, I do not know how to attack the importing part of
the macro.

Where do you store the macro? In a general module, a sheet module,
this workbook module?

Dan
________________________________________________