LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
jon104
 
Posts: n/a
Default how do i copy a formula when cell references r not together

in cell reference H5 i have a formula H4*H3, I have copied this formula
through to DG5. In cell reference H7 I have a formula H6*H3 which i have also
copied through to DG7.I have formulas right down to cell reference H299
(H298*H3) Is there a quick way to repeat the copy bearing in mind the cell
references are not together ie H5, H7, H9 and so on.
 
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
copy and pasting a find all list into another column Ben Excel Discussion (Misc queries) 18 December 31st 05 10:51 PM
copy formula using same references macsworks Excel Worksheet Functions 3 December 1st 05 01:49 AM
Copy cell formula help tamato43 Excel Discussion (Misc queries) 2 March 31st 05 12:55 AM
How do you copy a cell formula down a column without displaying n. Coddie Excel Worksheet Functions 4 January 18th 05 02:31 PM
When I copy down into the next cell the formula changes correctly. Jason30 Excel Discussion (Misc queries) 1 January 12th 05 11:55 PM


All times are GMT +1. The time now is 12:28 AM.

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

About Us

"It's about Microsoft Excel"