in workbook1 i have written from A1 to A8 and I want this 8 cells to appear
as a drop-down list in a cell (e.g C3) in workbook2 and every time i change
something on the list in workbook one to be also changed on the drop-down
list on workbook2