| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sort data from 1 work sheet into another
I have 9 columns of data in sheet 1 and need to paste data from column H in sheet 1 to a specific column in sheet 2. The data that I need sorted before pasting it into sheet 2 needs to meet a certain criteria, ie; column H in sheet 1 has numbers ranging from 0 to 100000. I need to sort out the numbers between 0 and 50000 and paste these numbers into sheet 2 into column D.
I know there is a formula to do this but I cannot find it anywhere, can you please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation doesn't work on 1 sheet only | Excel Discussion (Misc queries) | |||
| How to populate one sheet with data from another sheet | New Users to Excel | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
| Keeping Row 1 at the top during a Data Sort... | Excel Worksheet Functions | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Linear Mode
