Hi all, I got a question, I have two excels Excel1 and Excel2. I want to append the data of ColumnA of Excel1 with ColumnC of Excel2 Same way ColumnB of Excel1 with ColumnD of Excel2 and ColumnC of Excel1 with ColumnE of Excel2. Note :Both the excels has different Column Names. Can anyone help …

Hi @amitha.aenugula Can you please share sample input excels and expected output. Regards

Hi @amitha.aenugula Can you try the below [image] Cheers!!

Excel 1 |Column 1 | Column 2 | Column 3 | Column 4| |786 | abc | 12345 | cc| |456 | cfg | 7865 | cc| |678 | uyr | 9865 | cc| |675 | adf | 56787 | cc| Excel 2| |Date | CUCC | Name | ACC| |10-12-2024 | 673 | rty | 86| |28-02-2024 | 332 | uyt | 85| |28-02-2024 | 4576 | hgf | 34| |28-02-2024 …

Hi @amitha.aenugula Can you try the below Count_DT=Excel2.Sheet("Sheet1").DataTableValue.Rows.Count+1 [image] BlankProcess20.zip (287.1 KB) Output: [image] Regards,

Hi @amitha.aenugula Check the below zip file. This is done with macros. BlankProcess20.zip (283.7 KB) Hope it helps!!

Append Column

Help Activities

lrtetala (Lakshman Reddy) March 2, 2024, 4:57am 5

Hi @amitha.aenugula

Can you try the below

Count_DT=Excel2.Sheet("Sheet1").DataTableValue.Rows.Count+1

BlankProcess20.zip (287.1 KB)

Output:

Regards,

Excel mapping1

Topic		Replies	Views
Append Excel from one excel column by column Help excel , activities , question	2	829	December 16, 2019
Appending new column in existing excel from another excel Help	6	1972	December 12, 2019
Append columns when columns headers are random Help	11	1379	February 11, 2019
Excel append data Activities excel , studio , form , excel-append	3	1277	August 22, 2022
Append from one excel to another (different location/column) Help	1	997	December 14, 2018

Append Column

Related topics