Remember Me?

#1
March 25th 05, 12:27 PM
 Abes Posts: n/a

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
March 25th 05, 12:46 PM
 Domenic Posts: n/a

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
March 25th 05, 01:15 PM
 Abes Posts: n/a

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post leo Excel Discussion (Misc queries) 2 March 16th 05 06:03 PM Feltond Excel Worksheet Functions 2 February 18th 05 10:56 PM khurram saddique Excel Discussion (Misc queries) 2 February 12th 05 03:25 PM Arlen Excel Discussion (Misc queries) 2 January 22nd 05 09:51 PM MA Excel Worksheet Functions 1 January 7th 05 04:06 PM

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