Data captures by another spreadsheet?

S

sixwest

Is there any way for data entered in one spreadsheet to automatically
propagate to a specific cell on another sheet (same workbook)? What I have is
a basic training schedule where times are entered and cross-referenced with
a column of students. What I'm looking for is a way for those entered times
to automatically copy to another sheet that I plan on setting up as a
standard print out (column "A": NAME, column "B": TIME).

Thanks
 
M

mrice

The easiest way is to set up formulae on the second SS which link to the
first.

e.g. =Sheet1!A1
 
S

sixwest

Thanks, I'm going to push my luck...

What I'd ultimately try to do is to have a link between the sheets but with
different data being propagated. Such as:

Sheet "A" is the schedule sheet with employee names listed. Let's say
Employee "1" is listed in cell A1 and I input 9:30 AM in cell B1 (i.e.,
Employee "1" scheduled for 9:30).

Sheet "B" is a list of the schedule times. If 9:30AM is in cell A4, is there
a way to automatically propagate "Employee 1" into B4 when "9:30 AM" is input
to B1 on Sheet "A"?

Thanks again (I think I'm moving into "Access" here)
 
M

mrice

An easy way to do this is with the VLOOKUP function

Set up sheet1 with three columns

Employee Time Employee

Enter your employee names into column A
Enter = A2 into C2 and drag down to get a copy of the employee list i
column C

On sheet 2 enter your times in column A
In the Cell adjacent to the first time (lets say its A2 so enter i
B2)

=IF(ISNA(VLOOKUP(A2,Sheet1!B:C,2,0)),"",VLOOKUP(A2,Sheet1!B:C,2,0))

I hope that this gives you what you need
 
Top