| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cells into range of cells until cell change | Excel Worksheet Functions | |||
| Creating an EXCEL COUNTIF formula for a range of values | Excel Discussion (Misc queries) | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| Copy values from Sheet1 to Sheet2 | Excel Discussion (Misc queries) | |||
| Counting values within a Date Range | Excel Discussion (Misc queries) | |||
Linear Mode
