Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link different worksheets in different workbooks to 1 master workb
Each employee has a workbook each with the same fields which they update, I
want to create a master workbook with all of the data from everyones sheets which updates automatically when they make any changes? The fields will be the same, im thinking this would be a complex lookup function?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link different worksheets in different workbooks to 1 master workb
if the shhets are filled out the same you could link directly to the cells
you want showing up on your master sheet.In your master shhet in "johns" column type = then click on the cell in johns worksheet you wan the data showing in yours.Every time you open your master sheet you will be asked if you want to update the data or work with the data you alredy have -- paul remove nospam for email addy! "Anthony" wrote: Each employee has a workbook each with the same fields which they update, I want to create a master workbook with all of the data from everyones sheets which updates automatically when they make any changes? The fields will be the same, im thinking this would be a complex lookup function?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link different worksheets in different workbooks to 1 master w
The sheets have different data however the format of the data is the same and
the structure of each of the sheets is the same, i don't really see the point you are making Paul - if one of the employees enters a new row of data i want that to update the master sheet when it opens with your method i think new links would need to be added each time new data is added. Thanks for the initial help tho!! "paul" wrote: if the shhets are filled out the same you could link directly to the cells you want showing up on your master sheet.In your master shhet in "johns" column type = then click on the cell in johns worksheet you wan the data showing in yours.Every time you open your master sheet you will be asked if you want to update the data or work with the data you alredy have -- paul remove nospam for email addy! "Anthony" wrote: Each employee has a workbook each with the same fields which they update, I want to create a master workbook with all of the data from everyones sheets which updates automatically when they make any changes? The fields will be the same, im thinking this would be a complex lookup function?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you protect hidden linked worksheets with in an Excel workb | Excel Discussion (Misc queries) | |||
Variable Link to Workbooks | Excel Worksheet Functions | |||
how do i link a list of items in a workbook to worksheets in the . | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) |