| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| How can I have the Import External Data dialog pop up on open? | Setting up and Configuration of Excel | |||
| merging sheet1 to sheet2 | Excel Worksheet Functions | |||
| import data with macro | Excel Discussion (Misc queries) | |||
| import data using macro | Excel Discussion (Misc queries) | |||
Threaded Mode
