Merging - alternating row logic.

[Sigurd]

Hi,

I don't know if this is in the right section, but here goes.

I have the following challenges.
1 . I want to merge two worksheets into one, but the rows needs to alternate into the new sheet.
ex:

sheet A
1
2
3
4

sheet B
1
2
3
4

Sheet C
1: A1
2: B1
3: A2
4: B2
5: A3
6: B3
7: A4
8: B4

2. I want to take a sheet and make a new sheet:
ex:

Sheet A
1
2
3

Sheet B
1: A1
2: A1
3: A2
4: A2
5: A3
6: A3

I am making a script for data input - which is why the awkward setup.
I have tried formulas Cell() and INDIRECT() without success. The problem is always the row number reference increasing exponentially.

[dredwolf]

would need a sample of the formulas you are actually using (to see what they are actually doing) but it sounds like you have a multiplication factor (*) involved in your fomula's somewhere

[Pete_UK]

For your first query, you can use this formula in A1 in the third sheet:

=IF(MOD((ROWS($1:1)-1),2)=0,INDEX('Sheet A'!A:A,INT((ROWS($1:1)-1)/2)+1),INDEX('Sheet B'!A:A,INT((ROWS($1:1)-1)/2)+1))

then copy down.

For your second query, you can use this:

=INDEX('Sheet A'!A:A,INT((ROWS($1:1)-1)/2)+1)

and copy that down.

Hope this helps.

Pete

EDIT: Sample file attached

[Sigurd]

For your first query, you can use this formula in A1 in the third sheet:

=IF(MOD((ROWS($1:1)-1),2)=0,INDEX('Sheet A'!A:A,INT((ROWS($1:1)-1)/2)+1),INDEX('Sheet B'!A:A,INT((ROWS($1:1)-1)/2)+1))

then copy down.

For your second query, you can use this:

=INDEX('Sheet A'!A:A,INT((ROWS($1:1)-1)/2)+1)

and copy that down.

Hope this helps.

Pete

Fantastic... it works.

Even with my slight modification
ex
Sheet A:
Column A--------------------------------- Column B ---------------------------------- Coulumn C
1 (Headers different from other sheets)
2 =INDEX(B!A:A;INT((ROWS($1:3)-1)/2)+1) =INDEX('C'!B:B;INT((ROWS($1:3)-1)/2)+1) =INDEX(B!E:E;INT((ROWS($1:3)-1)/2)+1)
3 =INDEX(B!A:A;INT((ROWS($1:4)-1)/2)+1) =INDEX('C'!B:B;INT((ROWS($1:4)-1)/2)+1) =INDEX(B!K:K;INT((ROWS($1:4)-1)/2)+1)

selecting the two rows (2 & 3) and copying them to n rows gives the alternation between column E and K that I desired...

Thanks!