Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Guys,
I collect 3 columns of data every day. I have about 25 days worth of data, and I store it in columns A,B,C E,F,G I,J,K etc. The columns go up to CW,CX,CY or so. Each day I delete the oldest data (in Cols A,B,C). All the data moves to the left, and I add the latest days data in Cols CW,CX,CY, which are then empty. On a second worksheet I reference this data. My problem is that as I delete columns in the first worksheet, the references in the second worksheet change. I dont want the references to change. I have tried using the $ sign for this, but it doesnt work here. Im using Excel 2003. Any suggestions? Rusty. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell References absolute? | Excel Discussion (Misc queries) | |||
Sumproduct absolute cell references | Excel Discussion (Misc queries) | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Absolute references in a cell | Excel Discussion (Misc queries) | |||
Absolute References in cell formula | Excel Worksheet Functions |