Consolidating Data from Multiple Excel Worksheets By Position

[4782valle]

I have a Workbook containing 2 worksheets. Sheet 1 feeds into sheet 2, which is the consolidated view. I know how to link the sheets with static info, but how can I make it so when i insert a new row in the middle of the already existing data in sheet 1 will show up in sheet 2 (in the right place).

[crashdaveAAKK]

Can you please tell me if it is possible to consolidate text? Such as

sheet 1 cell a1 = aa

sheet 2 cell a2 = bb

sheet 3 after consolidation cell a1 = aa & cell a2 = bb

I tried and cant get it, it would be very useful for my business. Thanks.

[DannyRocksExcels]

@crashdaveAAKK

To create a text string from multiple cells, you use either:

1) The =CONCATENATE() Function

2) The &(Ampersand) operator

You begin with the = (Equal Sign) and your 1st cell reference. Next, type & and your 2nd cell reference. If you wish to have a SPACE in between, you would use =A!&" "&A2. In this case, you surround the "SPACE" with Double Quotation Marks.

Of course, if Cell A2 is on a separate worksheet, you must include the full Path - easiest way is to "click" cell.

[crashdaveAAKK]

@DannyRocksExcels Perfect thanks alot.

[DannyRocksExcels]

@crashdaveAAKK

My pleasure - I am happy that I could assist you!

Danny Rocks

The Company Rocks

[tabrezmohammed]

Thanks Danny, your training is very helpful thnks for sharing these tricks, certinaly it will be very helpful..

Best

Tabrez

[DannyRocksExcels]

@tabrezmohammed

Hello Tabrez -

Thank you for your kind words. I am happy to share my tips and tricks for Excel. I am pleased that you find them helpful.

Danny Rocks

The Company Rocks

[tauqeerrizvi]

Danny ,I love ur all videos ur work are great. Thanks for this video which help me lot.

[DannyRocksExcels]

@tauqeerrizvi

Thank you so much for your kind words! I appreciate you taking the time to add your comments.

I am so happy that I could help you with this topic.

Danny Rocks

The Company Rocks

[sabari1986]

Thanks Danny It is very useful

[DannyRocksExcels]

@sabari1986

My pleasure. Thank you for writing to tell me that the video helped you.

Danny Rocks

The Company Rocks

[DannyRocksExcels]

@ynz321

Ny pleasure. Thank you for writing to tell me this. I enjoy teaching and sharing information with others.

Everyone needs encouragement from time to time.

Sincerely,

Danny Rocks

The Company Rocks