| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
pull data from a table and sort into list
I have a timetable where with the date show at row 1 (from B1 to CC1) and
time at column A (from A2 to A30). The rest of the data are the subjectID (about 20 subjects) which fall on different day and time. I would like to pull out the data and sort into a list format whereby Date at Column A, SubjectID at Column C and Time at Column B in new spreadsheet. Those dates with no lesson/no subjectID will not be captured. Can the excel functions do that? Or how to write a macro on this? Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull recent pricing data from table | Excel Worksheet Functions | |||
| Pull Pivot Table Data | Excel Discussion (Misc queries) | |||
| Pull pivot table data | Excel Discussion (Misc queries) | |||
| Pull list / dropdown data from another worksheet? | Excel Discussion (Misc queries) | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Threaded Mode
