LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
vmagal1
 
Posts: n/a
Default Absolute and Drag

I can't get the formula to drag over and change the last value when using an
absolute reference. I'm linking data from another worksheet and then
changing the cell in the formula bar to D$3 and it still treats it like its
all absolute. Help!
 
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
How do I set one cell as a constant so I can drag the formula juntipoikka Excel Discussion (Misc queries) 2 December 15th 05 01:36 AM
How do i drag formulas down derwood Excel Discussion (Misc queries) 2 November 5th 05 02:47 AM
Absolute Reference Aziz New Users to Excel 2 September 30th 05 01:38 PM
How can I copy from 1 cell to 30 others PeterM Excel Discussion (Misc queries) 7 April 11th 05 02:29 AM
Conditional Formatting for dates spacerocket Excel Worksheet Functions 2 November 4th 04 10:13 AM


All times are GMT +1. The time now is 02:51 AM.

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"