Basic Excel feature request

[malcubed]

This seems like it should be simple. I want to be able to make a worksheet full of data and charts showing assorted data summaries. I want to be able to cut copy and paste that into a new worksheet, and plug in a new day's batch of data. (So far, no problem). I would then love to be able to click a button that updates all of the graphs on the

Comments

[malcubed]

That is in fact exactly the problem I'm griping about, that you have to manually go into each data set of each chart and change the link to the current worksheet from the previous worksheet that was copied. "Refresh All" only works if you change the original data, but I want to keep the original data in place where it was and start a new worksheet with the same layout, but different data (because one worksheet will be Tuesday's experiment, and the next will be Wednesday's).

[malcubed]

Now I don't think I understand. If you're talking about just copying the data, the problem is then making all the same charts again from scratch on each new worksheet, which would be even more time-consuming. What I've been doing is just making a new worksheet in the same file, selecting all, copying, pasting, and then deleting the data from the previous worksheet and replacing it with the new data.

[elfdope]

I would visual basic up a macro on page 1 that saves it to a new tab, and then goes blank awaiting your new data to be entered. Although that might be too much work. It really depends how long you plan to be using the sheet.