Merge information from different sheets in to 1
 

I am trying to create a main document that will read various coloumns from
different sheets in a workbook but put them all in one place.

i.e. In Document A I have - page 1 coloumn A, page 2 Column A, Page 3
coloumn A. I want to see all these coloums in Document 2 coulmn A. I want
the coloumn in Page 2 to pick up lines 1 to 1000 in each of Documents A's
pages, missing out any blanks - if possible.
Thanks

Merge information from different sheets in to 1
 

Place one of these in cell A1 of the sheet you want it all to be, the copy
formula down ( autofill)
replace Sheet1 ( names) with your worksheet names
=Sheet1!A1&Sheet2!A1&Sheet3!A1
or use
=CONCATENATE

=CONCATENATE(Sheet1!A1,Sheet2!A1,Sheet3!A1)

"Fiona" wrote:

I am trying to create a main document that will read various coloumns from
different sheets in a workbook but put them all in one place.

i.e. In Document A I have - page 1 coloumn A, page 2 Column A, Page 3
coloumn A. I want to see all these coloums in Document 2 coulmn A. I want
the coloumn in Page 2 to pick up lines 1 to 1000 in each of Documents A's
pages, missing out any blanks - if possible.
Thanks

Merge information from different sheets in to 1
 

Thank you!

"ufo_pilot" wrote:

Place one of these in cell A1 of the sheet you want it all to be, the copy
formula down ( autofill)
replace Sheet1 ( names) with your worksheet names
=Sheet1!A1&Sheet2!A1&Sheet3!A1
or use
=CONCATENATE

=CONCATENATE(Sheet1!A1,Sheet2!A1,Sheet3!A1)

"Fiona" wrote:

I am trying to create a main document that will read various coloumns from
different sheets in a workbook but put them all in one place.

i.e. In Document A I have - page 1 coloumn A, page 2 Column A, Page 3
coloumn A. I want to see all these coloums in Document 2 coulmn A. I want
the coloumn in Page 2 to pick up lines 1 to 1000 in each of Documents A's
pages, missing out any blanks - if possible.
Thanks