Data captures by another spreadsheet?
 

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
--
6-West

Data captures by another spreadsheet?
 

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

e.g. =Sheet1!A1


--
mrice


------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=533779

Data captures by another spreadsheet?
 

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)
--
6-West


"mrice" wrote:


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

e.g. =Sheet1!A1


--
mrice


------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=533779

Data captures by another spreadsheet?
 

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 in
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 in
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.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=533779