Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort data
Hi,
I have a set of data in 3 spreadsheets and needs to be combined into 1. Each spreadsheet, col B-E is staff details (emp no, name..etc). Data contains in column F onwards are different. ie: Sheet 1 : heading of Col F = Training A, Col G = Training B Sheet 2 : heading of Col F = Training C, Col G = Training D Sheet 3 : heading of Col F = Training E, Col G = Training F Now, How do I combine all the Training A - F to same row in a sheet? Appreciate if someone could give me a shortcut/formula to do it... Thanks a zil.. Jessie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
Pls. reply Sort Data and copy to next coulmn when sort order chang | Excel Programming | |||
Sort Data and copy to next coulmn when sort data changes | Excel Programming | |||
Sort Data and copy to next coulmn when sort data changes | Excel Programming | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) |