Take 3 columns, one per sheet and turn it into one on 4th sheet

L

Lori

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.
 
W

wjohnson

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
 
Top