Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 25th 05, 12:27 PM
Abes
 
Posts: n/a
Default Fill cells from non-adjacent cells

I am populating a worksheet with values from another worksheet.
For example the cells D6:Y6 on Sheet1, need results from various cells on
Sheet2. The problem is that the cells on Sheet2 are not contiguous, that is
they will be (for example) Sheet2!E15 (to populate Sheet1!D6), Sheet2!J15 (to
populate Sheet1!E6), Sheet2!O15 (to populate Sheet1!F6) and so on. (Note:
There is data in the cells between cell E15 and J15 and so on)
Is there a simpler way to 'auto-fill' these cells, or is there some quicker
way of accomplishing this rather than by cut and paste, or swapping between
worksheets for each cell.
--
Cheers

Abes

  #2   Report Post  
Old March 25th 05, 12:46 PM
Domenic
 
Posts: n/a
Default

Try...

D6, copied across:

=OFFSET(Sheet2!$E$15,0,(COLUMN()-COLUMN($D$6)+1)*5-5)

Hope this helps!

In article ,
"Abes" wrote:

I am populating a worksheet with values from another worksheet.
For example the cells D6:Y6 on Sheet1, need results from various cells on
Sheet2. The problem is that the cells on Sheet2 are not contiguous, that is
they will be (for example) Sheet2!E15 (to populate Sheet1!D6), Sheet2!J15 (to
populate Sheet1!E6), Sheet2!O15 (to populate Sheet1!F6) and so on. (Note:
There is data in the cells between cell E15 and J15 and so on)
Is there a simpler way to 'auto-fill' these cells, or is there some quicker
way of accomplishing this rather than by cut and paste, or swapping between
worksheets for each cell.

  #3   Report Post  
Old March 25th 05, 01:15 PM
Abes
 
Posts: n/a
Default

Thanks Domenic - seems to work a treat.
Cheers


"Domenic" wrote:

Try...

D6, copied across:

=OFFSET(Sheet2!$E$15,0,(COLUMN()-COLUMN($D$6)+1)*5-5)

Hope this helps!

In article ,
"Abes" wrote:

I am populating a worksheet with values from another worksheet.
For example the cells D6:Y6 on Sheet1, need results from various cells on
Sheet2. The problem is that the cells on Sheet2 are not contiguous, that is
they will be (for example) Sheet2!E15 (to populate Sheet1!D6), Sheet2!J15 (to
populate Sheet1!E6), Sheet2!O15 (to populate Sheet1!F6) and so on. (Note:
There is data in the cells between cell E15 and J15 and so on)
Is there a simpler way to 'auto-fill' these cells, or is there some quicker
way of accomplishing this rather than by cut and paste, or swapping between
worksheets for each cell.




Reply
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 auto fill blanks cells immediately below with the same i. leo Excel Discussion (Misc queries) 2 March 16th 05 06:03 PM
need to fill cells automatically Feltond Excel Worksheet Functions 2 February 18th 05 10:56 PM
how can i fill blank cells in column with abc while the right col. khurram saddique Excel Discussion (Misc queries) 2 February 12th 05 03:25 PM
Change a cell's fill color dynamically? Arlen Excel Discussion (Misc queries) 2 January 22nd 05 09:51 PM
Excel - formula to calculate colored fill cells within a range wi. MA Excel Worksheet Functions 1 January 7th 05 04:06 PM


All times are GMT +1. The time now is 06:10 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017