Merging Excel cells
Thread poster: Jean-Christophe Duc

Jean-Christophe Duc  Identity Verified
France
Local time: 12: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 Nielsen-Palacios  Identity Verified
United States
Local time: 06:49
Member
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  Identity Verified
France
Local time: 12: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...


 

Adrien Esparron
Local time: 12:49
Member (2007)
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 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!


 

Jean-Christophe Duc  Identity Verified
France
Local time: 12: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  Identity Verified
Switzerland
Local time: 12:49
Member (2003)
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 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)


 

Jean-Christophe Duc  Identity Verified
France
Local time: 12: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:


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

Merging Excel cells

Advanced search







TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search