Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Referencing to cells in a sorted list | Excel Discussion (Misc queries) | |||
Moving cells to another workbook sequentially | Excel Discussion (Misc queries) | |||
moving cells based certain value | New Users to Excel | |||
pasting or moving formula cells without updating formulas | Excel Discussion (Misc queries) |