LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 46
Default absolute cell references

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell References absolute? BobC Excel Discussion (Misc queries) 3 July 21st 08 04:11 PM
Sumproduct absolute cell references Judy Excel Discussion (Misc queries) 5 July 4th 08 09:20 AM
convert relative cell references to absolute cell references via amacro? Dave F[_2_] Excel Discussion (Misc queries) 1 May 15th 08 04:43 PM
Absolute references in a cell Glennk Excel Discussion (Misc queries) 1 January 23rd 07 03:28 PM
Absolute References in cell formula ah666 Excel Worksheet Functions 5 June 17th 05 03:40 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"