Thanks. I have one more question pertaining to this. The master workbook
(workbook1) will be used by the boss while all other workbooks will have the
an employee's name as the filename.

I want the boss to be able to add to the master list any criteria
(questions) he would like to add to the list already in place. I will have
an adjacent cell to the criteria (for QA purposes) that will indicate the
date the criteria was added.

I am guessing I need to use the xlUP to locate the first empty row at the
bottom of the list in each employee workbook. So, given the following data,
what would the code be:

WORKBOOK1 (Master).Sheet1
NOTE: Boss adds a new criteria to QA list in B30 with date added in A30.
Need to
update all workbooks for each employee.
A30 = 05/05/10 (date format)
B30 = Are all signatures obtained? (text format)
D1:D? = Each employees name (Unknown how many rows needed for employees)

WORKBOOK2-?? (Each named for an employee listed in workbook1
SHEET1
A1-A? = list of criteria based on master list

Thanks,
Les

"Bob Umlas, Excel MVP" wrote:

Sub Answer()
Workbooks("Workbook2.xls").Sheets("Sheet2").Range( "A1").Value =
Thisworkbook.Sheets("Sheet1").Range("A1").Value
End Sub

"WLMPilot" wrote:

I would like to know how to take data in cell A1 of Workbook1.Sheet1 and
place it in cell A1 of Workbook2.Sheet2 via a macro from workbook1?

Thanks.