| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Automatically plotting one cell from newly completed sheets
Hi
I have a spreadsheet that records productivity figures on a daily basis, so each day has a separate work sheet. I'm trying to get a graph to plot a single cell from each sheet. Ideally I would want to get the graph to automatically plot the same cell from any new sheets created. For Example, if I create a new sheet for the next day it would automatically add that new figure to the graph. I'm not even sure this is possible, but your comments would really help! Thanks Oli |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's the easiest way to relink sheets to a newly copied master. | Excel Worksheet Functions | |||
| Running macros in newly created sheets | Excel Programming | |||
| Automatically fill one cell in any newly inserted row | Excel Discussion (Misc queries) | |||
| in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions | |||
| how do i get the name of a newly added sheet that i add with Sheets.Add in a vba macro in excel? | Excel Worksheet Functions | |||
Threaded Mode
