Is there any way to record a macro that will do the following:
1. Open a new worksheet
2. Copy some of the data from the previous worksheet using "=sheetx!a1"
3. Apossibility of creating a button on this new worksheet which when
clicked repeats the same set of isntructions after a month.
Basically what I am trying to do is link all worksheets, so that if change
is made in some selected cells in previous worksheet, it is reflected to the
worksheets following it. It will be great if a button can be created to do
so. Is there any way to create a button on the newest sheet so that when its
clicked, a new sheet is created with data from the previous worksheet is
copied to it?