This can be done easliy with a macro...are comfortable using a macro
for this?
A couple questions if macros are ok with you:
Does number of rows change regularly ? How many columns do you have?
Do you want formulas on sheet 2 or you just want the values?
wrote:
Data in Sheet1:
A1=5.500 B1=0.275
A2=5.625 B2=0.125
A3=5.750 B3=0.000
A4=5.875 B4= -0.125

Data in Sheet2:
A1=Sheet1!A4 B1=Sheet1!B4
A2=Sheet1!A3 B2=Sheet1!B3
A3=Sheet1!A2 B3=Sheet1!B2
.
.
.
.
Instead of linking the cell manually, what formula or shortcut should I
use to import the data in the sequece I want?