Hi Ron,

Thank you for you answer. However, I do have one more question. I saw the
post above mine you responded to titled "Gather data from multiple excel
files into one master." It sounds from reading that post, that we are both
asking the same question, but there are different answers. Possibly, I am
confusing workbook/worksheets? I am assuming they are filling out a
worksheet, since there is only one spreadsheet being filled out? Can you
explain further?

Thank you,

Jeanmarie

"Ron de Bruin" wrote:

Hi jeanmarie711

See
http://www.rondebruin.nl/copy2.htm

Or on MSDN
http://msdn.microsoft.com/en-us/library/cc793964.aspx

Download the example workbook to test


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"jeanmarie711" wrote in message ...
Hi ROn,

Each of them will be filling out their own worksheet.

THank you,

Jeanmarie

"Ron de Bruin" wrote:

Hi jeanmarie711

Workbooks or worksheets ?


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"jeanmarie711" wrote in message
...
Hi,

I have a spreadhsheet for training compliance that will be filled out by 4
different managers and they will be logging the compliance for their
respctive employees. I want to create something that will allow us to quckly
merge each of these spreadsheets into one. What is the easiest, quiest way
to handle this situation so that if their manager would like to do this, they
will have the capability without alot of extra work and direction. Each
spreasdsheet will be set up with the same headers.

Thank you,

Jeanmarie