Home |
Search |
Today's Posts |
#1
|
|||
|
|||
linking several worksheets to one workbook
I am trying to link my employees time and labor logs which they fill out on
the company computer to a master workbook which will show all there information that they filed out. I am able to link one cell at a time, but am unable to link a complete worksheet at one time. |
#2
|
|||
|
|||
If you have something in Column A from which you would know the
sheetname for that employee (name or emp#). F2: =IF($A2="","",INDIRECT($A2&"!"&B$14)) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "manager in training" <manager in wrote in message ... I am trying to link my employees time and labor logs which they fill out on the company computer to a master workbook which will show all there information that they filed out. I am able to link one cell at a time, but am unable to link a complete worksheet at one time. |
#3
|
|||
|
|||
I know for most users this information would be very useful, but I am sad to
inform you that I need a little more detail. I am trying to link up to 20 different electronic time sheets into one workbook which are linked together. Every employee has a username for the office computer, and I am the admin. for the computer. I have tried to copy their sheets and pasted them in my workbook that I created, but it did not link them to update when I opened the workbook. Please give me a little more information on this subject. Thanks "David McRitchie" wrote: If you have something in Column A from which you would know the sheetname for that employee (name or emp#). F2: =IF($A2="","",INDIRECT($A2&"!"&B$14)) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "manager in training" <manager in wrote in message ... I am trying to link my employees time and labor logs which they fill out on the company computer to a master workbook which will show all there information that they filed out. I am able to link one cell at a time, but am unable to link a complete worksheet at one time. |
#4
|
|||
|
|||
You would not want it to be as messy as the example on my buildtoc2
page, meaning you will have to code the cells into your workbook rather that showing the addresses that you want to go to but look at http://www.mvps.org/dmcritchie/excel/buildtoc2.htm I just did a web search and it turned up the one I would have thought best. Obviously if all the information is on one sheet in the HTML picture then they must be tied in together in the complete example see. Employee Time Sheet http://j-walk.com/ss/excel/files/timesht.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "manager in training" wrote in message ... I know for most users this information would be very useful, but I am sad to inform you that I need a little more detail. I am trying to link up to 20 different electronic time sheets into one workbook which are linked together. Every employee has a username for the office computer, and I am the admin. for the computer. I have tried to copy their sheets and pasted them in my workbook that I created, but it did not link them to update when I opened the workbook. Please give me a little more information on this subject. Thanks "David McRitchie" wrote: If you have something in Column A from which you would know the sheetname for that employee (name or emp#). F2: =IF($A2="","",INDIRECT($A2&"!"&B$14)) --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "manager in training" <manager in wrote in message ... I am trying to link my employees time and labor logs which they fill out on the company computer to a master workbook which will show all there information that they filed out. I am able to link one cell at a time, but am unable to link a complete worksheet at one time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking cells in a worksheet to other worksheets in a workbook | Excel Discussion (Misc queries) | |||
Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
Linking Workbooks | Excel Worksheet Functions | |||
linking worksheets in same workbook | Excel Discussion (Misc queries) | |||
Linking Data between worksheets in a workbook | Excel Worksheet Functions |