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.

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