Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 16th 05, 08:39 AM
 
Posts: n/a
Default 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   Report Post  
Old May 16th 05, 09:21 AM
Bob Phillips
 
Posts: n/a
Default

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.





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
Copy cells into range of cells until cell change mdeanda Excel Worksheet Functions 1 April 22nd 05 08:41 PM
Creating an EXCEL COUNTIF formula for a range of values Pat Walsh Excel Discussion (Misc queries) 5 January 21st 05 02:57 PM
Second serie doesn't use X-as values JackRnl Charts and Charting in Excel 1 January 20th 05 01:04 AM
Copy values from Sheet1 to Sheet2 Eintsein_mc2 Excel Discussion (Misc queries) 1 January 6th 05 05:02 AM
Counting values within a Date Range Jana Excel Discussion (Misc queries) 7 December 9th 04 10:18 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017