Translation - art & business » Translators Associations »
Merging Excel cells
Thread poster: Jean-Christophe Duc
Jean-Christophe Duc
Jean-Christophe Duc  Identity Verified
France
Local time: 19:49
English to French
+ ...
Oct 12, 2016

Is it possible to merge automatically two Excel sheets (say 1 and 2), so that the column A of sheet 2 becomes the column B of sheet 1?

[Edited at 2016-10-12 17:11 GMT]
 
Christian christian@nielsen-palacios.com
Christian [email protected]
United States
Local time: 13:49
English to Spanish
+ ...
Cut and paste? Oct 12, 2016

I am no expert, but cut and paste should work... COPY and paste, to be safe.

[Edited at 2016-10-12 15:43 GMT]
 
Jean-Christophe Duc
Jean-Christophe Duc  Identity Verified
France
Local time: 19:49
English to French
+ ...
TOPIC STARTER
It sure works... Oct 12, 2016

... but when sheets have up to 10 or 20 tabs, it quickly becomes boring.
Hence, an automatic or semi-automatic solution would help...
 
Platary (X)
Platary (X)
Local time: 19:49
German to French
+ ...
A macro Oct 12, 2016

does it very simple. Try something like the following :

Sub CopieAE()

Range("B1").Select
Sheets("Feuil2").Columns("A:C").Copy Sheets("Feuil1").Columns(2)

End Sub

Run this macro in the target sheet and adapt of course the sheet number (or name) to be copied and the range (from to columns).

Done!

Otherwhise you could also wrtite such a following formula (to be adapted of course) in B1 in the target... See more
does it very simple. Try something like the following :

Sub CopieAE()

Range("B1").Select
Sheets("Feuil2").Columns("A:C").Copy Sheets("Feuil1").Columns(2)

End Sub

Run this macro in the target sheet and adapt of course the sheet number (or name) to be copied and the range (from to columns).

Done!

Otherwhise you could also wrtite such a following formula (to be adapted of course) in B1 in the target sheet :

Feuil2!RC[-5]:R[1]C[-5]

which could also be inserted in another macro :

Sub sheetinsheet()

ActiveCell.FormulaR1C1 = "=Feuil2!RC[-5]:R[1]C[-5]"
Range("I1").Select
Selection.AutoFill Destination:=Range("I1:I25"), Type:=xlFillDefault

End Sub

Hope this helps, other possibilities may exist, but i know these are working.

Good luck! ▲ Collapse
 
Jean-Christophe Duc
Jean-Christophe Duc  Identity Verified
France
Local time: 19:49
English to French
+ ...
TOPIC STARTER
Thanks Oct 12, 2016

I'll look into it.
Is there a way to iterate it for n number of tabs?
 
Alison High
Alison High  Identity Verified
Switzerland
Local time: 19:49
French to English
+ ...
use concatenate formula Oct 13, 2016

If the cells you want to merge are A1 and B1 and you want the merged result of A1 and B1 in C1 enter this formula in C1

=CONCATENATE(A1,B1)


To make it work for multiple rows just drag the bottom right corner of C1 (+ shaped cursor) down for as many rows as you want.... this automatically deploys the formula
i.e. row 16 is now =CONCATENATE(A16,B16), which is the result of A16 merged with B16.

If you need to add a space between ... See more
If the cells you want to merge are A1 and B1 and you want the merged result of A1 and B1 in C1 enter this formula in C1

=CONCATENATE(A1,B1)


To make it work for multiple rows just drag the bottom right corner of C1 (+ shaped cursor) down for as many rows as you want.... this automatically deploys the formula
i.e. row 16 is now =CONCATENATE(A16,B16), which is the result of A16 merged with B16.

If you need to add a space between the content of the merged cells

=CONCATENATE(A1," ",B1)


For those using the French-Language version of excel you need the french formula word and semicolons, not commas.


=CONCATENER(A1;" ";B1)
 ▲ Collapse
 
Jean-Christophe Duc
Jean-Christophe Duc  Identity Verified
France
Local time: 19:49
English to French
+ ...
TOPIC STARTER
Thanks, but... Oct 14, 2016

... I need to merge two different sheets, not cells.
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Jorge Rodrigues[Call to this topic]
Nawal Kramer[Call to this topic]

You can also contact site staff by submitting a support request »

Merging Excel cells







Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »