Join sheet in excel 2007

Hay everyone

i have a question, how can we join several sheets in excel 2007, but if these several sheets have identical content, it wouldn't replace, all content showed in the new sheet

thanks for the answer

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Here you go, sheet 1 - sheet 3 in complie sheet

is there any instan way to compile all sheet?

thanks

Try array entering this formula in A3 of 'Compile'. Fill down and across. Then select / copy A3:G13 and paste into I3 and Q3.
If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

This formula is shorter and doesn't have to be array entered.

Formula:

Please Login or Register  to view this content.

thanks FlameRetired

this's more simple formula

so much help, thanks

@Adekinteristi - please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.

Originally Posted by adekinteristi

thanks FlameRetired

You're welcome. Thanks for the feedback, rep and marking your thread Solved.