LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default automatically add to cell formula

Here is my question:

1 2 3 4

$1.15 $1.17 $1.59 $1.43

'Data'!$G11 'Data'$G33 'Data'$G55 ????

I want to be able to automatically drag my formula across....each time
adding 22 to the cell reference.....so the next cell formula above would be
'Data'$G77...?
Right now I am doing this manually....any ideas?
Thanks
 
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
set up a formula to automatically fill down from previous cell audif New Users to Excel 4 January 15th 07 07:26 PM
How do I create a formula where a cell is automatically shaded ? Rafi2288 Excel Worksheet Functions 1 April 21st 06 03:14 AM
Cell Ref. in Formula changes automatically knighthawk Excel Worksheet Functions 1 February 21st 06 01:02 AM
Formula automatically changing cell references Nina Excel Worksheet Functions 1 February 8th 06 09:55 PM
Automatically Converting Formula in a Cell to its Value at the End of the Day Ronald Lawrence Excel Worksheet Functions 6 October 6th 05 09:59 PM


All times are GMT +1. The time now is 04:47 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"