Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine data
i have data in Sheet 1 under cell A1, B10, C5,D7
Sheet 2 under cell A1,B10,C5,D7 Sheet 3 under cell A1,B10,C5,D7 i want to combine the the data in the above 3 sheet in Sheet 4 Sheet A B C D Sheet1 A1 B10 C5 D7 Sheet2 A1 B10 C5 D7 ..ect |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine data
You could put the sheetnames in A2:Axxx
and the addresses in B1:E1 Then put this in B: =INDIRECT("'"&$A2&"'!"&B$1) And drag across and down. osaka78 wrote: i have data in Sheet 1 under cell A1, B10, C5,D7 Sheet 2 under cell A1,B10,C5,D7 Sheet 3 under cell A1,B10,C5,D7 i want to combine the the data in the above 3 sheet in Sheet 4 Sheet A B C D Sheet1 A1 B10 C5 D7 Sheet2 A1 B10 C5 D7 ..ect -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine data | Excel Worksheet Functions | |||
Combine data - Please help | Excel Worksheet Functions | |||
Combine Data | Excel Worksheet Functions | |||
Need to combine and add data | Excel Discussion (Misc queries) | |||
Combine Data | Excel Discussion (Misc queries) |