can you guys help me out with this ?

[jackalsmp]

Is there a way to link two cells toghter so if I change one in a worksheet that it changes in another worksheet, its for an employee schedule that is 3 months, each month representing each month a seperate excel file but with the same roster,

 

[Datsmart]

Putting "=Sheet1!A1" in a cell in Sheet2 will allow that cell to always equal cell A1 of Sheet1. Is that what you are asking?

 

[tamrob23]

use the = sign to link the sheets together.

 

[jackalsmp]

OK how can I Link Workeets seperate files toghter.

how can I Link Workeets seperate files toghter. so that 1-workeet1 a1, changes when 2-workeet1 a1

 

[Datsmart]

Are you talking about WorkSheet pages or WorkSheets in different WorkBook files?

 

[jackalsmp]

WorkSheets in different WorkBook files.

 

[Datsmart]

Open both workbooks.
In cell A1 of workbook1 input an equal sign, "=". (without quotes)
Then go to workbook2 and click cell A1 in the sheet you want to link to.
Hit Enter.
The resulting formula in workbook1 will be "Absolute", (has $'s around your cell address).
Edit these out of the formula in cell A1.
Now you can drag your formula down or right to extend the links.
Is this what you are after?