I hope someone out there can help me. What I have is several workbooks that have lookup up lists in them. The list is the same for all the workbooks. What I would like to do is have just one master list, so when the list needs to be edited it only has to be edited once not multiple times for every given workbook. I have been able to get the look up lists to work when its in a seperate file, but occationally I need to copy data from the list to a given worksheet or workbook. I have been able to make this work inside a given workbook, but I can't get the code to work for copying from another workbook. I hope I am making since here. The problem I am having is opening and closing the copy source and the getting the it to select the destination. It seems very simple, but I can manage to do one or the other not both.
Any help is much appreciated.
Paul
Any help is much appreciated.
Paul