| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Take 3 columns, one per sheet and turn it into one on 4th sheet
I need to take one column in each of the 3 sheets in my workbook and append
them to each other in a 4th sheet in the same workbook. How do I do this? I have tried consolidation but it doesn't seem to work.... Please help. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Take 3 columns, one per sheet and turn it into one on 4th sheet
Use the following function: =CONCATENATE(Sheet1!A1,Sheet2!A1,Sheet3!A1) The concatenate will be in your Sheet 4. If you have 4 sheets - the easiest way is on the MENU Bar - just click on WINDOW 4 times and then select WINDOW - ARRANGE - HORIZONTAL -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=512905 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn Off Continuous Page Numbering in Workbook | Excel Discussion (Misc queries) | |||
| Extract sheet name/number to cell | Excel Discussion (Misc queries) | |||
| Link to Workbook | Excel Discussion (Misc queries) | |||
| Clicking cells on sheet creates Text Box. How do I turn this off? | Excel Discussion (Misc queries) | |||
| Making Rows into Columns | Excel Discussion (Misc queries) | |||
Linear Mode
