| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining data from multiple worksheets.
I have 3 worksheets (W1, W2, W3). W1 has data in cells A1 through A10 (in a
worksheet that has 25 rows). W2 has data in cells A1 through A5 (in a worksheet that has 25 rows). I would like W3 to list W1 A1:A10, then W2 A1:A5 in its A column, but ignoring any blank rows. HELP!!!! I know there must be an easy way to do this! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Multiple Worksheets | Excel Discussion (Misc queries) | |||
| combining multiple worksheets | Excel Discussion (Misc queries) | |||
| Combining multiple worksheets | Excel Worksheet Functions | |||
| Combining data from multiple worksheets and separate spreadsheets | Excel Discussion (Misc queries) | |||
| Combining specific ranges from multiple worksheets into one | Excel Worksheet Functions | |||
Threaded Mode
