Forum Discussion
record data from a specific cell at the same time once per day?
The problem was that the code used different worksheet names.
I have given cell Z129 on Sheet1 the name CurrenPercentage. If you insert or delete rows above it, or columns to the left of it, Excel will automatically adjust the definition of the name. The code now uses the name instead of the literal address Z129.
(I took the liberty to change some date formulas on Sheet1 to hide errors)
The problem was that the code used different worksheet names.
I have given cell Z129 on Sheet1 the name CurrenPercentage. If you insert or delete rows above it, or columns to the left of it, Excel will automatically adjust the definition of the name. The code now uses the name instead of the literal address Z129.
(I took the liberty to change some date formulas on Sheet1 to hide errors)
Hans, I plotted a line graph on sheet 3 to show the data of the specific date with that day's availability. I had to manually do this. Is there way to have the graph update automatically when the spreadsheet updates itself in the columns A and B of sheet? Is this done with a macro also?
I attached the spreadsheet as fresh so I can start from scratch and move forward nice and neat.
No, you don't need VBA for that.
In the attached version, I have created dynamic named ranges XValues and YValues - see Formulas > Name Manager for their definition.
I then changed the data source of the chart series to refer to XValues and YValues.
The chart will automatically expand as new data are added.
- Ok thankyou so much for explaining that to me. I appreciate so much your help and explanations.