Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
REPT FUNCTION FROM WORKBOOK TO WORKBOOK
EXCELL 2003
I have a job that requires I create several cheat sheets in order to keep all the information at my fingertips. Some information is basically on all the cheat sheets. Now, when something changes, I have to go into each one and change only that sheet. I created a master workbook(I hope I'm using the correct verbage) that contains all of the common data, so when one piece of information changes, it will automatically change all sheets in other workbooks that I formulate to refer to it. The problem is my formula works for a first time trasnference of data, but no changes after that made to the master workbook will be passed on to each individual workbook/sheet. Here is the formula I'm using in one particular cell: =REPT(([MASTERCHANGEFILEWORKSHEET.XLS]Sheet1!$H5),1) Do I have to add to this formula or is there another reason why changes to the master do not transfer? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Basic bar graphs using rept function - Printing problems | Excel Worksheet Functions | |||
Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) |