How to Link 2 Sheets with different formats

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

Guest

I have two sheets that I want to link however the two sheets have different
formats. Sheet one has data entered every row, but sheet two is required to
have data entered every 10 rows. If possible, how do I accomplish this?
 
Not sure, but you could be refering to
something along these lines ..

Assume you have in Sheet1,
cols A and B, data from row2 down

1 11 < in row2
2 22
3 33
4 44
5 55
6 66
7 77
8 88
9 99
10 110
11 121
12 132
etc

In Sheet2
------------
Put in A2:

=OFFSET(Sheet1!$A$2,ROWS($A$1:A1)*10-10,COLUMNS($A$1:A1)-1)

Copy A2 across to B2, fill down until zeros appear, signalling exhaustion of
data from Sheet1

For the sample data in Sheet1, you'll get:

1 11
11 121
etc

which is the data extracted from Sheet1 every 10 rows, commencing with row2

Adapt to suit ..

E.g.: change ROWS($A$1:A1)*10-10
to say: ROWS($A$1:A1)*5-5
if the interval is every 5 rows, instead of 10 rows
 
And for a cleaner look, we could suppress extraneous zeros
from showing in Sheet2 via clicking:
Tools > Options > View tab > Uncheck "Zero values" > OK
 
Back
Top