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. |
Try this formula
=IF( MOD(ROW(),6)=1,INDIRECT("Sheet1!A"&INT(ROW()/6)+1),"") -- HTH Bob Phillips "guptasa@gossami .com" <guptasa@gossami 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. |
All times are GMT +1. The time now is 09:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com