| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add information from multiple sheets into one box on another sheet | Excel Discussion (Misc queries) | |||
| Office 2003 merge questions | Excel Worksheet Functions | |||
| Align information in multiple sheets | Excel Discussion (Misc queries) | |||
| Help :Merge 2 employee information tables | Excel Discussion (Misc queries) | |||
| Word found no merge fields in your main document. | Excel Discussion (Misc queries) | |||
Linear Mode
