Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Linking a repeating pattern of non-adjacent cells | Excel Discussion (Misc queries) | |||
Linking Non-Contiguous cells | Excel Discussion (Misc queries) |