copy exact values from RangeA to Range B which has extra rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try this formula

=IF( MOD(ROW(),6)=1,INDIRECT("Sheet1!A"&INT(ROW()/6)+1),"")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Need help in comparing two worksheets 1
Search a worksheet, extract rows using a list from another sheet 9
Search range, find value in another col in corresponding row 3
QUICK HELP - Retrieve value based on two column criteria 1
Deleting Row 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Summing rows using formulas with variables 1

Back
Top