| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Enter data from same cell in different sheets into a new sheet
I Have for example text in A1 on 4 sheets.
I want to have all that data on a new sheet either in a column or row. For example Sheet 1 A1 says date1 Sheet 2 A1 says date2 Sheet 3 A1 says date3 Sheet 4 A1 says date4 New sheet wahts to show Date1 date2 date3 date4 Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Enter data from same cell in different sheets into a new sheet
=INDIRECT("'Sheet "&COLUMN()&"'!A1") and copy across
-- David Biddulph "Phippsy" wrote in message ... I Have for example text in A1 on 4 sheets. I want to have all that data on a new sheet either in a column or row. For example Sheet 1 A1 says date1 Sheet 2 A1 says date2 Sheet 3 A1 says date3 Sheet 4 A1 says date4 New sheet wahts to show Date1 date2 date3 date4 Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Enter data from same cell in different sheets into a new sheet
Apply the below formula and copy down to 3 cells
=INDIRECT("'Sheet"&ROW(A1)&"'!A1") OR 'if there is a space between Sheet and the numeric part like 'Sheet 1' =INDIRECT("'Sheet "&ROW(A1)&"'!A1") If this post helps click Yes --------------- Jacob Skaria "Phippsy" wrote: I Have for example text in A1 on 4 sheets. I want to have all that data on a new sheet either in a column or row. For example Sheet 1 A1 says date1 Sheet 2 A1 says date2 Sheet 3 A1 says date3 Sheet 4 A1 says date4 New sheet wahts to show Date1 date2 date3 date4 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enter data in the same column in multiple sheets | New Users to Excel | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| Lookup info in support sheets and enter in summary sheet | Excel Discussion (Misc queries) | |||
| how do i enter data in multiple sheets simultaneously | Excel Worksheet Functions | |||
| enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
Linear Mode
