ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Referencing Problem with moving cells (https://www.excelbanter.com/excel-discussion-misc-queries/105279-referencing-problem-moving-cells.html)

christy_181

Referencing Problem with moving cells
 
I am having a problem referencing a cell that always moves. I have data in
colomn A and tomorrow when I generate that data again I will put the new data
in the firt open cell in Column A. I have a chart that I want to reference
the new data.

example: I have data in cells A1 through A10 and my chart is reference cell
A10 tomorrow I will generate the days data and put my new number in cell A11.
Now I need my chart to reference A11.

I thought I could tell my chart to reference A12 -1 so that if i always
insert a row and then put the data in the row I inserted that this would
work. I just don't know what my formula would be.


All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com