| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to combine several files, all with same columns, into one shee
Let say there is 3 excel files. Each file has one sheet and the same columns,
e.g. column A: product name column B: description Column C: Price How can I combine all the 3 sheets in different files into one sheet of a new file? I don't want to copy and paste, because in reality, I have more than 100 files like this. Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel ignores "Text qualifiers" in Unicode files | Excel Discussion (Misc queries) | |||
| Combine two or more columns by using a function | Excel Discussion (Misc queries) | |||
| Columns | Excel Discussion (Misc queries) | |||
| combine columns | Excel Worksheet Functions | |||
| how do i combine columns in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
