Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Append worksheets together in one
Hello,
I need your help please. First, 4 worksheets have a same format (# of columns, rows, and labels are the same for each col.). How do I comebine or append them together (from sheet1-4)? For sample, A B C Sheet 1 test1 test2 test3 Sheet 2 test4 test5 test6 Sheet 3 test7 test8 test9 Sheet 4 test10 test11 test12 So, the master should look like this: Sheet5: A B C test1 test2 test3 test4 test5 test6 test7 test8 test9 test10 test11 test12 Thanks alot! |
#2
|
|||
|
|||
The best is, on your summary sheet, highlight all the cells where you want
the figures to appear. Then in the first highlighted cell type =sum( you then select sheet1:sheet4 using your shift key. Then you click on the first cell which you want to have a summary of and press Ctrl+Enter together. You will find that all your information is automatically summarised and copied across. "bioyyy" wrote: Hello, I need your help please. First, 4 worksheets have a same format (# of columns, rows, and labels are the same for each col.). How do I comebine or append them together (from sheet1-4)? For sample, A B C Sheet 1 test1 test2 test3 Sheet 2 test4 test5 test6 Sheet 3 test7 test8 test9 Sheet 4 test10 test11 test12 So, the master should look like this: Sheet5: A B C test1 test2 test3 test4 test5 test6 test7 test8 test9 test10 test11 test12 Thanks alot! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Worksheets | Excel Discussion (Misc queries) | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Protect/unprotect all worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |