This is a two part question. I am working on a program that other people in my office will be using. Rather than saving the data in the program itself, I am trying to create a separate data file. Is there a way to copy certain cells (i.e. C2, D2, E2, ...) from a worksheet in one workbook into a new workbook and then prompt the user to save the new workbook? The second question is there a way to copy those particular cells from the data file to the cells in the main program? Any help is greatly appreciated!