I have to apply filter in Column Subject , If Column Subject has value other than English ,I have to paste values in Column Subject same as of Column Marks .

Then u can directly use Formula for this say =IF(A2=“English”,0,A2) Use this formula in B2 and then using Read Range, count the rows say Count=Dt.Rows.Count+1 it will give you count then use Auto Fill Range in that pass Sheet Name and Source Range will be B2 and destination Range will be **…

Copy value from one column to another column

Learning Hub Academy Feedback

anandji05 (ANAND PRIYA TRIPATHI) September 5, 2020, 8:57am 2

@Ananya1

Are you reading data from xlsx file?

How to copy one column data into another cloumn in the same excel?

Topic		Replies	Views
Copy cell value from excel 1 and paste the contents of excel to excel 2 , by adding another column in excel 2 Help excel , activities , question	9	1790	August 20, 2019
How to filter value from excel cell and replace the cells with other value Help	16	3049	September 12, 2019
Matching the rows and columns to copy and paste from one excel to another excel Help	9	2505	February 27, 2020
Excel row checking Help	12	1454	October 2, 2019
Enter data respect to column name Help excel	17	2356	August 22, 2018

Copy value from one column to another column

Related topics