Thread: Saving Separate Worksheets

Hi there

I hope someone can help as soon as possible. I am busy building a Workbook with a large number of worksheets within it.

The goal is to be able to work only in the first or "master" worksheet, and once it has been completed with values, I would like to click a custom button that updates the corresponding values in the other worksheets. This I have managed to do.

However, once this has been done, I would like each separate worksheet to save into separate files and for the "master" worksheet's values (which are in the range D11:D66) to be cleared.

Each of the cells in this range correspond to one of the worksheets in the workbook. Therefore, each time I repeat this process, I only want the master to be cleared and the other worksheets to add the new values into the row beneath the previous entry.

Is this possible?

I really would appreciate any help and thank you all in advance.

Sincerely

PVanS

The most useful thing pretty much anyone asking a question here can do is to attach a small sample workbook which illustrates how your data are set out and desired results.

OK, a few questions. Your code currently has all the worksheet names hardcoded - are they fixed or could new ones be added? You refer to D11:D66which suggests a lot more sheets. If you have that many, a loop might be quicker.

Also, if you want the sheets saved as separate files then you don't really need them as sheets in the file. Might it not be simpler to retain the sheets in the one workbook and just save that workbook?