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: 2
Default auto fill series between to non-adjacent cells

Hi. I wondered if there's any way that Excel can auto-fill a series of cells
between two cells.
For example - I cell AH contains the figure 280 and cell AW contains the
figure 258 - I'd like Exel to automatically fill the cells AI to AV so that
they decrease in equal increments down to the final cell. Is this possible?
Otherwise I have to divide difference between the two figures and decrease
each cell manually. This is something I need to do many times between
different cells.
I'd be grateful for any help. 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
Auto Fill Series issue... e3donald Excel Discussion (Misc queries) 3 April 26th 06 08:08 PM
Auto Fill Series when number ends in -1 JGus Excel Discussion (Misc queries) 7 December 23rd 05 03:14 AM
Can Excel auto-fill series such as 1A, 1B, 1C, 2A, 2B, 2C, etc.? Quality101 Setting up and Configuration of Excel 3 December 19th 05 11:04 PM
How can I autofill a series to reference non adjacent cells? Microcell Excel Discussion (Misc queries) 1 June 30th 05 09:49 PM
auto fill series Dave Excel Discussion (Misc queries) 2 January 19th 05 05:54 PM


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