How to copy particular data from one excel and paste into another excel

Help Activities
, ,
1

hi,
i have excel_1 file in that column names —Name, Total
another excel_2 file in that columns name, Date,product,Total amount.

i want to copy All Total column Values from excel_1 and paste into into excel_2 Total amount column
can any one help this ?

2

@Anand_Designer …Couple of options without out any code

  1. Read Range = Read the specific column from the sheet and write Range into desired sheet(in your case excel 2)

  2. Copy Range = Using copy range copy the specific column range and again write Range into desired sheet(in your case excel 2)…but i am not positive whether you can point to different WB here…

3

it not working.
Total

300
400
500

i want only above values to from excel_1 to excel_2…

4

@Anand_Designer …pls check this post …

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.