Ranges
 

All -

I have two columns; Range1 and Range2 respectively. If for example, Range1
has a value of 20 and Range2 has a value of 44 - I need to take all the
values between those two and put them into a new worksheet so it will have
one column that has 20, 21, 22, 23, 24 etc. as the records. It then needs to
go to the next row in Sheet 1 - and look at the Range1 and Range2 and
transpose all those values in the new worksheet.

Can anybody advise?

Thanks!

Hi

With headers in row 1 on both sheets, and data on Sheet1 in columns A:B, the
formula for row 2 on Sheet2, which returns the first value determined by
values in Sheet1!A2:B2, will be:
=IF(OR(Sheet1!$A2="",Sheet1!$B2="",Sheet1!$A2+COLU MN()-1Sheet1!$B2),"";Shee
t1!$A2+COLUMN()-1)

Copy the formula to range of desired width and depth on Sheet2.


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"Mona" wrote in message
...
All -

I have two columns; Range1 and Range2 respectively. If for example,
Range1
has a value of 20 and Range2 has a value of 44 - I need to take all the
values between those two and put them into a new worksheet so it will have
one column that has 20, 21, 22, 23, 24 etc. as the records. It then needs
to
go to the next row in Sheet 1 - and look at the Range1 and Range2 and
transpose all those values in the new worksheet.

Can anybody advise?

Thanks!