Remember Me?

#1
May 16th 05, 08:39 AM
 Posts: n/a
copy exact values from RangeA to Range B which has extra rows

I have two worksheets 'A' and 'B'.
'A' has 1064 rows of data.
'B' has 7448 rows of data.
I want to reference the data from cells in a column of 'A' to cells in a
similar column in 'B' using a '=' function. the difference is that there is a
gap of six extra rows between the two cells in the second sheet.
I tried to copy and paste down from the first in row 1 (='worksheetA'!B1),
but where I want (=worksheetA'!B2) in Row 7, iI get (='worksheetA'!B7).
Is there an easy way to copy and paste the values or do I have to go through
all of the 1064 references individually?
Thanks for your help.

#2
May 16th 05, 09:21 AM
 Bob Phillips Posts: n/a

Try this formula

=IF( MOD(ROW(),6)=1,INDIRECT("Sheet1!A"&INT(ROW()/6)+1),"")

--
HTH

Bob Phillips

"[email protected] .com" <[email protected]
wrote in message ...
I have two worksheets 'A' and 'B'.
'A' has 1064 rows of data.
'B' has 7448 rows of data.
I want to reference the data from cells in a column of 'A' to cells in a
similar column in 'B' using a '=' function. the difference is that there

is a
gap of six extra rows between the two cells in the second sheet.
I tried to copy and paste down from the first in row 1 (='worksheetA'!B1),
but where I want (=worksheetA'!B2) in Row 7, iI get (='worksheetA'!B7).
Is there an easy way to copy and paste the values or do I have to go

through
all of the 1064 references individually?
Thanks for your help.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 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 mdeanda Excel Worksheet Functions 1 April 22nd 05 08:41 PM Pat Walsh Excel Discussion (Misc queries) 5 January 21st 05 02:57 PM JackRnl Charts and Charting in Excel 1 January 20th 05 01:04 AM Eintsein_mc2 Excel Discussion (Misc queries) 1 January 6th 05 05:02 AM Jana Excel Discussion (Misc queries) 7 December 9th 04 10:18 PM

All times are GMT +1. The time now is 11:09 PM.