| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sort Data into new spreadsheet based on cell value
Hi all
I am stumped on this one. I need to create a new spreadsheet based on the main data spreadsheet (see attached example). I need to sort based on a non-blank cell in column E then further sort that based on non - blank cells in columns F to AP. I than need to create another new spreadsheet (report) for each column. I'd like this to be automated so that I don't have to do anything complicated each time I need this data. I hope that makes sense. Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to sort spreadsheet based on values in Column A | Excel Discussion (Misc queries) | |||
| How to sort, based upon the length of the data ? | Excel Discussion (Misc queries) | |||
| Organizing data to sort in a spreadsheet. | Excel Worksheet Functions | |||
| How do I sort an excel spreadsheet based off of subtotals? | Excel Worksheet Functions | |||
| How can I sort a spreadsheet of data by colour? | Excel Discussion (Misc queries) | |||
Threaded Mode
