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
Bookmarks