linking cells
 

Hi im totally baffled.
run a small business need to make live easier having to duplicate cell
info manually into other worksheets.

dont understand where to start
initially i give a custer a ref no. take all basic info then assign to
an employee who has there own spreadsheet with more info on that person
there are also various woorksheets inside this

How do I get them to link??

please help URGENT


--
tricksydixie
------------------------------------------------------------------------
tricksydixie's Profile: http://www.excelforum.com/member.php...o&userid=16524
View this thread: http://www.excelforum.com/showthread...hreadid=313780

Hi
only as a starting point:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"tricksydixie" schrieb im
Newsbeitrag ...

Hi im totally baffled.
run a small business need to make live easier having to duplicate
cell
info manually into other worksheets.

dont understand where to start
initially i give a custer a ref no. take all basic info then assign
to
an employee who has there own spreadsheet with more info on that
person
there are also various woorksheets inside this

How do I get them to link??

please help URGENT


--
tricksydixie
---------------------------------------------------------------------
---
tricksydixie's Profile:
http://www.excelforum.com/member.php...o&userid=16524
View this thread:
http://www.excelforum.com/showthread...hreadid=313780

To link a cell from one sheet to another.......

Assume two sheets, sheet1 and sheet2

In sheet2 in a cell =Sheet1!A1

When A1 in sheet1 changes, the cell in sheet2 will update.

You can also link across workbooks in the same manner, except preface the
formula with the workbook name.

You can also select a cell or cells on sheet1 or book1, copy then switch to
other sheet or book and Paste Special"Paste Link".

Excel will add the linking formula(s)

Gord Dibben Excel MVP

On Tue, 16 Nov 2004 08:25:30 -0600, tricksydixie
wrote:


Hi im totally baffled.
run a small business need to make live easier having to duplicate cell
info manually into other worksheets.

dont understand where to start
initially i give a custer a ref no. take all basic info then assign to
an employee who has there own spreadsheet with more info on that person
there are also various woorksheets inside this

How do I get them to link??

please help URGENT