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