Thread: How to import data from Sheet1 to Sheet2 in the order I want
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] zoeteh@gmail.com is offline
external usenet poster
  
Posts: 1
Default How to import data from Sheet1 to Sheet2 in the order I want
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?

Reply With QuoteReply With Quote