| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 96681 | 2009-01-19 03:40:00 | Combining Excel (07) Sheets | taxboy4 (579) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 740184 | 2009-01-19 03:40:00 | Hi , is there an easy way to merge the data lines in several Excel sheets (from within the same workbook?) Thanks |
taxboy4 (579) | ||
| 740185 | 2009-01-19 03:59:00 | Sorry, don't understand you. Data lines? Do you mean multiple cells? If so, for example, you want to combine the text in C1, C2, and C3. Type concatenate(C1,C2,C3) |
the_bogan (9949) | ||
| 740186 | 2009-01-19 04:56:00 | If your sheets are all the same layout you can use this formula to sum the values across the sheets for the same cell reference =SUM(Sheet1:Sheet6!A1). This is where Sheet1 is the first sheet and Sheet6 is the last Sheet. These sheets have to be contiguous within the spreadsheet. Then it is just a matter of copying the formula across the require range in the sheet where you are totaling the values |
TeejayR (4271) | ||
| 740187 | 2009-01-21 03:33:00 | Sorry, don't understand you. Data lines? Do you mean multiple cells? If so, for example, you want to combine the text in C1, C2, and C3. Type concatenate(C1,C2,C3) Sorry, I am not being clear I have a excel file with data on several sheets - one month per sheet, I want an easy way to merge all the sheets into one so I don't have to cut and paste the data from each sheet into the lead one? Cheers |
taxboy4 (579) | ||
| 1 | |||||